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