public static function addOutletAgent($agent_name, $agent_mobile, $agent_position, $outlet_id)
{
$outlet = \app\models\ClientOutlet::findOne(['outlet_id' => $outlet_id]);
if (empty($outlet)) {
return json_encode(['code' => -1, 'errMsg' => "门店不存在！（{$outlet_id}）"]);
}
$agent = self::find()->join('INNER JOIN', 'client_agent_mobile', 'client_agent.agent_id=client_agent_mobile.agent_id')->where(['name' => $agent_name, 'mobile' => $agent_mobile])->one();
if (!empty($agent)) {
// return json_encode([
// 'code' => -1,
// 'errMsg' => "{$agent_name}({$agent_mobile})已存在！",
// ]);
} else {
$agent = new self();
$agent->name = $agent_name;
$agent->save(false);
\Yii::$app->db->createCommand()->insert('client_agent_mobile', ['agent_id' => $agent->agent_id, 'mobile' => $agent_mobile])->execute();
}
$row = (new \yii\db\Query())->select('*')->from('client_agent_outlet')->where(['agent_id' => $agent->agent_id, 'outlet_id' => $outlet->outlet_id])->one();
if (false === $row) {
\Yii::$app->db->createCommand()->insert('client_agent_outlet', ['agent_id' => $agent->agent_id, 'outlet_id' => $outlet->outlet_id, 'position' => $agent_position])->execute();
} else {
return json_encode(['code' => -1, 'errMsg' => "{$agent_name}({$agent_mobile})已存在门店{$outlet->title}中！"]);
}
return json_encode(['code' => 0]);
}
/**
* Creates data provider instance with search query applied
*
* @param array $params
*
* @return ActiveDataProvider
*/
public function search($params)
{
$query = ClientOutlet::find();
$dataProvider = new ActiveDataProvider(['query' => $query, 'pagination' => ['pageSize' => 24]]);
\Yii::warning(__METHOD__ . \yii\helpers\Json::encode($params));
\Yii::warning(__METHOD__ . \yii\helpers\Json::encode($this));
$this->load($params);
\Yii::warning(__METHOD__ . \yii\helpers\Json::encode($this));
if (!$this->validate()) {
// uncomment the following line if you do not want to return any records when validation fails
// $query->where('0=1');
return $dataProvider;
}
$query->andFilterWhere(['outlet_id' => $this->outlet_id, 'client_id' => $this->client_id, 'supervision_organization_id' => $this->supervision_organization_id, 'category' => $this->category, 'longitude' => $this->longitude, 'latitude' => $this->latitude, 'original_office_id' => $this->original_office_id]);
$query->andFilterWhere(['like', 'title', $this->title])->andFilterWhere(['like', 'address', $this->address])->andFilterWhere(['like', 'telephone', $this->telephone])->andFilterWhere(['like', 'pics', $this->pics]);
$query->andFilterWhere(['supervision_organization_id' => ClientOrganization::findOne(['organization_id' => $this->msc_id])->getMscIdArray()]);
\Yii::warning(__METHOD__ . \yii\helpers\Json::encode($query));
return $dataProvider;
}
public function actionOutlets()
{
$outlets = \app\models\ClientOutlet::find()->all();
foreach ($outlets as $outlet) {
$office = \app\models\MOffice::find()->where(['title' => $outlet->title])->one();
if (!empty($office)) {
echo "found {$outlet->title}" . PHP_EOL;
$details = \app\models\MOfficeCampaignDetail::findAll(['office_id' => $office->office_id]);
$pics = [];
foreach ($details as $detail) {
$pic_urls = explode(',', $detail->pic_url);
foreach ($pic_urls as $pic_url) {
$from = $detail->getPicFileByMedia($pic_url);
$media = str_replace('.jpg', '', $pic_url);
$to = $outlet->getPicPathname($media);
copy($from, $to);
$pics[] = $media;
}
}
$outlet->pics = implode(",", $pics);
$outlet->original_office_id = $office->office_id;
$outlet->latitude = $office->lat;
$outlet->longitude = $office->lon;
$outlet->save(false);
}
}
}
public function actionAgent($filename = 'agent.csv')
{
$xyunicom = \app\models\WosoClient::findOne(['title_abbrev' => '襄阳联通']);
if (empty($xyunicom)) {
die('不能找到襄阳联通。');
}
$filepathname = Yii::$app->getRuntimePath() . DIRECTORY_SEPARATOR . 'imported_data' . DIRECTORY_SEPARATOR . $filename;
$fh = fopen($filepathname, "r");
while (!feof($fh)) {
$contact_person = trim($fields[0]);
$contact_person_utf8 = iconv('GBK', 'UTF-8//IGNORE', $contact_person);
$msc_brev_name = trim($fields[1]);
$msc_brev_name_utf8 = iconv('GBK', 'UTF-8//IGNORE', $msc_brev_name);
$title = trim($fields[2]);
$title_utf8 = iconv('GBK', 'UTF-8//IGNORE', $title);
$mobiles = explode(';', trim($fields[3]));
// echo "{$contact_person_utf8},{$msc_brev_name_utf8},{$title_utf8},{$fields[3]}".PHP_EOL;
$supervision_organization = \app\models\ClientOrganization::find()->where(['like', 'title', $msc_brev_name_utf8])->andWhere(['client_id' => $xyunicom->client_id])->one();
// $supervision_organization = \Yii::$app->db->createCommand('select * from client_organization where title like \'%:title%\'')
// ->bindValue(':title', $msc_brev_name_utf8)->queryOne();
if (empty($supervision_organization)) {
die("找不到{$msc_brev_name_utf8}");
}
// var_dump($supervision_organization);
$row = false;
foreach ($mobiles as $mobile) {
$mobile = trim($mobile);
$row = (new \yii\db\Query())->select('*')->from('client_agent')->join('INNER JOIN', 'client_agent_mobile', ['client_agent.agent_id' => 'client_agent_mobile.agent_id'])->where(['name' => $contact_person_utf8, 'mobile' => $mobile])->one();
if (false !== $row) {
break;
}
}
if (false !== $row) {
$agent = \app\models\ClientAgent::findOne(['agent_id' => $row['agent_id']]);
} else {
$agent = new \app\models\ClientAgent();
$agent->name = $contact_person_utf8;
$agent->save(false);
}
$outlet = \app\models\ClientOutlet::findOne(['title' => $title_utf8]);
if (empty($outlet)) {
$outlet = new \app\models\ClientOutlet();
$outlet->title = $title_utf8;
$outlet->client_id = $xyunicom->client_id;
$outlet->telephone = $fields[3];
$outlet->category = \app\models\ClientOutlet::CATEGORY_COOPERATED;
$outlet->supervison_organization_id = $supervision_organization->organization_id;
$outlet->save(false);
} else {
$outlet->client_id = $xyunicom->client_id;
$outlet->telephone = $fields[3];
$outlet->category = \app\models\ClientOutlet::CATEGORY_COOPERATED;
$outlet->supervison_organization_id = $supervision_organization->organization_id;
$outlet->save(false);
}
$row = (new \yii\db\Query())->select('*')->from('client_agent_outlet')->where(['agent_id' => $agent->agent_id, 'outlet_id' => $outlet->outlet_id])->one();
if (false === $row) {
\Yii::$app->db->createCommand()->insert('client_agent_outlet', ['agent_id' => $agent->agent_id, 'outlet_id' => $outlet->outlet_id, 'position' => '店主'])->execute();
}
foreach ($mobiles as $mobile) {
if (strlen($mobile) != 11 || !is_numeric($mobile)) {
echo "[{$mobile}]非手机号码." . PHP_EOL;
} else {
$row = (new \yii\db\Query())->select('*')->from('client_agent_mobile')->where(['mobile' => $mobile])->one();
if (false === $row) {
\Yii::$app->db->createCommand()->insert('client_agent_mobile', ['agent_id' => $agent->agent_id, 'mobile' => $mobile])->execute();
}
}
}
}
fclose($fh);
}
public function getManageOutlet()
{
return $this->hasOne(\app\models\ClientOutlet::className(), ['original_office_id' => 'office_id', 'client_id' => 'client_id']);
}
public function actionClientOutletEmployeeEdit($gh_id, $openid, $backwards = true, $pop = false)
{
if (!$backwards) {
\app\models\utils\BrowserHistory::delete($gh_id, $openid);
\app\models\utils\BrowserHistory::push($gh_id, $openid);
} else {
if ($pop) {
\app\models\utils\BrowserHistory::pop($gh_id, $openid);
} else {
\app\models\utils\BrowserHistory::push($gh_id, $openid);
}
}
$wx_user = \app\models\MUser::findOne(['gh_id' => $gh_id, 'openid' => $openid]);
$this->layout = false;
$is_agent = $_GET['is_agent'];
$outlet_id = $_GET['outlet_id'];
if ($is_agent) {
$agent_id = $_GET['entity_id'];
$entity = \app\models\ClientAgent::findOne(['agent_id' => $agent_id]);
} else {
$employee_id = $_GET['entity_id'];
$entity = \app\models\ClientEmployee::findOne(['employee_id' => $employee_id]);
}
$outlet = \app\models\ClientOutlet::findOne(['outlet_id' => $outlet_id]);
return $this->render('client-outlet-employee-edit', ['wx_user' => $wx_user, 'entity' => $entity, 'is_agent' => $is_agent, 'outlet' => $outlet, 'backwards' => $backwards]);
}
<header class="bar bar-nav">
<a class="icon icon-left-nav pull-left" id="btn_back" onclick="back2pre();"></a>
<h1 class="title">
<!--
<img src="../web/images/comm-icon/iconfont-liwu.png?v5" width="18">
-->
员工管理
</h1>
</header>
<?php
$outlet = \app\models\ClientOutlet::findOne(['outlet_id' => $outlet_id]);
?>
<!-- Wrap all non-bar HTML in the .content div (this is actually what scrolls) -->
<div class="content">
<p class="content-padded">
<table width="100%" border=0 style="padding:3px;text-align:center">
<tr>
<td width=100%>
<button class="btn btn-positive btn-block">
<?php
echo $outlet->title;
?>
员工总数
/**
* Finds the ClientOutlet model based on its primary key value.
* If the model is not found, a 404 HTTP exception will be thrown.
* @param integer $id
* @return ClientOutlet the loaded model
* @throws NotFoundHttpException if the model cannot be found
*/
protected function findModel($id)
{
if (($model = ClientOutlet::findOne($id)) !== null) {
return $model;
} else {
throw new NotFoundHttpException('The requested page does not exist.');
}
}
public function getOutlets()
{
return $this->hasMany(\app\models\ClientOutlet::className(), ['supervision_organization_id' => 'organization_id']);
}
public function actionYgglxiugaiajax()
{
$is_agent = $_GET['is_agent'];
$entity_id = $_GET['entity_id'];
$outlet_id = $_GET['outlet_id'];
$mobile = $_GET['mobile'];
$position = $_GET['position'];
$outlet = \app\models\ClientOutlet::findOne(['outlet_id' => $outlet_id]);
if ($is_agent) {
$ret = $outlet->alterAgent($entity_id, $mobile, $position);
} else {
$ret = $outlet->alterEmployee($entity_id, $mobile, $position);
}
if (false === $ret) {
return json_encode(['code' => -1]);
} else {
return json_encode(['code' => 0]);
}
}
public function getPromoteOutlet()
{
return $this->hasOne(\app\models\ClientOutlet::className(), ['original_office_id' => 'belongto']);
}
public function getOutlet()
{
return $this->hasOne(ClientOutlet::className(), ['original_office_id' => 'office_id']);
}
