餐厅预订分析

http://localhost/store.php?ctl=order&act=submit&is_ajax=1&deal_type=0
module：app/Lib/store/orderModule.class.php
action：submit

public function submit(){
    convert_req($_REQUEST);
    foreach($_REQUEST as $k=>$v)
    {
        $_REQUEST[$k] = htmlspecialchars(addslashes(trim($v)));
    }
    $is_ajax = intval($_REQUEST['is_ajax']);
    //预订类型,0为餐厅，1为KTV
    $deal_type = intval($_REQUEST['deal_type']);

    //判断提交是否过快if(!check_ipop_limit(get_client_ip(),"store_order",intval(app_conf("SUBMIT_DELAY")))){
        if($is_ajax==1)
            ajax_return(array("status"=>false,"message"=>$GLOBALS['lang']['SUBMIT_TOO_FAST']));
        else
        {
            showErr($GLOBALS['lang']['SUBMIT_TOO_FAST']);
        }
    }

    //餐厅id
    $sid = intval($_REQUEST['sid']);
    //获取餐厅信息
    $store = $GLOBALS['db']->getOne("SELECT count(*) FROM ".DB_PREFIX."supplier_location WHERE one_line_order=1 AND id=".$sid);
    //如果不存在提示用户该餐厅不存在
    if($store <= 0){
        if($is_ajax==1)
            ajax_return(array("status"=>false,"message"=>$GLOBALS['lang']['NO_STORE_INFO']));
        else
            showErr($GLOBALS['lang']['NO_STORE_INFO']);
    }

    //订餐日期
    $orderDate = trim($_REQUEST['orderDate']);

    //
    if(empty($orderDate)){
        $tip ="就餐日期不能为空!";
        if($deal_type==1){
            $tip ="K歌日期不能为空!";
        }
        if($is_ajax==1)
            ajax_return(array("status"=>false,"message"=>$tip));
        else
            showErr($tip);
    }

    //用餐时间(小时)
    $orderHour = trim($_REQUEST['orderHour']);
    if(empty($orderHour)){
        $tip ="我们需要知道您具体几点就餐!";
        if($deal_type==1){
            $tip ="我们需要知道您具体几点K歌!";
        }
        if($is_ajax==1)
            ajax_return(array("status"=>false,"message"=>$tip));
        else
            showErr($tip);
    }

    //用餐时间(分)
    $orderMini = trim($_REQUEST['orderMini']);
    if(empty($orderMini)){
        $tip ="我们需要知道您大致就餐分钟!";
        if($deal_type==1){
            $tip ="我们需要知道您大致K歌分钟!";
        }
        if($is_ajax==1)
            ajax_return(array("status"=>false,"message"=>$tip));
        else
            showErr($tip);
    }

    //用餐人数
    $orderNums =  intval($_REQUEST['orderNums']);
    if($orderNums == 0)
    {
        $tip ="我们需要知道有几人就餐!";
        if($deal_type==1){
            $tip ="我们需要知道有几人K歌!";
        }
        if($is_ajax==1)
            ajax_return(array("status"=>false,"message"=>$tip));
        else
            showErr($tip);
    }

    //大厅或者包厢
    if(!isset($_REQUEST['seatStatus'])){
        $tip ="您还未选择您的座位要求!";
        if($deal_type==1){
            $tip ="您还未选择您的包厢要求!";
        }
        if($is_ajax==1)
            ajax_return(array("status"=>false,"message"=>$tip));
        else
            showErr($tip);
    }

    //订座类型
    $seatStatus = intval($_REQUEST['seatStatus']);
    //包房设有最低消费金额，您能接受
    $minExpense = trim($_REQUEST['minExpense']);
    //订不到包房就订大厅
    $seatSwitch = intval($_REQUEST['seatSwitch']);
    //联系电话
    $orderMyTel = trim($_REQUEST['orderMyTel']);

    //检查联系电话
    if(empty($orderMyTel))
    {
        if($is_ajax==1)
            ajax_return(array("status"=>false,"message"=>"您好，我们需要知道您的手机号以方便联系您!"));
        else
            showErr("您好，我们需要知道您的手机号以方便联系您!");
    }
    elseif(!check_mobile($orderMyTel)){
        if($is_ajax==1)
            ajax_return(array("status"=>false,"message"=>"您好，您的手机号格式不正确!"));
        else
            showErr("您好，您的手机号格式不正确!");
    }

    //联系人电话
    $orderMyName = trim($_REQUEST['orderMyName']);
    //如果联系人为空
    if(empty($orderMyName)){
        if($is_ajax==1)
            ajax_return(array("status"=>false,"message"=>"您好，我们需要知道您的姓名!"));
        else
            showErr("您好，我们需要知道您的姓名!");
    }
    //性别
    if(!isset($_REQUEST['orderSex'])){
        if($is_ajax==1)
            ajax_return(array("status"=>false,"message"=>"您还没有选择您的性别!"));
        else
            showErr("您还没有选择您的性别!");
    }

    $orderSex = intval($_REQUEST['orderSex']);

    //如果是给其它人订
    if(!empty($_REQUEST['orderOtherTel']))
    {
        if(!check_mobile($orderMyTel)){
            if($is_ajax==1)
                ajax_return(array("status"=>false,"message"=>"您好，您输入他人的手机号格式不正确!"));
            else
                showErr("您好，您输入他人的手机号格式不正确!");
        }
    }

    //其他人电话
    $orderOtherTel = trim($_REQUEST['orderOtherTel']);
    //其他人姓名
    $orderOtherName = $_REQUEST['orderOtherName'];
    //其它人性别
    $orderOtherSex = intval($_REQUEST['orderOtherSex']);
    //是否吸烟区
    $extraServe = intval($_REQUEST['extraServe']);
    //留言备注
    $orderReqArea = $_REQUEST['orderReqArea'];

    $order_time = $orderDate.$orderHour.$orderMini;

    //填充预订数据
    $order['sid'] = $sid;
    $t_search = array('年','月','日','星期','一','二','三','四','五','六','点','分');
    $t_replace = array('','','','','','','','','','',':','');
    $order['order_time'] = to_timespan(str_replace($t_search,$t_replace,$order_time));;
    $order['order_nums'] = $orderNums;
    $order['seat_status'] = $seatStatus;
    $order['min_expense'] = $minExpense;
    $order['seat_switch'] = $seatSwitch;

    $order['order_tel'] = $orderMyTel;
    $order['order_name'] = $orderMyName;
    $order['order_sex'] = $orderSex;

    $order['order_other_tel'] = $orderOtherTel;
    $order['order_other_name'] = $orderOtherName;
    $order['order_other_sex'] = $orderOtherSex;

    $order['extra_serve'] = $extraServe;
    if($orderReqArea == $GLOBALS['lang']['store_order_tip'])
        $orderReqArea="";
    $order['order_msg'] = $orderReqArea;
    $order['user_id'] = intval($GLOBALS['user_info']['id']);
    $order['create_time'] = get_gmtime();
    $order['deal_type'] = $deal_type;

    //数据
    do
    {
        $order['order_sn'] = to_date(get_gmtime(),"Ymdhis").rand(10,99);
        $GLOBALS['db']->autoExecute(DB_PREFIX."supplier_location_order",$order,'INSERT','','SILENT'); 
        $order_id = intval($GLOBALS['db']->insert_id());
    }while($order_id==0);

    //订单创建成功
    if($order_id > 0){
        if($is_ajax==1)
            ajax_return(array("status"=>true,"message"=>"","order_id"=>$order_id));
        else
            app_redirect(url("shop","order#view",array("order_id"=>$order_id)));
    }else{
        if($is_ajax==1)
            ajax_return(array("status"=>false,"message"=>"处理数据失败，请联系管理员!"));
        else
            showErr("处理数据失败，请联系管理员!");
    }
}