PHP+Mysql+jQuery+fullcalendar实现的微型公司内部订餐系统

本文涉及到的插件: jQuery, jQuery.UI, fullcalendar

数据库教程创建:

CREATE TABLE USER
(
  ID INT PRIMARY KEY AUTO_INCREMENT,
  NAME VARCHAR(100)
);

CREATE TABLE ITEM
(
  ID INT PRIMARY KEY AUTO_INCREMENT,
  USER_ID INT,
  FOOD TINYBOLB,
  ORDER_TIME TIMESTAMP
);

ALTER TABLE ITEM ADD FOREIGN KEY(USER_ID) REFERENCES USER(ID) ON DELETE CASCADE;

一个实体的基类, 封装的不太好: Entity.php教程

PHP code

用户类(这个里面是没有权限, 登录的概念的, 就公司内部一个小东西): User.php

PHP code
require_once './Entity.php';

/**
 * 用户实体类
 * @author selfimpr
 * @blog http://blog.111com.net/lgg201
 * @email lgg860911@yahoo.com.cn
 *
 */
class User extends Entity {
    private $id;
    private $name;
   
    public function User($id = NULL, $name = NULL) {
        $this->id = $id;
        $this->name = $name;
    }
   
    public function getId() {
        return $this->id;
    }
    public function setId($id) {
        $this->id = $id;
        return $this;
    }
    public function getName() {
        return $this->name;
    }
    public function setName($name) {
        $this->name = $name;
        return $this;
    }
}
?>

订餐订单项类: Item.php

PHP code
require_once './Entity.php';
/**
 * 订餐订单
 * @author selfimpr
 * @blog http://blog.111com.net/lgg201
 * @email lgg860911@yahoo.com.cn
 *
 */
class Item extends Entity {
    private $id;
    private $user;
    private $food;
    private $orderTime;
   
    public function Item($id = NULL, $food = NULL, $orderTime = NULL) {
        $this->id = $id;
        $this->food = $food;
        $this->orderTime = $orderTime;
    }
   
    public function getId() {
        return $this->id;
    }
    public function setId($id) {
        $this->id = $id;
        return $this;
    }
    public function getUser() {
        return $this->user;
    }
    public function setUser($user) {
        $this->user = $user;
        return $this;
    }
    public function getFood() {
        return $this->food;
    }
    public function setFood($food) {
        $this->food = $food;
        return $this;
    }
    public function getOrderTime() {
        return $this->orderTime;
    }
    public function setOrderTime($orderTime) {
        $this->orderTime = $orderTime;
        return $this;
    }
}
?>

数据库工具类: mysql教程_util.php

PHP code
/**
 * Mysql工具类
 * @author selfimpr
 * @blog http://blog.111com.net/lgg201
 * @email lgg860911@yahoo.com.cn
 *
 */
class Mysql {
    private $host;
    private $username;
    private $password;
    private $db_name;
    private $character_set;
   
    public function __construct(
            $host = "192.168.2.10",
            $username = "root",
            $password = "jhx",
            $db_name = "eat",
            $character_set = "GBK") {
        $this->host = $host;
        $this->username = $username;
        $this->password = $password;
        $this->db_name = $db_name;
        $this->character_set = $character_set;
    }
   
    public function getConn() {
        $conn = mysql_connect($this->host, $this->username, $this->password) or die('数据库连接失败');
        mysql_select_db($this->db_name, $conn);
        mysql_set_charset($this->character_set, $conn);
        return $conn;
    }
   
    /**
     *
     * @param $sql 查询用的sql
     * @param $result 查询得到的结果集, 如果UPDATE, INSERT, DELETE 不同提供这个参数
     * @return SELECT 返回查询得到的条数, UPDATE, INSERT, DELETE返回bool型, 标识是否执行成功.
     */
    public function execute($sql) {
        $conn = $this->getConn();
        $resultset = mysql_query($sql, $conn) or die(mysql_error($conn));
        if(!is_bool($resultset)) {
            while($line = mysql_fetch_assoc($resultset)) {
                $result[] = $line;
            }
        } else {
            $result = $resultset;
        }
       
        mysql_close($conn) or die(mysql_error($conn));
       
//        echo "【".$sql."】 excute success!
";
       
        return $result;
    }

}
?>

PHP code
require_once './mysql_util.php';
require_once './User.php';
require_once './Item.php';

/**
 * 获取当前库中所有的用户
 * @return unknown_type
 */
function getUsers() {
    $util = new Mysql();
    $users_data = $util->execute("SELECT * FROM USER");
    foreach($users_data as $index => $data) {
        $user = new User();
        foreach($data as $column_name => $value) {
            $user->set(User::getField($column_name), $value);
        }
        $users[] = $user;
    }
    return $users;
}

/**
 * 根据名字增加一个用户
 * @param $name
 * @return unknown_type
 */
function addUser($name) {
    $util = new Mysql();
    $name = iconv("UTF-8", "gbk" , $name);
    return $util->execute("INSERT INTO USER VALUES(NULL, '$name')");
}

/**
 * 根据id删除一个用户
 * @param $id
 * @return unknown_type
 */
function deleteUser($id) {
    $util = new Mysql();
    return $util->execute("DELETE FROM USER WHERE ID = $id");
}

/**
 * 根据id修改姓名
 * @param $id
 * @param $name
 * @return unknown_type
 */
function updateUser($id, $name) {
    $util = new Mysql();
    return $util->execute("UPDATE USER SET NAME = '$name' WHERE ID = $id");
}

/**
 * 插入一条订餐记录
 * @param $user_id
 * @param $food
 * @return unknown_type
 */
function addItem($user_id, $food, $ordertime) {
    $util = new Mysql();
    $year = date('Y', $ordertime);
    $month = date('n', $ordertime);
    $day = date('j', $ordertime);
    $hour = (date('G', $ordertime) + 8) % 24;
    $flag = $hour < 13;
    $item = getItemByTimeAndUser($year, $month, $day, $flag, $user_id);
    $ordertime = "$year-$month-$day $hour:00:00";
    $item && ($item = $item[0]) && ($flag = $flag ? ' < ' : ' >= ');
    return $item
            ? $util->execute("UPDATE ITEM SET FOOD = '$food' WHERE USER_ID = $user_id AND YEAR(ORDER_TIME) = $year AND MONTH(ORDER_TIME) = $month AND DAY(ORDER_TIME) = $day AND HOUR(ORDER_TIME) $flag 13")
            : $util->execute("INSERT INTO ITEM(USER_ID, FOOD, ORDER_TIME) VALUES($user_id, '$food', '$ordertime')");
}

/**
 * 获取某天上午或下午的订餐
 * @param $year
 * @param $month
 * @param $day
 * @param $flag 上午true下午false
 * @return unknown_type
 */
function getItemsByTime($year, $month, $day, $flag) {
    $util = new Mysql();
    $flag = $flag ? ' < ' : ' >= ';
    $item_datas = $util->execute("SELECT ITEM.*, USER.NAME FROM ITEM JOIN USER ON ITEM.USER_ID = USER.ID WHERE YEAR(ORDER_TIME) = $year AND MONTH(ORDER_TIME) = $month AND DAY(ORDER_TIME) = $day AND HOUR(ORDER_TIME) $flag 13");
    if(empty($item_datas)) return array();
    foreach($item_datas as $index => $data) {
        $item = new Item();
        $items[$data['USER_ID']] = $item->setId($data['ID'])
                        ->setUser(new User($data['USER_ID'], $data['NAME']))
                        ->setFood($data['FOOD'])
                        ->setOrderTime(date($data['ORDER_TIME']));
    }
    return $items;
}

/**
 * 根据用户id, 时间, 获取其订饭记录
 * @param $year
 * @param $month
 * @param $day
 * @param $flag
 * @param $user_id
 * @return unknown_type
 */
function getItemByTimeAndUser($year, $month, $day, $flag, $user_id) {
    $util = new Mysql();
    $flag = $flag ? ' < ' : ' >= ';
    $item_datas = $util->execute("SELECT ITEM.*, USER.NAME FROM ITEM JOIN USER ON ITEM.USER_ID = USER.ID WHERE YEAR(ORDER_TIME) = $year AND MONTH(ORDER_TIME) = $month AND DAY(ORDER_TIME) = $day AND HOUR(ORDER_TIME) $flag 13 AND ITEM.USER_ID = $user_id");
    echo "SELECT ITEM.*, USER.NAME FROM ITEM JOIN USER ON ITEM.USER_ID = USER.ID WHERE YEAR(ORDER_TIME) = $year AND MONTH(ORDER_TIME) = $month AND DAY(ORDER_TIME) = $day AND HOUR(ORDER_TIME) $flag 13 AND ITEM.USER_ID = $user_id";
    if(empty($item_datas)) return array();
    foreach($item_datas as $index => $data) {
        $item = new Item();
        $items[] = $item->setId($data['ID'])
                        ->setUser(new User($data['USER_ID'], $data['NAME']))
                        ->setFood($data['FOOD'])
                        ->setOrderTime(date($data['ORDER_TIME']));
    }
    return $items;
}
?>

单元测试: test.unit.php

PHP code

require_once './mysql_util.php';
require_once './bussiness.php';

/**
 * 本程序业务逻辑之下部分的单元测试
 * @author selfimpr
 * @blog http://blog.111com.net/lgg201
 * @email lgg860911@yahoo.com.cn
 */

/**
 * 测试用例1: 数据库连接
 */
//$util = new Mysql();
//$res = $util->execute('SHOW TABLES');
//print_r($res);
//echo '
==========数据库连接成功===========
';

/**
 * 测试用例2: 获取所有用户
 */
//var_dump(getUsers());

/**
 * 测试用例3: 增加用户
 */
//var_dump(addUser("张三"));

/**
 * 测试用例4: 删除用户
 */
//var_dump(deleteUser(4));

/**
 * 测试用例5: 更新用户
 */
//var_dump(updateUser(5, '李四'));

/**
 * 测试用例6: 插入订餐项
 */
//var_dump(addItem(1, '辣子鸡丁'));

/**
 * 测试用例7: 获取某天上午或下午订餐
 */
//var_dump(getItemsByTime(2010, 6, 4, false));

/**
 * 测试用例8: 获取某人某天上午或下午订餐
 */
//var_dump(getItemByTimeAndUser(date('Y'), date('m'), date('d'), date('H') + 8 < 13, 1));
?>

添加用户的Ajax接口: addUser.php

PHP code
require_once './bussiness.php';

/**
 * 添加用户ajax请求
 */
return addUser($_POST['name']);
?>
删除用户的ajax接口: delUser.php

PHP code
require_once './bussiness.php';

/**
 * 删除用户ajax请求
 */
return deleteUser($_POST['id']);
?>

提交订餐项的ajax接口: submitItem.php

PHP code
require_once './bussiness.php';

$userId = $_POST['userId'];
$food = $_POST['food'];
$t = $_POST['t'];

/**
 * 提交一个订餐请求的ajax地址
 */
echo (string)addItem($userId, $food, $t);
?>

展现订餐项的视图: viewItems.php

PHP code
/**
 * 展现某个订餐时间的所有订餐项
 */
require_once './bussiness.php';
$t = $_GET['t'];
$year = date('Y', $t);
$month = date('n', $t);
$day = date('j', $t);
$hour = (date('G', $t) + 8) % 24;
$flag = $hour < 13;
$items = getItemsByTime($year, $month, $day, $flag);
$users = getUsers();
?>

展现所有用户的视图: viewUsers.php

PHP code
require_once './bussiness.php';

/**
 * 系统中用户的管理界面
 * @author selfimpr
 * @blog http://blog.111com.net/lgg201
 * @email lgg860911@yahoo.com.cn
 */

$users = getUsers();
?>

javascript教程: event.keyCode == 13 && $('#new_user').click();" />新增
if(empty($users)) return ;
?>

系统的入口: index.php

PHP code
/**
 * 程序入口
 */
?>













加人

系统涉及的javascript: eat.js

PHP code
$(document).ready(function() {
    /**
     * 计算一月有多少天
     */
    function daysInMonth(month,year) {
        var dd = new Date(year, month, 0);
        return dd.getDate();
    }
    /**
     * 预置日历初始化使用日期, 当天
     */
    var date = new Date();
    var d = date.getDate();
    var m = date.getMonth();
    var y = date.getFullYear();
   
    /**
     * 初始化日历中每天里面的上下午日程
     */
    var day_nums = daysInMonth(m, y);
    var events = new Array();
    for(var i = 1; i < day_nums; i ++) {
        events.push({
            title: '上午吃啥',
            start: new Date(y, m, i, 1),
            end: new Date(y, m, i, 11)
        });
        events.push({
            title: '下午吃啥',
            start: new Date(y, m, i, 14),
            end: new Date(y, m, i, 23)
        });
    }
   
    /**
     * 初始化日历
     */
    $('#calendar').fullCalendar({
        year: y,
        month: m,
        day: d,
        defaultView: 'month',
        events: events,
        header: {left: '', center: 'title', right: ''},
        asp教程ectRatio: 1.6,
        weekMode: 'variable',
        eventClick: function(calEvent, jsEvent, view) {
            /**
             * 日程被点击后, 加载该时段的订餐视图
             */
            $('