public function actionDeactivate() { Yii::app()->setImport(['application.modules.cargo.models.*']); $condition = new CDbCriteria(); $condition->addCondition('TO_DAYS(NOW()) - TO_DAYS(`deleted_status_date`) > 15'); Product::model()->updateAll(['deleted_status' => Product::DEL_SATUS_ARCHIVE], $condition); Cargo::model()->updateAll(['deleted_status' => Cargo::DEL_SATUS_ARCHIVE], $condition); Reis::model()->updateAll(['deleted_status' => Reis::DEL_SATUS_ARCHIVE], $condition); Sklad::model()->updateAll(['deleted_status' => Sklad::DEL_SATUS_ARCHIVE], $condition); Custom::model()->updateAll(['deleted_status' => Custom::DEL_SATUS_ARCHIVE], $condition); Insurance::model()->updateAll(['deleted_status' => Insurance::DEL_SATUS_ARCHIVE], $condition); SpecialTechnique::model()->updateAll(['deleted_status' => SpecialTechnique::DEL_SATUS_ARCHIVE], $condition); }
public function actionList($company_id = 0) { if ($company_id == 0) { $company_id = Yii::app()->getUser()->getProfile()->company_id; } Yii::import('insurance.models.*'); $criteria = new CDbCriteria(); $criteria->with = ['user' => ['joinType' => 'INNER JOIN', 'condition' => 'user.company_id = :company_id']]; $criteria->addCondition('deleted_status != :deleted_status'); $criteria->params = [':company_id' => $company_id, ':deleted_status' => Insurance::DEL_SATUS_DELETED]; $criteria->order = 'insurance_id DESC'; $this->render('list', ['insurance' => Insurance::model()->findAll($criteria), 'company_id' => $company_id]); }
/** * Returns the data model based on the primary key given in the GET variable. * If the data model is not found, an HTTP exception will be raised. * @param integer the ID of the model to be loaded */ public function loadModel($id) { $model = Insurance::model()->findByPk((int) $id); if ($model === null) { throw new CHttpException(404, 'The requested page does not exist.'); } return $model; }
private function getInsuranceList() { $info = Insurance::model()->findAll(array( 'select'=>'id,name,price', )); return $info; }
public function actionActivate($id) { $model = Insurance::model()->findByPk($id); if (!Yii::app()->user->checkAccess('admin') && (Yii::app()->getUser()->getProfile()->modules->head != UserModules::DIRECTOR_COMPANY || Yii::app()->user->getProfile()->company_id != $model->user->company_id) && (Yii::app()->getUser()->getProfile()->modules->insurance != '1' || $model->user_id != Yii::app()->user->id)) { throw new CHttpException(403); } if ($model === null) { throw new CHttpException(404, 'Указанная запись не найдена'); } $model->deleted_status = Insurance::DEL_SATUS_ACTIVE; $model->deleted_status_date = date('Y-m-d H:i:s'); $model->update(); Yii::app()->user->setFlash('success', Yii::t('CabinetModule.default', 'Предложение успешно активированно.')); $this->redirect('/cabinet/insurance'); }
private function deleteInsurance(\User $user) { $data = 'user_id = :user_id'; $param = array(':user_id' => $user->id); $count = Insurance::model()->count($data, $param); $insurenses = Insurance::model()->findAll($data, $param); foreach ($insurenses as $insurense) { $this->deleteAddress($insurense->address_id); } if ($this->debug) { echo " ... Insurance: del " . $count . " \n"; } else { Insurance::model()->deleteAll($data, $param); } }
public function actionInsurance($id) { $orderModel = $this->loadModel($id); //查询保险内容(id,名称,价格) $arr = Insurance::model()->findAll(array( 'select'=>'id,name,price', 'condition'=>"tid=$orderModel->tid", )); $newArr = array(); $insInfo = array(); foreach($arr as $value){ $newArr[$value->id] = $value->name.'/'.$value->price.'元'; $insInfo[$value->id] = array($value->name,$value->price); } //查询该订单下的保险 $insArr = OrderInsurance::model()->find(array( 'condition'=>"oid=$id", )); if($insArr==null){ $insArr = new OrderInsurance; } if(isset($_POST['OrderInsurance'])){ $insId = intval($_POST['OrderInsurance']['name']); $insArr->oid = $id; $insArr->name = $insInfo[$insId][0]; $insArr->price = $insInfo[$insId][1]; if($insArr->save(false)){ Yii::app()->user->setFlash('success','成功!'); }else{ Yii::app()->user->setFlash('error','失败!'); } } $this->render('insurance',array( 'arr'=>$arr, 'newArr'=>$newArr, 'orderModel'=>$orderModel, 'insArr'=>$insArr, )); }
public function actionService() { $this->pageTitle = Yii::app()->name . ' - 修理厂查询'; $userId = Commonmodel::getOrganID(); if ($_GET) { $search['keyword'] = $_GET['keyWord'] == "机构名称或关键词" ? '' : $_GET['keyWord']; $search['province'] = $_GET['province']; $search['city'] = $_GET['city']; $search['area'] = $_GET['area']; $search['category'] = $_GET['category']; $search['deep'] = $_GET['deep']; $search['vehicle'] = $_GET['vehicle']; $search['maintenance'] = $_GET['maintenance']; $search['maintenance-make'] = $_GET['maintenance-make']; $search['maintenance-car'] = $_GET['maintenance-car']; $search['diagnosis'] = $_GET['diagnosis']; $search['diagnosis-make'] = $_GET['diagnosis-make']; $search['diagnosis-car'] = $_GET['diagnosis-car']; $search['parts'] = $_GET['parts']; $search['repair'] = $_GET['repair']; $search['repair-make'] = $_GET['repair-make']; $search['repair-car'] = $_GET['repair-car']; $search['insurer'] = $_GET['insurer']; } $conditions = " 1 = 1 "; $join = ""; $inner = " INNER JOIN {{service_mainbusiness}} AS main ON main.userId = ser.userId"; if ($search) { if ($search['keyword']) { $join .= " AND (ser.serviceName like '%{$search['keyword']}%' or main.keyWord like '%{$search['keyword']}%')"; } if ($search['province']) { $conditions .= " AND serviceProvince = {$search['province']}"; } if ($search['city']) { $conditions .= " AND serviceCity = {$search['city']}"; } if ($search['area']) { $conditions .= " AND serviceArea = {$search['area']}"; } if ($search['category']) { switch ($search['category']) { case "深度清洁": $join .= " AND main.deepCleaning = '{$search['deep']}'"; break; case "车辆美容": $join .= " AND main.vehiclesBeauty = '{$search['vehicle']}'"; break; case "日常保养": if ($search['maintenance'] == "全车系") { $join .= " AND main.routineMaintenance = '{$search['maintenance']}'"; } else { $join .= " INNER JOIN {{service_mainbusiness_routine}} AS rou ON ser.userId = rou.userId\n\t\t\t\t\t\t\t\t\tAND rou.make = '{$search['maintenance-make']}' AND rou.car = '{$search['maintenance-car']}'"; } break; case "检查诊断": if ($search['diagnosis'] == "全车系") { $join .= " AND main.diagnosis = '{$search['diagnosis']}'"; } else { $join .= " INNER JOIN {{service_mainbusiness_diagnosis}} AS diag ON ser.userId = diag.userId\n\t\t\t\t\t\t\t\t\tAND diag.make = '{$search['diagnosis-make']}' AND diag.car = '{$search['diagnosis-car']}'"; } break; case "易损件更换": $join .= " AND main.wearingParts like '%{$search['parts']}%'"; break; case "专业修理": if ($search['repair'] == "全车系") { $join .= " AND main.professionalRepair = '{$search['repair']}'"; } else { $join .= " INNER JOIN {{service_mainbusiness_repair}} AS rep ON ser.userId = rep.userId\n\t\t\t\t\t\t\t\t\tAND rep.make = '{$search['repair-make']}' AND rep.car = '{$search['repair-car']}'"; } break; case "车险服务": foreach ($search['insurer'] as $key => $value) { $join .= " AND main.insuranceService like '%{$value}%'"; } break; } } } $sql = "SELECT * FROM {{service}} AS ser {$inner} {$join} where {$conditions}"; //获取修理厂数量(在常态下及在查询状态下的判断) $csql = "SELECT * FROM {{service}}"; if ($search) { $count = DBUtil::queryAll($sql); } else { $count = DBUtil::queryAll($csql); } $pagesize = 3; $page = !empty($_GET['page']) ? $_GET['page'] : 1; $page = $pagesize * ($page - 1); $result = DBUtil::queryAll($sql); $count = count($result); $limit = " limit {$page}, {$pagesize} "; $service = DBUtil::queryAll($sql . $limit); $pageData = array('total_rows' => $count, 'parameter' => '', 'list_rows' => $pagesize, 'page_name' => 'page', 'ajax_func_name' => '', 'method' => ''); $page = new Pagination($pageData); $page = $page->show(1); $make = TransportMake::model()->findAll(); $parts = WearingParts::model()->findAll(); $insur = Insurance::model()->findAll(); foreach ($service as $res) { $major = ServiceMainbusiness::model()->findAll(array("condition" => "userId = {$res['userId']}")); foreach ($major as $val) { $type[] = ServiceMainbusiness::model()->find(array("condition" => "userId = {$val['userId']}")); $insurance[] = ServiceMainbusiness::model()->find(array("condition" => "userId = {$val['userId']}")); } } $this->render('service', array('service' => $service, 'search' => $search, 'page' => $page, 'make' => $make, 'parts' => $parts, 'insur' => $insur, 'count' => $count, 'type' => $type, 'insurance' => $insurance)); }
public function actionDelete($id) { $user = User::model()->find(array('condition' => 'id = :id', 'params' => array(':id' => $id))); if (isset($user)) { if (!Yii::app()->user->checkAccess('admin') && (Yii::app()->getUser()->getProfile()->modules->head != UserModules::DIRECTOR_COMPANY || Yii::app()->user->getProfile()->company_id != $user->company_id || Yii::app()->user->id == $id)) { throw new CHttpException(403); } $users = User::getUserList($id); $model = new ModuleAccess(); if (isset($_POST['ModuleAccess'])) { $userId = $_POST['ModuleAccess']['user']; Transport::model()->updateAll(array('user_id' => $userId), 'user_id=' . $id); Product::model()->updateAll(array('user_id' => $userId), 'user_id=' . $id); Cargo::model()->updateAll(array('user_id' => $userId), 'user_id=' . $id); Reis::model()->updateAll(array('user_id' => $userId), 'user_id=' . $id); Sklad::model()->updateAll(array('user_id' => $userId), 'user_id=' . $id); Custom::model()->updateAll(array('user_id' => $userId), 'user_id=' . $id); Insurance::model()->updateAll(array('user_id' => $userId), 'user_id=' . $id); SpecialTechnique::model()->updateAll(array('user_id' => $userId), 'user_id=' . $id); if ($user->delete()) { $this->redirect('/cabinet/staff/list'); } } $this->render('delete', array('model' => $model, 'user' => $user, 'users' => $users)); } }
public function actionIndex() { /* //检查是否进行了第一步(即是否有选择路线) $sessionid = Yii::app()->session['sid'];//Yii::app()->session->sessionID; $tempModel = $this->checkSessionId($sessionid); if(!$tempModel){ $this->render('404',array('msg'=>'您还没选择参团路线,快去选择吧!')); exit; } */ $code = $this->checkKParm(); $orderModel = $this->getOrderByRandCode($code); //如果没有该订单,说明没有通过一步步预定,非法操作 if(!$orderModel){ $this->redirect('/tuan'); exit; } //检查是否有上一步的选择房间 $token = 'order'.$orderModel->id; $roomArr = $this->checkOrderRoomStep($token); //start : 判断是否附加项全部隐藏了,如果全部隐藏则自动跳到下一步 //判断是否隐藏 $struct = Structure::model()->findAll(array('select'=>'enabled','condition'=>'id=6 or id=7 or id=8','order'=>'id asc')); if(empty($struct)){ $this->redirect($this->createUrl('/submit',array('k'=>$code))); exit; } //end $tid = $orderModel->tid;//产品ID //获取参数 $aduit = $orderModel->aduit;//参团成人人数 $child = $orderModel->child;//参团儿童人数 //分配门票附加项 $tickets = TravelAdditional::model()->findAll(array( 'select'=>'id,name,price', 'condition'=>"tid=$tid", )); //如果没有门票项目,则在视图中隐藏门票信息,这里设一个标志符 $flag = empty($tickets)?false:true; //获取价格 $Travelprice = $this->getTravelInfo($tid); $Travelprice->aduit_price = ($orderModel->aduit_price)*$aduit; $Travelprice->childen_price = ($orderModel->chilend_price)*$child; //房间价格 $housePriceTotal = $this->getRoomsPrice($token,$aduit,$child); //计算这部总价格 $nowTotalPrice = ($Travelprice->aduit_price) + ($Travelprice->childen_price) + $housePriceTotal; //获取保险项目 $insurance = Insurance::model()->findAll(array( 'select'=>'id,name,price,description', 'condition'=>"tid=$tid", )); $this->render('index',array( 'tickets'=>$tickets, 'flag'=>$flag, 'aduit'=>$aduit, 'child'=>$child, 'roomArr'=>$roomArr, 'Travelprice'=>$Travelprice, 'insurance'=>$insurance, 'housePriceTotal'=>$housePriceTotal, 'nowTotalPrice'=>$nowTotalPrice, 'token'=>$token, 'code'=>$code, 'struct'=>$struct, 'daynumber'=>$orderModel->daynumber, )); }