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');
}
}
