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 Add($modelName, $return)
{
$user_id = Commonmodel::getOrganID();
if ($_POST[$modelName]) {
$post = $_POST[$modelName];
if ($modelName == 'MakeEmpowerDealer') {
$make = MakeEmpowerDealer::model()->findByPk($post['id']);
if (empty($make)) {
$telephone = $_POST['telephone'];
$dealer = Dealer::model()->find("Phone='{$telephone}'");
if (empty($dealer)) {
Yii::app()->db->createCommand()->insert('tbl_user', array('username' => $telephone, 'password' => md5($telephone), 'email' => $telephone . '@jiaparts.com', 'status' => '1', 'create_at' => date('Y-m-d H-i-s', time()), 'identity' => '2'));
$newuserID = Yii::app()->db->getLastInsertID();
Yii::app()->db->createCommand()->insert('tbl_profiles', array('user_id' => $newuserID));
Yii::app()->db->createCommand()->insert('tbl_dealer', array('userID' => $newuserID, 'organName' => $post['organName'], 'jiapartsId' => $telephone, 'loginPassword' => md5($telephone), 'Phone' => $telephone));
$post['dealer_id'] = Yii::app()->db->getLastInsertID();
} else {
$post['dealer_id'] = $dealer->id;
}
$make = new MakeEmpowerDealer();
}
$post['up_userID'] = $user_id;
} elseif ($modelName == 'MakeContacts') {
$make = MakeContacts::model()->findByPk($post['id']);
if (empty($make)) {
$make = new MakeContacts();
}
$post['up_userID'] = $user_id;
} elseif ($modelName == 'MakeDistributionBusiness') {
$make = MakeDistributionBusiness::model()->findByPk($post['id']);
if (empty($make)) {
$make = new MakeDistributionBusiness();
}
$post['up_userID'] = $user_id;
} elseif ($modelName == 'MakeStorageService') {
$make = MakeStorageService::model()->findByPk($post['id']);
if (empty($make)) {
$make = new MakeStorageService();
}
$post['up_userID'] = $user_id;
} elseif ($modelName == 'MakeTechniqueService') {
$make = MakeTechniqueService::model()->findByPk($post['id']);
if (empty($make)) {
$make = new MakeTechniqueService();
}
$post['up_userID'] = $user_id;
$post['serviceTime'] = $_POST['beginWeek'] . '至' . $_POST['endWeek'] . ' ' . $_POST['beginHour'] . '-' . $_POST['endHour'];
}
$make->attributes = $post;
$make->save();
$this->redirect(array($return));
}
}
public function authenticate()
{
$username = strtolower($this->username);
$user = Dealer::model()->find('LOWER(username)=?', array($username));
if ($user === null) {
$this->errorCode = self::ERROR_USERNAME_INVALID;
} else {
if (!$user->validatePassword($this->password)) {
$this->errorCode = self::ERROR_PASSWORD_INVALID;
} else {
$this->_id = $user->id;
$this->username = $user->username;
$this->errorCode = self::ERROR_NONE;
}
}
return $this->errorCode == self::ERROR_NONE;
}
/**
* Creates a new model.
* If creation is successful, the browser will be redirected to the 'view' page.
*/
public function actionCreate()
{
$model = new User();
// Uncomment the following line if AJAX validation is needed
// $this->performAjaxValidation($model);
$dealer = Dealer::model()->find('id=:id', array(':id' => Yii::app()->user->id));
// var_dump($dealer->id);
// return;
$currentUsers = User::model()->count('dealer_id=:dealer', array('dealer' => Yii::app()->user->id));
if ($currentUsers >= $dealer->user_limit) {
throw new CHttpException(401);
}
if (isset($_POST['User'])) {
$model->attributes = $_POST['User'];
if ($model->save()) {
$this->redirect(array('view', 'id' => $model->id));
}
}
$this->render('create', array('model' => $model));
}
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;
}
public function actionSharecontact()
{
$organID = Commonmodel::getOrganID();
$dealer = Dealer::model()->find('userID=:userid', array(':userid' => $organID));
$share = BusinessShare::model()->findAll('InitiatorID=:intorID and Status=2', array(':intorID' => $organID));
foreach ($share as $key => $value) {
$shareID .= ',' . $value['ShareID'];
}
$shareID = ltrim($shareID, ",");
//查出shareID
$sql = "select a.id,a.contact_user_id,a.customertype,\n\t\t a.cooperationtype,a.name,a.sex,\n\t\t a.companyname,a.phone,a.province,a.city,a.area,a.email,\n\t\t a.weixin,a.QQ,a.create_time,a.Status,a.jiapart_ID,a.update_time,\n\t\t (select b.category from tbl_customer_category b where a.customercategory=b.id and a.user_id={$organID}) as customercategory\n\t\t from tbl_business_contacts a where \n\t\t user_id='{$organID}' and Status=0 and a.contact_user_id in({$shareID})";
if ($_POST) {
$search['name'] = $_POST['name'];
$search['phone'] = $_POST['phone'];
$search['keyword'] = $_POST['keyword'];
if ($search) {
if ($search['name']) {
$sql .= " and name like'%{$search['name']}%'";
}
if ($search['phone']) {
$sql .= " and phone like '%{$search['phone']}%'";
}
if ($search['keyword']) {
$sql .= " and (companyname like '%{$search['keyword']}%') ";
}
}
}
$sql .= "order by create_time desc";
$criteria = new CDbCriteria();
$models = Yii::app()->db->createCommand($sql)->queryAll();
$count = count($models);
$pages = new CPagination($count);
$pages->pageSize = intval($_GET['rows']);
$pages->applylimit($criteria);
$models = Yii::app()->db->createCommand($sql . " LIMIT :offset,:limit");
$models->bindValue(':offset', $pages->currentPage * $pages->pageSize);
$models->bindValue(':limit', $pages->pageSize);
$models = $models->queryAll();
foreach ($models as $key => $value) {
$data[$key]['id'] = $value['id'];
$data[$key]['Initiator'] = F::msubstr($dealer['organName']);
$data[$key]['companyID'] = $value['contact_user_id'];
//$data[$key]['customertype'] = $value['customertype'];
$data[$key]['cooperationtype'] = $value['cooperationtype'];
$data[$key]['customercategory'] = $value['customercategory'];
$data[$key]['name'] = $value['name'];
$data[$key]['sex'] = $value['sex'];
$data[$key]['companyname2'] = F::msubstr($value['companyname']);
$data[$key]['companyname'] = $value['companyname'];
$data[$key]['phone'] = $value['phone'];
$data[$key]['province'] = $value['province'];
$data[$key]['city'] = $value['city'];
$data[$key]['area'] = $value['area'];
$data[$key]['address'] = F::msubstr(Area::getCity($value['province']) . Area::getCity($value['city']) . Area::getCity($value['area']));
$data[$key]['email'] = $value['email'];
$data[$key]['weixin'] = $value['weixin'];
$data[$key]['QQ'] = $value['QQ'];
$data[$key]['create_time'] = $value['create_time'];
$data[$key]['Status'] = $value['Status'];
$data[$key]['jiapart_ID'] = $value['jiapart_ID'];
$data[$key]['update_time'] = $value['update_time'];
//$data[$key]['checked']=true;
}
$rs = array('total' => $count, 'rows' => !empty($data) ? $data : array());
echo json_encode($rs);
}
public function actionMainbusupdate()
{
$this->pageTitle = Yii::app()->name . '-' . "主营登记";
$userID = Commonmodel::getOrganID();
$model = Dealer::model()->findByAttributes(array('userID' => $userID));
// 显示车系
$showvehicle = DealerVehicle::model()->findAll('userid=:userid', array(':userid' => $userID));
// 显示主营品类
$showcpname = DealerCpname::model()->findAll('OrganID=:userID', array(':userID' => $userID));
//$sqlveh = "select * from jpd_dealer_vehicle where userid = $userID";
//$showvehicle = DBUtil::queryAll($sqlveh);
//ajax校验
$this->render('mainbusiness_update', array('model' => $model, 'showvehicles' => $showvehicle, 'showcpnames' => $showcpname));
}
/**
* 公司信息保存
*/
public function actionSavedealerorgan()
{
$OrganID = Yii::app()->user->getOrganID();
$Organ = Yii::app()->request->getParam("Organ");
$arr = Yii::app()->request->getParam("telPhone");
$TelPhone = "";
foreach ($arr as $key => $val) {
if (empty($val)) {
continue;
}
$TelPhone .= $val . ",";
}
$model = Organ::model()->findByPK($OrganID);
if (empty($model)) {
$model = new Organ();
}
//保存organ数据
$model->attributes = $Organ;
$model->TelPhone = trim($TelPhone, ',');
//判断基本信息是否为空，为空则不提交
if ($Organ) {
//接收删除图片的地址
$photoId = Yii::app()->request->getParam("photoId");
//判断是否删除图片
if (!empty($photoId)) {
$imageids = explode(',', $photoId);
foreach ($imageids as $imageid) {
$picture = OrganPhoto::model()->find('Path=:img AND OrganID=:OrganID', array(':img' => $imageid, ':OrganID' => $OrganID));
//判断该图片路径是否存在数据库中
if (empty($picture)) {
$ftp = new Ftp();
$res = $ftp->delete_file($imageid);
$ftp->close();
} else {
OrganPhoto::model()->deleteAll('Path=:img AND OrganID=:OrganID', array(':img' => $imageid, ':OrganID' => $OrganID));
$ftp = new Ftp();
$res = $ftp->delete_file($picture->Path);
$ftp->close();
}
}
}
//接收上传图片地址
$goodsImages = Yii::app()->request->getParam("goodsImages");
//判断是否有上传图片
if (!empty($goodsImages)) {
$imglegth = count($goodsImages);
for ($i = 0; $i < $imglegth; $i++) {
$goodsImg = new OrganPhoto();
$goodsImg->OrganID = $OrganID;
$goodsImg->Path = $goodsImages[$i];
$goodsImg->save();
}
}
//判断是否上传营业执照
$BLPoto = Yii::app()->request->getParam("BLPoto");
if ($model->BLPoto != $BLPoto) {
if (!empty($model->BLPoto)) {
$ftp = new Ftp();
$res = $ftp->delete_file($model->BLPoto);
$ftp->close();
}
$model->BLPoto = $BLPoto;
}
//接收dealer数据
$dealer = Yii::app()->request->getParam("Dealer");
//保存dealer数据
$dealermodel = Dealer::model()->find("OrganID=:organid", array(":organid" => $OrganID));
if (empty($dealermodel)) {
//判断是否第一次添加
$dealermodel = new Dealer();
$dealermodel->OrganID = $OrganID;
}
$dealermodel->SaleMoney = $dealer['SaleMoney'];
$dealermodel->SaleDomain = $dealer['SaleDomain'];
$dealermodel->ShopArea = $dealer['ShopArea'];
if ($dealermodel->save() && $model->save()) {
//保存成功
$this->redirect(array('index'));
} else {
var_dump($dealermodel->errors);
var_dump($model->errors);
die;
}
}
}
private static function getOrganName($ogranID)
{
$organName = Dealer::model()->find("userID = {$ogranID}");
$organInfo = array();
$organInfo['QQ'] = $organName['QQ'];
$organInfo['organName'] = $organName['organName'];
$organInfo['Phone'] = $organName['Phone'];
$organInfo['ContactPhone'] = $organName['ContactPhone'];
return $organInfo;
}
public function actionDealerinfo()
{
if ($_GET['userID']) {
$arr = Dealer::model()->find('userID=' . $_GET['userID']);
echo json_encode($arr->attributes);
}
}
public function actionDetail()
{
$model = Dealer::model()->find("userID=:userID", array(":userID" => $_GET['dealer']));
// 机构照片
$organphotoSql = "select id, photoName from tbl_dealer_organphoto where dealerID = " . $_GET['dealer'];
$organphotos = DBUtil::queryAll($organphotoSql);
$brands = DealerBrand::model()->findAll("OrganID = {$_GET['dealer']}");
$data = array();
foreach ($brands as $key => $brand) {
$data[$key]['brandname'] = $brand['BrandName'];
}
//主营车系
$dealerv = DealerVehicle::model()->findAll("userID=:userID", array(":userID" => $_GET['dealer']));
//主营品类
$cpnames = DealerCpname::model()->findAll("OrganID=:userID", array(":userID" => $_GET['dealer']));
$this->render("detail", array('model' => $model, 'organphotos' => $organphotos, 'dealerv' => $dealerv, 'cpnames' => $cpnames, 'data' => $data));
}
public function savedealerdata()
{
$OrganID = Yii::app()->user->getOrganID();
//接收dealer数据
$dealer = Yii::app()->request->getParam("Dealer");
//保存dealer数据
$dealermodel = Dealer::model()->find("OrganID=:organid", array(":organid" => $OrganID));
if (empty($dealermodel)) {
//判断是否第一次添加
$dealermodel = new Dealer();
$dealermodel->OrganID = $OrganID;
}
$dealermodel->SaleMoney = $dealer['SaleMoney'];
$dealermodel->SaleDomain = $dealer['SaleDomain'];
$dealermodel->ShopArea = $dealer['ShopArea'];
if (!$dealermodel->save()) {
//var_dump($dealermodel->errors);die;
throw new CHttpException(400, '保存机构信息失败！');
}
}
/**
* 修改机构信息
*/
private function updateOrgan($mobphone, $qq, $email)
{
$userID = Yii::app()->user->id;
$usertype = User::model()->find('id=' . $userID);
// 获取会员的类型
if ($usertype['identity'] == 1) {
// 生产商
$bool = MakeOrgan::model()->updateByPk($userID, array('mobile_phone' => $mobphone, 'qq' => $qq));
} elseif ($usertype['identity'] == 2) {
// 经销商
$bool = Dealer::model()->updateAll(array('Phone' => $mobphone, 'QQ' => $qq), 'userID=:userID', array(':userID' => $userID));
} elseif ($usertype['identity'] == 3) {
// 修理厂
$bool = Service::model()->updateByPk($userID, array('serviceCellPhone' => $mobphone, 'serviceQQ' => $qq));
} else {
//用户不存在
$bool = false;
}
return $bool;
}
/**
* 检查授权经销商登记使用的手机号是否存在
*/
public function actionCheckorgan()
{
$telephone = $_GET['telephone'];
$organName = $_GET['organName'];
$user_id = Commonmodel::getOrganID();
$model = Dealer::model()->findAll("Phone='{$telephone}' and organName!='{$organName}'");
if (!empty($model)) {
$result = 1;
} else {
$model2 = Dealer::model()->findAll("Phone!='{$telephone}' and organName='{$organName}'");
if (!empty($model2)) {
$result = 2;
} else {
$model1 = MakeEmpowerDealer::model()->findAll("organName='{$organName}' and up_userID = {$user_id}");
if (!empty($model1)) {
$result = 3;
} else {
$dealer = Dealer::model()->find("Phone='{$telephone}' and organName='{$organName}'");
$model3 = MakeEmpowerDealer::model()->findAll("dealer_id='{$dealer->id}' and up_userID = {$user_id}");
if (!empty($model3)) {
$result = 4;
} else {
$result = 100;
}
}
}
}
echo json_encode($result);
}
/**
* 验证机构名称 手机号码 邮箱是否重复
*/
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 = Dealer::model()->findAll("userID!=:organID and organName=:name", array(":organID" => $organID, ":name" => $name));
if (!empty($model)) {
$message = "机构名称已存在,不可重复";
} else {
$phone = $_GET['phone'];
if (!empty($phone)) {
$model = Dealer::model()->findAll("userID!=:organID and Phone=:phone", array(":organID" => $organID, ":phone" => $phone));
if (!empty($model)) {
$message = "手机号码已被使用";
} else {
$email = $_GET['email'];
if (!empty($email)) {
$model = Dealer::model()->findAll("userID!=:organID and Email=: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);
}
/**
* 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 = Dealer::model()->findByPk($id);
if ($model === null) {
throw new CHttpException(404, 'The requested page does not exist.');
}
return $model;
}
