public function run()
{
$id = Yii::app()->request->getParam('id');
$name = Yii::app()->request->getParam('name');
$email = Yii::app()->request->getParam('email');
$phone = Yii::app()->request->getParam('phone');
$website = Yii::app()->request->getParam('website');
$logo = Yii::app()->request->getParam('logo');
$background = Yii::app()->request->getParam('background');
$location = Yii::app()->request->getParam('location');
$hub = Yii::app()->request->getParam('hub');
$service = Yii::app()->request->getParam('service');
$facebook = Yii::app()->request->getParam('facebook');
$linkedin = Yii::app()->request->getParam('linkedin');
$introduction = Yii::app()->request->getParam('content');
$data = array('name' => $name, 'email' => $email, 'phone' => $phone, 'website' => $website, 'logo' => $logo, 'background' => $background, 'location' => $location, 'hubId' => $hub, 'serviceid' => $service, 'facebookid' => $facebook, 'linkedinid' => $linkedin, 'introduction' => $introduction);
$proxy = new BCompany();
$dp = new BHub();
$dc = Service::model()->findAll('status!=0');
if (Yii::app()->request->isAjaxRequest) {
$result = $proxy->updateCompany($data, $id);
echo CJSON::encode($result);
} else {
$result = $proxy->getCompanyInfo($id);
$hub = $dp->getHubList($start, 10);
if ($result['code'] == 200) {
$this->controller->render('edit', array('data' => $result['data'], 'hub' => $hub['data'], 'service' => $dc));
} else {
throw new CHttpException($result['code'], $result['message']);
}
}
}
public static function getOrganName()
{
$organName = Yii::app()->user->getState('organName');
if ($organName) {
return $organName;
}
//先获取角色身份（生产商/经销商/修理厂）
$organName = "";
// $userid = Yii::app()->user->id;
$userid = Commonmodel::getOrganID();
$model = self::getIdentity($userid);
if ($model['identity'] == 1) {
$organ = MakeOrgan::model()->find('userID=:userid', array(':userid' => $userid));
$organName = $organ['name'];
} else {
if ($model['identity'] == 2) {
$organ = Dealer::model()->find('userID=:userid', array(':userid' => $userid));
$organName = $organ['organName'];
} else {
if ($model['identity'] == 3) {
$organ = Service::model()->find('userId=:userid', array(':userid' => $userid));
$organName = $organ['serviceName'];
}
}
}
Yii::app()->user->setState('organName', $organName);
return $organName;
}
public function loadModel($id)
{
if (($model = Service::model()->findByPk($id)) === null) {
throw new CHttpException(404, 'Страница не найдена');
}
return $model;
}
public function run()
{
$start = Yii::app()->request->getParam('start');
$dp = new BHub();
$dc = Service::model()->findAll('status!=0');
$hub = $dp->getHubList($start, 10);
$this->controller->render('edit', array('hub' => $hub['data'], 'service' => $dc));
}
/**
* Updates a particular model.
* If update is successful, the browser will be redirected to the 'view' page.
* @param integer $id the ID of the model to be updated
*/
public function actionUpdate($id)
{
$model = $this->loadModel($id);
$this->_operate($model, 'update');
$listGames = Games::model()->findAll();
$listService = Service::model()->findAll();
$this->render('update', array('model' => $model, 'listGames' => $listGames, 'listService' => $listService));
}
public function actionShow($alias)
{
$model = Service::model()->published()->with(array('slides' => array('scopes' => 'published', 'order' => 'slides.sort ASC')))->findByAlias($alias);
if (!$model) {
throw new CHttpException(404);
}
$this->render('show', array('model' => $model));
}
public function run()
{
$models = Service::model()->published()->findAll(array('order' => 't.sort ASC'));
if (empty($models)) {
return;
}
$this->render($this->view, array('models' => $models));
}
public static function getAvailableServices()
{
$services = Service::model()->findAll("type <> '{ServiceHelper::TYPE_SMALL_BUSINESS}'");
$result = array(null => 'Отсутствует');
foreach ($services as $service) {
$result[$service->id] = $service->title;
}
return $result;
}
public function actionSave()
{
$services = Service::model()->findAllByAttributes(['status' => 0]);
foreach ($services as $service) {
$traffic = new Traffic();
$traffic->attributes = ['uid' => $service->uid, 'email' => $service->email, 'date' => date('Y-m-d', strtotime('yesterday')), 'traffic' => $service->used];
$traffic->save();
}
echo "Success";
}
public function traffic()
{
$traffic = Service::model()->sum('traffic');
$serv1 = Service::model()->findByPk(1);
$serv2 = Service::model()->findByPk(2);
$traffic -= $serv1->traffic + $serv2->traffic;
$used = Service::model()->sum('left');
$left = $traffic - $used;
$this->response(200, 'success', [['name' => '收益', 'value' => ['总额' => round($traffic / 100 / 1024 * 0.8, 2), '销售' => round($used / 100 / 1024 * 0.8, 2), '库存' => round($left / 100 / 1024 * 0.8, 2)]], ['name' => '已使用', 'value' => $used / 100], ['name' => '未使用', 'value' => $left / 100]]);
}
public function run($id)
{
$community = new CCommunity();
$result = $community->getCompanyListByService($id);
$title = Service::model()->findByAttributes(array('id' => $id))->name;
$this->controller->pageTitle = $title;
if ($result['code'] == 200) {
$this->controller->bodyCss = 'whitecolor';
$this->controller->render('servicescompany', array('list' => $result['data']));
}
}
public function actionDetail($alias)
{
$model = $this->loadModelByPKID($alias);
$this->pageTitle = 'List of Service with type: ' . $model->s_name;
$models = Service::model()->findAll('s_service_type_id = :s_service_type_id and s_store_id = :s_store_id', array(':s_service_type_id' => $model->pk_s_id, ':s_store_id' => $model->s_store_id));
if (Yii::app()->request->isAjaxRequest) {
$this->renderPartial($this->view . 'detail', array('model' => $model, 'models' => $models));
} else {
$this->render($this->view . 'detail', array('model' => $model, 'models' => $models));
}
}
public static function getAvailableServices()
{
$criteria = new CDbCriteria();
$criteria->addCondition("type <> '{ServiceHelper::TYPE_SMALL_BUSINESS}'");
$criteria->order = 'title ASC';
$services = Service::model()->findAll($criteria);
$res = array(null => 'Отсутствует');
foreach ($services as $service) {
$res[$service->id] = $service->title;
}
return $res;
}
public function actionIndex($alias = '')
{
// Загружаем страницу "Услуги"
Yii::import("application.modules.page.models.Page");
$page = Page::model()->with(array('slides' => array('scopes' => 'published')))->findByPath("services");
// Список услуг
$criteria = new CDbCriteria();
$criteria->order = 't.sort ASC';
$models = Service::model()->published()->findAll($criteria);
// Вывод в шаблон
$this->render('index', array('models' => $models, 'page' => $page));
}
public function run()
{
$query = $this->request->getQuery('Service', []);
$model = Service::model();
$model->attributes = $query;
$condition = $this->createSearchCriteria($query);
$pager = new CPagination($model->count($condition));
$pager->setPageSize(20);
$condition['offset'] = $pager->getOffset();
$condition['limit'] = $pager->getLimit();
$condition['order'] = 'status asc, uid asc';
$data = $model->findAll($condition);
$this->render('pac', ['data' => new RedArrayDataProvider($data), 'pager' => $pager, 'model' => $model]);
}
public function getSurveySteps()
{
if (!empty($this->surveySteps)) {
$steps = Service::model()->findAllByPk($this->surveySteps);
} else {
$condition = array();
if (!empty($this->selectedSurveySteps)) {
$condition[] = 'id IN (' . implode(',', $this->selectedSurveySteps) . ')';
}
$steps = Service::model()->findAll(implode(" OR ", $condition));
}
$steps = $this->setCounts($steps);
return $steps;
}
public function actionDelete($id)
{
$service = Service::model()->findAll('contractor_id=' . $id);
if ($service) {
foreach ($service as $serv) {
WrapServTransport::Del($serv->id);
ServCulture::model()->deleteAllByAttributes(array('service_id' => $serv->id));
$food = ServFood::model()->findAll('service_id=' . $serv->id);
if ($food) {
foreach ($food as $mFood) {
LinkFoodServ::model()->deleteAllByAttributes(array('serv_food_id' => $mFood->id));
}
}
ServFood::model()->deleteAllByAttributes(array('service_id' => $serv->id));
ServIntensiv::model()->deleteAllByAttributes(array('service_id' => $serv->id));
ServOther::model()->deleteAllByAttributes(array('service_id' => $serv->id));
$personal = ServPersonal::model()->findAll('service_id=' . $serv->id);
if ($personal) {
foreach ($personal as $mPers) {
LinkPersonalLanguage::model()->deleteAllByAttributes(array('serv_personal_id' => $mPers->id));
}
}
ServPersonal::model()->deleteAllByAttributes(array('service_id' => $serv->id));
ServPlatform::model()->deleteAllByAttributes(array('service_id' => $serv->id));
ServProgram::model()->deleteAllByAttributes(array('service_id' => $serv->id));
ServTicket::model()->deleteAllByAttributes(array('service_id' => $serv->id));
$live = ServLive::model()->findAll('service_id=' . $serv->id);
if ($live) {
foreach ($live as $mLive) {
ServLiveRoom::model()->deleteAllByAttributes(array('serv_live_id' => $mLive->id));
}
}
ServLive::model()->deleteAllByAttributes(array('service_id' => $serv->id));
Photo::model()->deleteAllByAttributes(array('service_id' => $serv->id));
}
}
Service::model()->deleteAllByAttributes(array('contractor_id' => $id));
Comment::model()->deleteAllByAttributes(array('contractor_id' => $id));
LinkCityContractor::model()->deleteAllByAttributes(array('contractor_id' => $id));
Contractor::model()->deleteByPk($id);
echo "ok";
}
protected function beforeAction($action)
{
//echo Yii::app()->request->csrfToken;
Yii::app()->clientScript->registerScript('ajax-csrf', '
$.ajaxPrefilter(function(options, originalOptions, jqXHR){
if(originalOptions.type){
var type = originalOptions.type.toLowerCase();
} else {
var type = "";
}
if(type == "post" && typeof originalOptions.data === "object"){
options.data = $.extend(originalOptions.data, { "' . Yii::app()->request->csrfTokenName . '": "' . Yii::app()->request->csrfToken . '" });
options.data = $.param(options.data);
}
});
', CClientScript::POS_END, array());
if (!Yii::app()->user->checkAccess('backend_access')) {
$currentController = Yii::app()->controller->id;
$currentAction = Yii::app()->controller->action->id;
if (!($currentController == 'site' && ($currentAction == 'login' || $currentAction == 'logout'))) {
if (issetModule('service')) {
$serviceInfo = Service::model()->findByPk(Service::SERVICE_ID);
if ($serviceInfo && $serviceInfo->is_offline == 1) {
$allowIps = explode(',', $serviceInfo->allow_ip);
$allowIps = array_map("trim", $allowIps);
if (!in_array(Yii::app()->request->userHostAddress, $allowIps)) {
$this->renderPartial('//modules/service/views/index', array('page' => $serviceInfo->page), false, true);
Yii::app()->end();
}
}
}
}
}
/* start get page banners */
if (issetModule('advertising') && !param('useBootstrap')) {
$advert = new Advert();
$advert->getAdvertContent();
}
/* end get page banners */
return parent::beforeAction($action);
}
public function run($id = null, $page = 1, $size = 2)
{
$this->controller->pageTitle = "Company";
if (Yii::app()->request->isAjaxRequest) {
if (!$id) {
$id = User::model()->findByAttributes(array('id' => Yii::app()->user->id))->company;
}
$post = new CPost();
$result = $post->getCompanyList($id, $page, $size);
echo CJSON::encode(array('code' => 200, 'mes' => 'success', 'data' => array('list' => $result['data'])));
} else {
if ($id) {
$company = Company::model()->findByAttributes(array('id' => $id));
$service = Service_company::model()->findAllByAttributes(array('companyId' => $id, 'status' => 1));
if ($service) {
foreach ($service as $list) {
$servicelist[] = Service::model()->findByAttributes(array('id' => $list['serviceId']));
}
}
$hub = Hub::model()->findByAttributes(array('id' => $company['location']));
$post = new CPost();
$postlist = $post->getCompanyList($id, $page, $size);
//取出公司所有成员
$member = User::model()->findAllByAttributes(array('company' => $id));
} else {
$user = User::model()->findByAttributes(array('id' => Yii::app()->user->id));
$company = Company::model()->findByAttributes(array('id' => $user['company']));
$service = Service_company::model()->findAllByAttributes(array('companyId' => $company['id'], 'status' => 1));
if ($service) {
foreach ($service as $list) {
$servicelist[] = Service::model()->findByAttributes(array('id' => $list['serviceId']));
}
}
$hub = Hub::model()->findByAttributes(array('id' => $company['location']));
$post = new CPost();
$postlist = $post->getCompanyList($company->id, $page, $size);
$member = User::model()->findAllByAttributes(array('company' => $user['company']));
}
// print_r($company);die;
$this->controller->render('profile', array('company' => $company, 'service' => $servicelist, 'location' => $hub['location'], 'postlist' => $postlist['data'], 'member' => $member));
}
}
public function run()
{
$uid = $this->request->getQuery('id', 0);
$service = Service::model()->findByPk($uid);
if (!empty($service)) {
if (in_array($service->status, [1, 2])) {
// 不可用状态
$task = Queue::createTask($this->app->createUrl('api/open'), $uid);
} else {
$task = Queue::createTask($this->app->createUrl('api/close'), $uid);
}
if (Queue::enqueue($task)) {
$this->response(200, ':) success');
} else {
$this->response(200, ':( failure');
}
} else {
$this->response(404, 'Not Found');
}
}
public function run()
{
$uid = $this->request->getQuery('uid', false);
if ($uid) {
$this->render('purchase', ['uid' => $uid]);
} else {
$uid = $this->request->getPost('uid', 0);
$traffic = $this->request->getPost('traffic', 0);
$service = Service::model()->findByPk($uid);
if (!empty($service) && is_numeric($traffic)) {
$service->traffic += $traffic * 100;
if ($service->save()) {
$this->response(200, ':) Success');
} else {
$this->response(500, ':( failed');
}
} else {
$this->response(404, 'Not Found!');
}
}
}
public static function getRecommendByPhone($recommend)
{
$model = Dealer::model()->find("Phone=:phone", array(":phone" => $recommend))->attributes['userID'];
if (empty($model)) {
unset($model);
$model = Service::model()->find("serviceCellPhone=:cellphone", array(":cellphone" => $recommend))->attributes['userId'];
}
return $model;
}
echo $form->errorSummary($rule);
?>
<?php
echo $form->dropDownList($rule, 'parent_rule_id', CHtml::listData(OphTrOperationbooking_Waiting_List_Contact_Rule::model()->getListAsTree(), 'id', 'treeName'), array('empty' => '- None -'));
?>
<?php
echo $form->textField($rule, 'rule_order', array(), array(), array('field' => 2));
?>
<?php
echo $form->dropDownList($rule, 'site_id', Site::model()->getListForCurrentInstitution('name'), array('empty' => '- Not set -'));
?>
<?php
echo $form->dropDownList($rule, 'firm_id', Firm::model()->getListWithSpecialties(), array('empty' => '- Not set -'));
?>
<?php
echo $form->dropDownList($rule, 'service_id', CHtml::listData(Service::model()->findAll(array('order' => 'name')), 'id', 'name'), array('empty' => '- Not set -'));
?>
<?php
echo $form->textField($rule, 'name');
?>
<?php
echo $form->textField($rule, 'telephone', array(), array(), array('field' => 3));
?>
<?php
if ($rule->children) {
?>
<div class="row field-row">
<div class="large-<?php
echo $form->layoutColumns['label'];
?>
column">
public function actionOrgan()
{
$user_id = Commonmodel::getOrganID();
// $ids = $user_id;
$businessContacts = BusinessContacts::model()->findAll('user_id=:user_id and Status=0', array(':user_id' => $user_id));
foreach ($businessContacts as $key => $val) {
if ($val['contact_user_id']) {
$ids[] = $val['contact_user_id'];
}
}
$ids[] = $user_id;
//新增的联系人不能是添加者本人
$ids = implode(',', $ids);
//经销商数据
$i = 0;
$model = Dealer::model()->findAll("userID not in ({$ids}) and !ISNULL(organName)");
foreach ($model as $key => $value) {
$data[$i]['companyname'] = $value['organName'];
$data[$i]['userID'] = $value['userID'];
// $data[$key]['companytype']=$value['userID'];
$result = User::model()->findByPk($value['userID']);
switch ($result['identity']) {
case 1:
$data[$i]['companytype'] = '生产商';
break;
case 2:
$data[$i]['companytype'] = '经销商';
break;
case 3:
$data[$i]['companytype'] = '修理厂';
}
$i++;
}
//修理厂
$model = Service::model()->findAll("userId not in ({$ids}) and !ISNULL(serviceName)");
foreach ($model as $key => $value) {
$data[$i]['companyname'] = $value['serviceName'];
$data[$i]['userID'] = $value['userId'];
//$data[$value['userId']]['companytype']=$value['userId'];
$result = User::model()->findByPk($value['userId']);
switch ($result['identity']) {
case 1:
$data[$i]['companytype'] = '生产商';
break;
case 2:
$data[$i]['companytype'] = '经销商';
break;
case 3:
$data[$i]['companytype'] = '修理厂';
}
$i++;
}
//生产商
// $model=Yii::app()->db->createCommand()
// ->select('*')
// ->from('tbl_make_organ')
// ->queryAll();
$model = MakeOrgan::model()->findAll("userID not in ({$ids})");
foreach ($model as $key => $value) {
$data[$i]['companyname'] = $value['name'];
$data[$i]['userID'] = $value['userID'];
//$data[$key]['companytype']=$value['userID'];
$result = User::model()->findByPk($value['userID']);
switch ($result['identity']) {
case 1:
$data[$i]['companytype'] = '生产商';
break;
case 2:
$data[$i]['companytype'] = '经销商';
break;
case 3:
$data[$i]['companytype'] = '修理厂';
}
$i++;
}
$rs = array('total' => 1000, 'rows' => $data);
echo json_encode($rs);
}
public function actionTranslate()
{
$rooms = TypeRoom::model()->findAllByAttributes(array('status' => 'ACTIVE'));
$sqlsm = "";
$sqlm = "";
$i = 0;
foreach ($rooms as $r) {
$sqlsm .= "insert into `sourcemessage` values (" . $i . ",'rooms','room_" . htmlentities($r->name, ENT_QUOTES, 'UTF-8') . "_name');<br>";
$sqlm .= "insert into `message` values (" . $i . ",'es','" . htmlentities($r->name, ENT_QUOTES, 'UTF-8') . "');<br>";
$sqlm .= "insert into `message` values (" . $i++ . ",'en','');<br>";
$sqlsm .= "insert into `sourcemessage` values (" . $i . ",'rooms','room_" . htmlentities($r->name, ENT_QUOTES, 'UTF-8') . "_description');<br>";
$sqlm .= "insert into `message` values (" . $i . ",'es','" . htmlentities($r->description, ENT_QUOTES, 'UTF-8') . "');<br>";
$sqlm .= "insert into `message` values (" . $i++ . ",'en','');<br>";
}
echo $sqlsm;
echo $sqlm;
echo "<br>";
$services = Service::model()->findAll();
$sqlsm = "";
$sqlm = "";
foreach ($services as $s) {
$sqlsm .= "insert into `sourcemessage` values (" . $i . ",'services','service_" . htmlentities($s->title, ENT_QUOTES, 'UTF-8') . "_title');<br>";
$sqlm .= "insert into `message` values (" . $i . ",'es','" . htmlentities($s->title, ENT_QUOTES, 'UTF-8') . "');<br>";
$sqlm .= "insert into `message` values (" . $i++ . ",'en','');<br>";
if (!is_null($s->description)) {
$sqlsm .= "insert into `sourcemessage` values (" . $i . ",'services','service_" . htmlentities($s->title, ENT_QUOTES, 'UTF-8') . "_description');<br>";
$sqlm .= "insert into `message` values (" . $i . ",'es','" . htmlentities($s->description, ENT_QUOTES, 'UTF-8') . "');<br>";
$sqlm .= "insert into `message` values (" . $i++ . ",'en','');<br>";
}
}
echo $sqlsm;
echo $sqlm;
}
/**
* 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 $id the ID of the model to be loaded
* @return Service the loaded model
* @throws CHttpException
*/
public function loadModel($id)
{
$model = Service::model()->findByPk($id);
if ($model === null) {
throw new CHttpException(404, 'The requested page does not exist.');
}
return $model;
}
<div class="action">
<?php
echo CHtml::link('<i></i>Add Service', array('add'));
?>
</div>
<?php
$pageSize = Yii::app()->user->getState('pageSize', Yii::app()->params['defaultPageSize']);
$this->widget('zii.widgets.grid.CGridView', array('id' => 'data-grid', 'dataProvider' => $model->search(array('store_id' => Yii::app()->user->storeID, 'is_shopping' => 1)), 'htmlOptions' => array('class' => 'table tbuser'), 'summaryText' => '', 'filter' => $model, 'columns' => array(array('name' => 'No', 'filter' => false, 'value' => '$row + 1', 'type' => 'raw', 'htmlOptions' => array('class' => 'ct id')), array('name' => 's_image_server', 'value' => '($data->s_image_server != "")?CHtml::image(Yii::app()->baseUrl."/data/service/120x120_".$data->s_image_server,"",array("style"=>"width:35px")):"<div style=\\"width:35px; height:35px; background:#".sprintf("%06x",rand(0,987654))."; margin:0 auto \\"></div>"', 'filter' => false, 'type' => 'raw', 'htmlOptions' => array('class' => 'ct', 'style' => 'padding:0')), array('name' => 's_name', 'value' => 'Chtml::link($data->s_name,array("service/detail","id" => $data->id),array("class"=>"link detailService"))', 'type' => 'raw', 'htmlOptions' => array('class' => 'ct')), array('name' => 's_service_type_id', 'value' => '$data->getType() != null?Chtml::link($data->getType()->s_name,array("serviceType/detail","id" => $data->getType()->id),array("class"=>"link detailService")):$data->s_service_type_id', 'filter' => Service::model()->filterTypeService(), 'type' => 'raw', 'htmlOptions' => array('class' => 'ct')), array('name' => 's_price', 'type' => 'raw', 'filter' => false, 'htmlOptions' => array('class' => 'ct')), array('name' => 's_unit', 'type' => 'raw', 'filter' => false, 'htmlOptions' => array('class' => 'ct')), array('name' => 'i_disable', 'type' => 'raw', 'value' => 'Yii::app()->params["flag.disable"][$data->i_disable]', 'filter' => false, 'htmlOptions' => array('class' => 'ct', 'style' => 'width:110px; padding:1px 2px;')), array('name' => 'i_updated', 'type' => 'raw', 'value' => '($data->i_updated > 0)?date("Y-m-d H:i:s",$data->i_updated):"N/A"', 'filter' => false, 'htmlOptions' => array('class' => 'ct')), array('class' => 'CButtonColumn', 'template' => '{edit}{delete}', 'buttons' => array('edit' => array('label' => '<i></i> EDIT', 'imageUrl' => false, 'url' => 'array("service/edit","id" => $data->id)', 'options' => array('title' => 'Edit', 'class' => 'btnAction1')), 'delete' => array('label' => '<i></i> DEL', 'imageUrl' => false, 'options' => array('title' => 'Delete', 'class' => 'btnAction2'))), 'htmlOptions' => array('style' => 'width:123px; padding:1px;'))), 'pager' => array('cssFile' => false, 'class' => 'CLinkPager', 'firstPageLabel' => 'First', 'prevPageLabel' => 'Previous', 'nextPageLabel' => 'Next', 'lastPageLabel' => 'Last', 'header' => '', 'selectedPageCssClass' => 'active'), 'pagerCssClass' => 'pagination'));
?>
<script>
$(function(){
$('.detailService').popup({
height:500,
});
});
</script>
/**
* 验证机构名称 手机号码 邮箱是否重复
*/
public function actionCheckorgan()
{
$model = Yii::app()->db->createCommand()->select("OrganID as organID")->from("tbl_user")->where("id=:userid", array(":userid" => Yii::app()->user->id))->queryRow();
if (empty($model['organID'])) {
$organID = 0;
} else {
$organID = $model['organID'];
}
$name = $_GET['name'];
if (!empty($name)) {
$model = Service::model()->findAll("userId!=:organID and serviceName=:name", array(":organID" => $organID, ":name" => $name));
if (!empty($model)) {
$message = "机构名称已存在,不可重复";
} else {
$phone = $_GET['phone'];
if (!empty($phone)) {
$model = Service::model()->findAll("userId!=:organID and serviceCellPhone=:phone", array(":organID" => $organID, ":phone" => $phone));
if (!empty($model)) {
$message = "手机号码已被使用";
} else {
$email = $_GET['email'];
if (!empty($email)) {
$model = Service::model()->findAll("userId!=:organID and serviceEmail=:email", array(":organID" => $organID, ":email" => $email));
if (!empty($model)) {
$message = "邮箱已被使用";
}
}
}
}
}
}
if (empty($message)) {
$result = TRUE;
} else {
$result = FALSE;
}
$resu['result'] = $result;
$resu['message'] = $message;
echo json_encode($resu);
}
public function actionTranslate()
{
$sqlsm = "";
$sqlm = "";
$i = 0;
$authorities = Authority::model()->findAll();
foreach ($authorities as $r) {
$sqlsm .= "insert into `SourceMessage` values (" . $i . ",'authorities','authority_" . htmlentities($r->id, ENT_QUOTES, 'UTF-8') . "_charge');<br>";
$sqlm .= "insert into `Message` values (" . $i . ",'es','" . htmlentities($r->charge, ENT_QUOTES, 'UTF-8') . "');<br>";
$sqlm .= "insert into `Message` values (" . $i++ . ",'en','');<br>";
}
echo $sqlsm;
echo $sqlm;
echo "<br/>";
$numbers = Numbers::model()->findAll();
$sqlsm = "";
$sqlm = "";
$i = 34;
foreach ($numbers as $s) {
$sqlsm .= "insert into `SourceMessage` values (" . $i . ",'numbers','numbers_" . htmlentities($s->id, ENT_QUOTES, 'UTF-8') . "_field');<br>";
$sqlm .= "insert into `Message` values (" . $i . ",'es','" . htmlentities($s->field, ENT_QUOTES, 'UTF-8') . "');<br>";
$sqlm .= "insert into `Message` values (" . $i++ . ",'en','');<br>";
}
echo $sqlsm;
echo $sqlm;
echo "<br/>";
$services = Service::model()->findAll();
$sqlsm = "";
$sqlm = "";
$i = 68;
foreach ($services as $s) {
$sqlsm .= "insert into `SourceMessage` values (" . $i . ",'services','services_" . htmlentities($s->id, ENT_QUOTES, 'UTF-8') . "_name');<br>";
$sqlm .= "insert into `Message` values (" . $i . ",'es','" . htmlentities($s->name, ENT_QUOTES, 'UTF-8') . "');<br>";
$sqlm .= "insert into `Message` values (" . $i++ . ",'en','');<br>";
$sqlsm .= "insert into `SourceMessage` values (" . $i . ",'services','services_" . htmlentities($s->id, ENT_QUOTES, 'UTF-8') . "_description');<br>";
$sqlm .= "insert into `Message` values (" . $i . ",'es','" . htmlentities($s->description, ENT_QUOTES, 'UTF-8') . "');<br>";
$sqlm .= "insert into `Message` values (" . $i++ . ",'en','');<br>";
}
echo $sqlsm;
echo $sqlm;
echo "<br/>";
$modules = Module::model()->findAll();
$sqlsm = "";
$sqlm = "";
foreach ($modules as $s) {
$sqlsm .= "insert into `SourceMessage` values (" . $i . ",'services','module_" . htmlentities($s->id, ENT_QUOTES, 'UTF-8') . "_name');<br>";
$sqlm .= "insert into `Message` values (" . $i . ",'es','" . htmlentities($s->name, ENT_QUOTES, 'UTF-8') . "');<br>";
$sqlm .= "insert into `Message` values (" . $i++ . ",'en','');<br>";
$sqlsm .= "insert into `SourceMessage` values (" . $i . ",'services','module_" . htmlentities($s->id, ENT_QUOTES, 'UTF-8') . "_description');<br>";
$sqlm .= "insert into `Message` values (" . $i . ",'es','" . htmlentities($s->description, ENT_QUOTES, 'UTF-8') . "');<br>";
$sqlm .= "insert into `Message` values (" . $i++ . ",'en','');<br>";
}
echo $sqlsm;
echo $sqlm;
echo "<br/>";
$departments = Department::model()->findAll();
$sqlsm = "";
$sqlm = "";
$i = 157;
foreach ($departments as $s) {
$sqlsm .= "insert into `SourceMessage` values (" . $i . ",'departments','department_" . htmlentities($s->id, ENT_QUOTES, 'UTF-8') . "_name');<br>";
$sqlm .= "insert into `Message` values (" . $i . ",'es','" . htmlentities($s->name, ENT_QUOTES, 'UTF-8') . "');<br>";
$sqlm .= "insert into `Message` values (" . $i++ . ",'en','');<br>";
}
echo $sqlsm;
echo $sqlm;
echo "<br/>";
$specialities = Speciality::model()->findAll();
$sqlsm = "";
$sqlm = "";
foreach ($specialities as $s) {
$sqlsm .= "insert into `SourceMessage` values (" . $i . ",'departments','speciality_" . htmlentities($s->id, ENT_QUOTES, 'UTF-8') . "_name');<br>";
$sqlm .= "insert into `Message` values (" . $i . ",'es','" . htmlentities($s->name, ENT_QUOTES, 'UTF-8') . "');<br>";
$sqlm .= "insert into `Message` values (" . $i++ . ",'en','');<br>";
}
echo $sqlsm;
echo $sqlm;
echo "<br/>";
$news = News::model()->findAll();
$sqlsm = "";
$sqlm = "";
$i = 229;
foreach ($news as $s) {
$sqlsm .= "insert into `SourceMessage` values (" . $i . ",'news','news_" . htmlentities($s->id, ENT_QUOTES, 'UTF-8') . "_title');<br>";
$sqlm .= "insert into `Message` values (" . $i . ",'es','" . htmlentities($s->title, ENT_QUOTES, 'UTF-8') . "');<br>";
$sqlm .= "insert into `Message` values (" . $i++ . ",'en','');<br>";
$sqlsm .= "insert into `SourceMessage` values (" . $i . ",'news','news_" . htmlentities($s->id, ENT_QUOTES, 'UTF-8') . "_description');<br>";
$sqlm .= "insert into `Message` values (" . $i . ",'es','" . htmlentities($s->description, ENT_QUOTES, 'UTF-8') . "');<br>";
$sqlm .= "insert into `Message` values (" . $i++ . ",'en','');<br>";
}
echo $sqlsm;
echo $sqlm;
echo "<br/>";
$doctors = Doctor::model()->findAll();
$sqlsm = "";
$sqlm = "";
$i = 406;
foreach ($doctors as $s) {
$sqlsm .= "insert into `SourceMessage` values (" . $i . ",'doctors','doctor_" . htmlentities($s->id, ENT_QUOTES, 'UTF-8') . "_specialty');<br>";
$sqlm .= "insert into `Message` values (" . $i . ",'es','" . htmlentities($s->specialism, ENT_QUOTES, 'UTF-8') . "');<br>";
$sqlm .= "insert into `Message` values (" . $i++ . ",'en','');<br>";
$sqlsm .= "insert into `SourceMessage` values (" . $i . ",'doctors','doctor_" . htmlentities($s->id, ENT_QUOTES, 'UTF-8') . "_fellowship');<br>";
$sqlm .= "insert into `Message` values (" . $i . ",'es','" . htmlentities($s->fellowship, ENT_QUOTES, 'UTF-8') . "');<br>";
$sqlm .= "insert into `Message` values (" . $i++ . ",'en','');<br>";
$sqlsm .= "insert into `SourceMessage` values (" . $i . ",'doctors','doctor_" . htmlentities($s->id, ENT_QUOTES, 'UTF-8') . "_interests');<br>";
$sqlm .= "insert into `Message` values (" . $i . ",'es','" . htmlentities($s->interests, ENT_QUOTES, 'UTF-8') . "');<br>";
$sqlm .= "insert into `Message` values (" . $i++ . ",'en','');<br>";
}
echo $sqlsm;
echo $sqlm;
echo "<br/>";
$sqlm = "";
$con = mysqli_connect("166.63.0.204", "webcont_dba", "lN_Q*PR]FN[E", "webcont_hm");
// Check connection
if (mysqli_connect_errno()) {
echo "Failed to connect to MySQL: " . mysqli_connect_error();
}
$result = mysqli_query($con, "SELECT id_mdc, especialidad_mdc, fellowship_mdc, intereses_mdc FROM medicos");
$j = 406;
while ($row = mysqli_fetch_array($result)) {
$sqlm .= "update `Message` set translation='" . $row['fellowship_mdc'] . "' where id=" . $j++ . " and language='en';<br>";
$sqlm .= "update `Message` set translation='" . $row['especialidad_mdc'] . "' where id=" . $j++ . " and language='en';<br>";
$sqlm .= "update `Message` set translation='" . $row['intereses_mdc'] . "' where id=" . $j++ . " and language='en';<br>";
}
mysqli_close($con);
echo $sqlm;
echo "<br/>";
$firstaids = FirstAid::model()->findAll();
$sqlsm = "";
$sqlm = "";
$i = 1263;
foreach ($firstaids as $s) {
$sqlsm .= "insert into `SourceMessage` values (" . $i . ",'firstaid','" . htmlentities($s->id, ENT_QUOTES, 'UTF-8') . "_title');<br>";
$sqlm .= "insert into `Message` values (" . $i . ",'es','" . htmlentities($s->title, ENT_QUOTES, 'UTF-8') . "');<br>";
$sqlm .= "insert into `Message` values (" . $i++ . ",'en','');<br>";
$sqlsm .= "insert into `SourceMessage` values (" . $i . ",'firstaid','" . htmlentities($s->id, ENT_QUOTES, 'UTF-8') . "_description');<br>";
$sqlm .= "insert into `Message` values (" . $i . ",'es','" . htmlentities($s->description, ENT_QUOTES, 'UTF-8') . "');<br>";
$sqlm .= "insert into `Message` values (" . $i++ . ",'en','');<br>";
}
echo $sqlsm;
echo $sqlm;
}
public function actionDashboard()
{
$service = Service::model()->with('user')->findByPk($this->user->getId());
if (($post = $this->request->getPost('Service', false)) != false) {
$service->rules = $post['rules'];
if ($service->save()) {
$task = Queue::createTask($this->createUrl('api/pac'), $service->uid);
Queue::enqueue($task);
}
}
$this->render('dashboard', ['service' => $service]);
}
