public function checkLicensePlate() { $OrganID = Yii::app()->user->getOrganID(); $ID = $_POST['ServiceCar']['ID'] ? $_POST['ServiceCar']['ID'] : 0; $model = ServiceCar::model()->findAll('LicensePlate = :LicensePlate AND OrganID = :OrganID AND ID <> :id AND Status = 0', array(':LicensePlate' => $_POST['ServiceCar']['LicensePlate'], ':OrganID' => $OrganID, ':id' => $ID)); if ($model && count($model) > 0) { $this->addError('LicensePlate', '该车牌号已存在,请勿重复添加!'); } }
public function actionDetail() { $OrganID = Yii::app()->user->getOrganID(); $ServiceID = Yii::app()->request->getParam("id"); //$_GET['ID']; //获取服务记录详情 $record = ServiceRecord::model()->findByPK($ServiceID); //获取配件服务记录详情 $criteria = new CDbCriteria(); $criteria->order = "t.UpdateTime DESC,t.ID DESC"; //排序条件:t.CreateTime,t.ID倒叙 $criteria->addCondition("ServiceID = {$ServiceID}", "AND"); $criteria->addCondition("t.Status = 0", "AND"); $dataProvider = new CActiveDataProvider('ServiceParts', array('criteria' => $criteria, 'pagination' => array('pageSize' => '10'))); $data = $dataProvider->getData(); $key = 0; foreach ($data as $val) { $part = explode(",", $val['PartName']); if (empty(array_filter($part))) { array_splice($data, $key, 1); continue; } $key++; $val['PartName'] = ''; foreach ($part as $v) { $name = Gcategory::model()->find(array('select' => 'Name', 'condition' => 'ID= :ID', 'params' => array(':ID' => $v))); $val['PartName'] .= $name['Name'] . ","; } $val['PartName'] = substr($val['PartName'], 0, strlen($val['PartName']) - 1); if ($val['OperateType'] == 2) { $val['OperateType'] = "维修"; } else { $val['OperateType'] = "更换"; } } //var_dump($data);die; $dataProvider->setData($data); //获取车辆详情 //根据服务记录ID获取车辆ID $carID = ServiceRecord::model()->find(array('select' => 'CarID', 'condition' => 'ID= :ID', 'params' => array(':ID' => $ServiceID))); $car = ServiceCar::model()->findByPK($carID['CarID']); if ($car['UseNature'] == 2) { $car['UseNature'] = "公务车"; } elseif ($car['UseNature'] == 3) { $car['UseNature'] = "运营车"; } else { $car['UseNature'] = "私家车"; } $car['Car'] = str_replace(",", " ", $car['Car']); //获取车主详情 $owner = ServiceCarOwner::model()->findByPK($car['OwnerID']); $this->render('detail', array('dataProvider' => $dataProvider, 'car' => $car, 'owner' => $owner, 'record' => $record)); }
public function AddCar($OwnerID, $CarID, $arr) { if ($CarID) { $model = ServiceCar::model()->findByPk($CarID); } else { $model = new ServiceCar(); $model->Car = $arr['Car']; $model->LicensePlate = $arr['LicensePlate']; $model->BuyTime = $arr['BuyTime']; $model->Mileage = $arr['Mileage']; $model->OrganID = Yii::app()->user->getOrganID(); $model->CreateTime = time(); } $model->OwnerID = $OwnerID; if ($model->save()) { return 1; } else { throw new CHttpException(400, '添加车辆信息失败!'); } }
public function actionDetail() { $id = Yii::app()->request->getParam("id"); //车辆详情 $car = ServiceCar::model()->findByPK($id); if ($car['UseNature'] == 1) { $car['UseNature'] = "私家车"; } elseif ($car['UseNature'] == 2) { $car['UseNature'] = "公务车"; } elseif ($car['UseNature'] == 3) { $car['UseNature'] = "运营车"; } else { $car['UseNature'] = ""; } if ($car['Relation'] == 1) { $car['Relation'] = "长期"; } elseif ($car['Relation'] == 2) { $car['Relation'] = "暂时"; } else { $car['Relation'] = ""; } $car['PartsLevel'] = Yii::app()->params['PartsLevel'][$car['PartsLevel']]; $car['Car'] = str_replace(",", "", $car['Car']); //车主详情 $owner = ServiceCarOwner::model()->findByPK($car->OwnerID); //判断是否为空 (可能未选车主) if (!empty($owner)) { if ($owner['Sex'] == 2) { $owner['Sex'] = '女'; } else { $owner['Sex'] = '男'; } if ($owner['DrivingEnvironment'] == 2) { $owner['DrivingEnvironment'] = '高速'; } elseif ($owner['DrivingEnvironment'] == 3) { $owner['DrivingEnvironment'] = '郊区'; } else { $owner['DrivingEnvironment'] = '市区'; } } $this->render('detail', array('owner' => $owner, 'car' => $car)); }
public function actionCheckservicedata() { $OrganID = Yii::app()->user->getOrganID(); $LicensePlate = Yii::app()->request->getParam("LicensePlate"); $model = ServiceCar::model()->findAll('LicensePlate = :LicensePlate AND OrganID = :OrganID AND Status = 0', array(':LicensePlate' => $LicensePlate, ':OrganID' => $OrganID)); if ($model) { echo 1; } else { echo 0; } }
public function getCarID($licenseplate) { $criteria = new CDbCriteria(); $criteria->addCondition("t.LicensePlate = '{$licenseplate}'", "AND"); $criteria->addCondition("t.Status = 0", "AND"); $model = ServiceCar::model()->findAll($criteria); $data = array(); foreach ($model as $key => $value) { if (!in_array($value['ID'], $data)) { $data[] = $value['ID']; } } return $data; }