public function checktime() { $car_db = M('Car'); $order_db = M('Order'); $cid = $_POST['cid']; $bgtime = $_POST['bgtime']; $endtime = $_POST['endtime']; $num = diffBetweenTwoDays($bgtime, $endtime); $kznum = getDayWeek($bgtime, $num); $sharearr = explode(',', $kznum); $where = "cid = {$cid}"; $where .= " and ("; foreach ($sharearr as $k => $v) { if ($v) { $where .= "sharetime like '%" . $v . "%'"; if ($sharearr[$k + 1]) { $where .= " or "; } } } $where .= " or ( sharetime like '%1%' and sharetime like '%3%' )"; $where .= ")"; $cinfo = $car_db->where($where)->find(); if ($cinfo) { $omap['cid'] = $cid; $omap['bgtime'] = array('elt', $endtime); $omap['endtime'] = array('egt', $bgtime); $omap['status'] = array('not in', '2,6,7'); //$omap['status'] = array('not in',''); $olist = $order_db->field('oid')->where($omap)->select(); if ($olist) { echo '0'; } else { echo '1'; } } else { echo '0'; } }
public function hjcinfoRecommend($id, $page = 1, $rows = 10, $search = array(), $sort = 'cid', $order = 'desc') { if (IS_POST) { $car_db = M('Car'); $city_db = M('City'); $hjcinfo_db = M('Hjcinfo'); $info = $hjcinfo_db->where('id=' . $id)->find(); // $where = array("1 = 1"); if (empty($search)) { $where[] = "`ctype` = '{$info[ctype]}'"; $where[] = "`cbrand` = '{$info[cbrand]}'"; $where[] = "`cmodel` = '{$info[cmodel]}'"; $where[] = "`canby` = '{$info[canby]}'"; $where[] = "`bsbox` = '{$info[bsbox]}'"; $where[] = "`output` = '{$info[output]}'"; $where[] = "`is_swap` = '{$info[is_swap]}'"; $where[] = "`userid` != '{$info[userid]}'"; } else { $num = diffBetweenTwoDays($search['bgtime'], $search['endtime']); //单位:天数 $kznum = getDayWeek($search['bgtime'], $num); $sharearr = explode(',', $kznum); $sql = "("; foreach ($sharearr as $k => $v) { if ($v) { $sql .= "sharetime like '%" . $v . "%'"; if ($sharearr[$k + 1]) { $sql .= " or "; } } } $sql .= " or ( sharetime like '%1%' and sharetime like '%3%' )"; $sql .= ")"; $where[] = $sql; } foreach ($search as $k => $v) { if (!$v) { continue; } switch ($k) { case 'output': if ($v != 0) { $where[] = "`{$k}` = '{$v}'"; } break; case 'city': //$ctmap['code'] = $v; //$ctinfo = $city_db->where($ctmap)->find(); $where[] = "C.{$k} = '{$v}'"; break; case 'ctype': $where[] = "`{$k}` = '{$v}'"; break; case 'cbrand': if ($v != 0) { $where[] = "`{$k}` = '{$v}'"; } break; case 'cmodel': if ($v != 0) { $where[] = "`{$k}` = '{$v}'"; } break; case 'bsbox': if ($v != 0) { $where[] = "`{$k}` = '{$v}'"; } break; case 'canby': if ($v != 0) { $where[] = "`{$k}` = '{$v}'"; } break; } } $where = implode(' and ', $where); $total = $car_db->where($where)->count(); $order = $sort . ' ' . $order; $limit = ($page - 1) * $rows . "," . $rows; $list = $car_db->table(C('DB_PREFIX') . 'Car C')->join(C('DB_PREFIX') . 'cartype CT on CT.tpid = C.ctype')->join(C('DB_PREFIX') . 'users U on U.userid = C.userid')->join(C('DB_PREFIX') . 'carbrand CB on CB.brandid = C.cbrand')->join(C('DB_PREFIX') . 'carmodel CM on CM.modelid = C.cmodel')->join(C('DB_PREFIX') . 'city Ci on C.city = Ci.code')->field("U.userid,U.name,U.ctel,C.cid,CT.tpname,C.cppro,C.cpzm, Ci.name as cityname,C.cpnum,C.output,C.bsbox,C.colour,C.canby,CB.brandname, CM.name as modelname, C.is_rz,C.is_recommend,C.cid as operateid")->where($where)->order($order)->limit($limit)->select(); //$a = $car_db->getlastsql(); $data = array('total' => $total, 'rows' => $list); $this->ajaxReturn($kznum); } else { $hjcinfo_db = M('Hjcinfo'); $car_db = M('Car'); $info = $hjcinfo_db->table(C('DB_PREFIX') . 'hjcinfo H')->join(C('DB_PREFIX') . 'cartype CT on CT.tpid = H.ctype')->join(C('DB_PREFIX') . 'city C on C.code = H.citycode')->join(C('DB_PREFIX') . 'users U on U.userid = H.userid')->field("H.*,U.name as uname, C.name as cityname, CT.tpname, FROM_UNIXTIME(H.ctime, '%Y-%m-%d %H:%i') as ctime")->where('H.id = ' . $id)->find(); $prov_db = M('Province'); $city_db = M('City'); $brand_db = M('Carbrand'); $model_db = M('Carmodel'); $colour_db = M('Carcolour'); $type_db = M('Cartype'); $regyear_db = M('Carregyear'); $map['code'] = array('neq', '0'); $plist = $prov_db->where($map)->select(); $ctlist = $city_db->where($map)->select(); $tylist = $type_db->select(); $blist = $brand_db->select(); $mlist = $model_db->select(); $rylist = $regyear_db->select(); //$menu_db = D('Menu'); $currentpos = '推荐座驾'; //栏目位置 $datagrid = array('options' => array('title' => $currentpos, 'url' => U('Hjcinfo/hjcinfoRecommend', array('grid' => 'datagrid', 'id' => $id)), 'toolbar' => 'Hjcinfo_hjcinforecommend_datagrid_toolbar', 'singleSelect' => false), 'fields' => array('选中' => array('field' => 'ck', 'width' => 5, 'checkbox' => true), '车主姓名' => array('field' => 'name', 'width' => 10), '车牌号码' => array('field' => 'cpnum', 'width' => 10, 'formatter' => 'hjcinfoHjcinfoRecommendCpnumFormatter'), '车辆类型' => array('field' => 'tpname', 'width' => 10), '品牌型号' => array('field' => 'modelname', 'width' => 10, 'formatter' => 'hjcinfoHjcinfoRecommendBrandFormatter'), '车辆排量' => array('field' => 'output', 'width' => 10, 'formatter' => 'hjcinfoHjcinfoRecommendoutputFormatter'), '变速箱' => array('field' => 'bsbox', 'width' => 10, 'formatter' => 'hjcinfoHjcinfoRecommendbsboxFormatter'), '可载人数' => array('field' => 'canby', 'width' => 10, 'formatter' => 'hjcinfoHjcinfoRecommendCanbyFormatter'), '颜色' => array('field' => 'colour', 'width' => 10), '所在城市' => array('field' => 'cityname', 'width' => 10), '管理操作' => array('field' => 'operateid', 'width' => 10, 'formatter' => 'hjcinfoHjcinfoRecommendOperateFormatter'))); $this->assign('plist', $plist); $this->assign('ctlist', $ctlist); $this->assign('tylist', $tylist); $this->assign('blist', $blist); $this->assign('mlist', $mlist); $this->assign('rylist', $rylist); $this->assign('info', $info); $this->assign('datagrid', $datagrid); /*echo "<pre>"; var_dump($info);die();*/ $this->display('hjc_rmlist'); } }