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 actionModify()
{
$id = intval($_GET['id']);
// $manufacturer_id=Yii::app()->user->id;
$manufacturer_id = Commonmodel::getOrganID();
$model = new GoodsTemplate();
if (isset($_POST['ajax']) && $_POST['ajax'] === 'templatemodify-form') {
echo CActiveForm::validate($model);
Yii::app()->end();
}
$sql = "select a.name,a.Column1,a.Column2,a.Column3,a.Column4,a.Column5,b.cp_name,a.standard_id,b.system_type from tbl_goods_template a,tbl_goods_standard b " . " where b.id=a.standard_id and a.id={$id} and manufacturer_id= {$manufacturer_id}";
$result = DBUtil::query($sql);
$model->system_type = $result['system_type'];
$model->cpname = $result['standard_id'];
if (isset($_POST['GoodsTemplate'])) {
$model->attributes = $_POST['GoodsTemplate'];
$name = $_POST['GoodsTemplate']['name'];
$Column1 = $_POST['GoodsTemplate']['Column1'];
$Column2 = $_POST['GoodsTemplate']['Column2'];
$Column3 = $_POST['GoodsTemplate']['Column3'];
$Column4 = $_POST['GoodsTemplate']['Column4'];
$Column5 = $_POST['GoodsTemplate']['Column5'];
$standard_id = $_POST['GoodsTemplate']['cpname'];
$result = $model->updateByPk($id, array('name' => $name, 'Column1' => $Column1, 'Column2' => $Column2, 'Column3' => $Column3, 'Column4' => $Column4, 'Column5' => $Column5, 'standard_id' => $standard_id));
Yii::app()->user->setFlash('success', '修改成功');
$this->refresh();
}
//所有常用配件
$sql = "select distinct system_type,id from tbl_goods_standard where system_type is not null group by system_type";
$parts = Yii::app()->db->createCommand($sql)->queryAll();
$this->render('modify', array('model' => $model, 'result' => $result, 'parts' => $parts));
}
/**
* 创建订单
*/
public function actionCreateorder()
{
$userID = Commonmodel::getOrganID();
$order_no = time() . rand(2, 100) . $userID;
// 订单编号
$make_id = '3';
// 卖家
$dealer_id = $userID;
// 买家
$stauts = 10;
$addtime = time();
//生成订单
$bool = Yii::app()->db->createCommand()->insert('tbl_dealer_order', array('order_no' => $order_no, 'maker_id' => $make_id, 'dealer_id' => $dealer_id, 'status' => $stauts, 'add_time' => $addtime));
// 生成的订单ID
$orderid = Yii::app()->db->getLastInsertID();
// 购买的商品
$tempgoods = DealerTempGoods::model()->findAll('user_id=:userid', array(':userid' => $userID));
foreach ($tempgoods as $goods) {
//生成订单商品
$bool = Yii::app()->db->createCommand()->insert('tbl_dealer_order_goods', array('order_id' => $orderid, 'goods_id' => $goods['goods_id'], 'goods_no' => $goods['goods_no'], 'name' => $goods['name'], 'brand_id' => $goods['brand_id'], 'price' => $goods['price'], 'parts_level' => $goods['parts_level'], 'quantity' => $goods['quantity']));
}
if ($bool) {
$id = $_GET['promID'];
$count = DealerTempGoods::model()->deleteAll('id IN (' . $id . ')');
if ($count > 0) {
$bool = true;
} else {
$bool = false;
}
}
echo $bool;
}
/**
* 登记入库
*/
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 actionMaintainlist()
{
$userID = Commonmodel::getOrganID();
$criteria = new CDbCriteria();
$criteria->with = "owners";
if ($_GET) {
if ($_GET['name']) {
$remind = $this->getRecord($_GET['name']);
$criteria->addInCondition('t.ID', $remind);
}
if ($_GET['status']) {
$criteria->addCondition("t.Status = {$_GET['status']}", "AND");
}
if ($_GET['date']) {
$starttime = strtotime($_GET['date']);
$endtime = (int) (strtotime($_GET['date']) + 60 * 60 * 24);
$criteria->addBetweenCondition('t.MaintainDate', $starttime, $endtime, "AND");
}
}
$criteria->order = "t.MaintainDate DESC,t.UpdateTime DESC";
//排序条件:t.MaintainDate,t.UpdateTime倒叙
$criteria->addCondition("t.OrganID = {$userID}", "AND");
$count = MaintainRemind::model()->count($criteria);
$pages = new CPagination($count);
$pages->pageSize = $_GET['rows'];
$pages->applyLimit($criteria);
$model = MaintainRemind::model()->findAll($criteria);
foreach ($model as $key => $value) {
$data[$key]['ID'] = $value['ID'];
if ($value['Status'] == '1') {
$data[$key]['State'] = '待发送';
} elseif ($value['Status'] == '2') {
$data[$key]['State'] = '已发送';
} else {
$data[$key]['State'] = '取消发送';
}
$data[$key]['Status'] = $value['Status'];
$data[$key]['MaintainDate'] = date('Y-m-d', $value['MaintainDate']);
$data[$key]['MaintainTime'] = $value['MaintainDate'];
$data[$key]['RemindContent'] = $value['RemindContent'];
$data[$key]['Content'] = F::msubstr($value['RemindContent']);
foreach ($value->owners as $owners_key => $owners_value) {
$data[$key]['OldName'] .= $owners_value->Name . ",";
$data[$key]['Name'] = F::msubstr(substr($data[$key]['OldName'], 0, -1));
}
}
$rs = array('total' => $count, 'rows' => $data ? $data : array());
echo json_encode($rs);
}
public function actionGetservicer()
{
//订购平台
$organID = Commonmodel::getOrganID();
//待确认的报价单
$result['dquotions'] = PapQuotation::model()->count(array('condition' => "status = 1 and ServiceID = {$organID}"));
//待付款的订单
$result['forder'] = PapOrder::model()->count(array('condition' => "Status = 1 and BuyerID = {$organID}"));
//待收货的订单
$result['torder'] = PapOrder::model()->count(array('condition' => "Status = 3 and BuyerID = {$organID}"));
//异常订单
$result['uorder'] = PapOrder::model()->count(array('condition' => "Payment=2 and Status not in (11,12,13,14) and IsUnusual!=0 and BuyerID = {$organID}"));
//待买家退货的订单
$ssorder1 = PapOrder::model()->count(array('condition' => "Payment=2 and Status = 12 and BuyerID = {$organID}"));
$ssorder2 = PapOrder::model()->count(array('condition' => "Payment=1 and PayStatus = 'WAIT_BUYER_RETURN_GOODS' and BuyerID = {$organID}"));
$result['sorder'] = $ssorder1 + $ssorder2;
echo json_encode($result);
}
public function actionEdit()
{
// $error=MakeGoodsBrand::model()->find('BrandName='.$_POST['BrandName']);
// if($error){
// echo json_encode(array('errorMsg'=>'该品牌已存在'));
// exit;
// }
$i = false;
if ($_GET['BrandID']) {
$result = MakeGoodsBrand::model()->findByPK($_GET['BrandID']);
if ($result->BrandName == $_POST['BrandName']) {
} else {
$error = MakeGoodsBrand::model()->find('BrandName=:BrandName && OrganID=:OrganID', array(':BrandName' => $_POST['BrandName'], ':OrganID' => Commonmodel::getOrganID()));
if ($error) {
echo json_encode(array('errorMsg' => '该品牌已存在'));
exit;
}
}
$_POST['UpdateTime'] = time();
$app1 = MakeGoodsBrand::model()->updateByPk($_GET['BrandID'], $_POST);
if ($app1) {
$i = true;
}
} else {
$error = MakeGoodsBrand::model()->find('BrandName=:BrandName && OrganID=:OrganID', array(':BrandName' => $_POST['BrandName'], ':OrganID' => Commonmodel::getOrganID()));
if ($error) {
echo json_encode(array('errorMsg' => '该品牌已存在'));
exit;
}
$app = new MakeGoodsBrand();
$app->attributes = $_POST;
$app->CreateTime = time();
$app->OrganID = Commonmodel::getOrganID();
$app->UserID = Yii::app()->user->id;
$app2 = $app->save();
if ($app2) {
$i = true;
}
}
echo json_encode(array('success' => $i, 'errorMsg' => $i > 0 ? '操作成功' : '操作失败'));
}
/**
* 获取参数名称列名
* @param type $cp_name 标准名称
*/
private function getParamName($cp_name)
{
$standardid = $this->cpnameID($cp_name);
$organID = Commonmodel::getOrganID();
$datas = MakeGoodsTemplate::model()->findAll('organID=' . $organID . ' and ISdelete="N" and standard_id=' . $standardid);
$paramsname = array();
// 参数名称
if ($datas) {
foreach ($datas as $data) {
$paramsname['_' . $data['id']] = $data['name'];
}
}
return $paramsname;
}
function parse($excelfile, $template, $data = array())
{
try {
//获取上传文件的文件名扩展名
$extend = strtolower(strrchr($excelfile, '.'));
$readerType = $extend == '.xlsx' ? 'Excel2007' : 'Excel5';
$objReader = new PHPExcel();
$objReader = PHPExcel_IOFactory::createReader($readerType);
//use Excel5 for 5fromat ,use excel2007 for 2007 format
$objPHPExcel = $objReader->load($excelfile);
if (!$objPHPExcel) {
$error = '加载Excel出错';
return array('success' => false, 'error' => $error);
}
$objWorksheet = $objPHPExcel->getActiveSheet();
//取得活动sheet
if (!$objWorksheet) {
$error = '加载Excel出错';
return array('success' => false, 'error' => $error);
}
$title = $objWorksheet->getTitle();
//取得sheet名称
$highestRow = $objWorksheet->getHighestRow();
//取得总行数
$highestColumn = $objWorksheet->getHighestColumn();
//取得总列数
$highestColumnIndex = PHPExcel_Cell::columnIndexFromString($highestColumn);
//总列数
//执行结果
$error = "";
$first_row = array();
for ($col = 0; $col < $highestColumnIndex; $col++) {
$first_row[$col] = $objWorksheet->getCellByColumnAndRow($col, 1)->getValue();
if ($first_row[$col] == '商品编号') {
$GoodsNO_col = $col;
}
}
//验证表结构，表名称和字段列表
if (!$this->validateExcel($template, $first_row)) {
$error = "Excel内容与模板不符合";
//$error = $first_row;
return array('success' => false, 'error' => $error);
}
//生成插入语句的头部
$sql_header = $this->generateSqlHeader($template, $first_row);
if ($sql_header == "") {
$error = "SQL语句头部生成失败";
return array('success' => false, 'error' => $error);
}
//生成SQL语句
$sql = $sql_header;
$i = 0;
$list = array();
for ($row = 2; $row <= $highestRow; $row++) {
//每行的第一列数据不能为空
$first_value = $objWorksheet->getCellByColumnAndRow(0, $row)->getValue();
$GoodsNO_value = $objWorksheet->getCellByColumnAndRow($GoodsNO_col, $row)->getValue();
if (in_array($GoodsNO_value, $list)) {
$success = false;
$error = '导入的商品编号重复';
return array('success' => $success, 'error' => $error);
}
if (empty($first_value)) {
continue;
}
$data_new = array();
$sql_data = '(';
////注意highestColumnIndex的列数索引从0开始
for ($col = 0; $col < $highestColumnIndex; $col++) {
$data_new[$col] = $objWorksheet->getCellByColumnAndRow($col, $row)->getValue();
if ($col == $GoodsNO_col) {
$criteria = new CDbCriteria();
$criteria->addCondition("GoodsNO = '{$data_new[$col]}'");
$criteria->addCondition("OrganID =" . Commonmodel::getOrganID());
$criteria->addCondition("ISdelete = 1");
// echo Commonmodel::getOrganID();exit;
$bool = DealerGoods::model()->find($criteria);
if (!empty($bool)) {
$success = false;
$error = '商品编号已存在';
return array('success' => $success, 'error' => $error);
}
}
// if($col==4){ // 大类
// $data_new[$col] = DealerBigparts::getBigpartsID( $data_new[$col]);
// }
// if($col==5){ // 子类
// $data_new[$col] = DealerSubparts::getSubpartsID($data_new[$col]);
// }
// if($col==6){ // 标准名称
// $data_new[$col] = DealerCpname::getCpNameID($data_new[$col]) ;
// }
$sql_data .= "'" . trim($data_new[$col]) . "',";
}
if ($template == "dealergoods") {
//
$sql_data .= "'" . $data['OrganID'] . "','" . $data['UserID'] . "','" . $data['CreateTime'] . "'";
}
$sql_data .= ")";
//var_dump($sql_data);exit;
//验证数据是否正确
//$this->validateData($data_new[$col]);
$sql .= $sql_data . ',';
$list[$i] = $GoodsNO_value;
$i++;
}
$sql = rtrim($sql, ",") . ";";
//返回结果数据
$success = false;
if ($error == "" && $sql != "") {
$success = true;
}
} catch (Exception $e) {
$success = false;
$error = '解析Excel出错' . $e->getMessage();
}
//echo $sql;exit;
return array('success' => $success, 'error' => $error, 'sql' => $sql);
}
public function actionSearch()
{
$sqldealer = "select dealer.id,dealer.BusinessScope,dealer.organName,dealer.jiapartsID,dealer.province,dealer.city,dealer.area,dealer.address,dealer.Phone,dealer.keyword,dealer.BusinessBrand,dealer.userID,dealer.ContactPhone from tbl_dealer as dealer ";
$searchSql = " where !ISNULL(dealer.organName)";
if (!empty($_GET['search'])) {
$search = $_GET['search'];
$search['mainCategory'] = $_GET['jpmall_maincate'];
$search['subCategory'] = $_GET['jpmall_subcate'];
$search['leafCategory'] = $_GET['jpmall_cpname'];
$search['cpname'] = $_GET['cpname'];
if (!empty($search['brand'])) {
$searchSql .= " AND dealer.userID in (select brand.OrganID from tbl_dealer_brand as brand where brand.BrandName like '%{$search['brand']}%' ) ";
}
if (!empty($search['province'])) {
if (!empty($search['city']) && $search['city'] != '0') {
$searchSql .= " AND dealer.province = '{$search['province']}' AND dealer.city = '{$search['city']}'";
} else {
$searchSql .= " AND dealer.province = '{$search['province']}'";
}
}
if ($search['mainCategory'] && $search['subCategory'] && $search['leafCategory']) {
$searchSql .= " AND dealer.userID in (select mogr.OrganID from tbl_dealer_cpname as mogr where\n (mogr.BigpartsID = '{$search['mainCategory']}' and mogr.SubCodeID = '' and mogr.CpNameID = '')\n or (mogr.BigpartsID = '{$search['mainCategory']}' and mogr.SubCodeID = '{$search['subCategory']}' and mogr.CpNameID = '')\n or (mogr.BigpartsID = '{$search['mainCategory']}' and mogr.SubCodeID = '{$search['subCategory']}' and mogr.CpNameID = '{$search['leafCategory']}'))";
} elseif ($search['subCategory'] && $search['mainCategory']) {
$searchSql .= " AND dealer.userID in (select mogr.OrganID from tbl_dealer_cpname as mogr where\n (mogr.BigpartsID = '{$search['mainCategory']}' and mogr.SubCodeID = '{$search['subCategory']}') \n or (mogr.BigpartsID = '{$search['mainCategory']}' and mogr.SubCodeID = '')) ";
} elseif ($search['mainCategory']) {
$searchSql .= " AND dealer.userID in (select mogr.OrganID from tbl_dealer_cpname as mogr where mogr.BigpartsID = '{$search['mainCategory']}' ) ";
}
if (!empty($search['payway'])) {
//echo $search['payway'];
// 查询授权的经销商ID
$organID = Commonmodel::getOrganID();
$sql = "select dealer_id from tbl_make_empower_dealer where up_userID = {$organID}";
if ($search['payway'] == 2) {
// 未授权经销商
$searchSql .= " AND dealer.userID NOT IN (select ed.DealerID from tbl_make_promit_brand ed where ed.OrganID = {$organID} ) ";
} else {
if ($search['payway'] == 3) {
// 授权经销商
$searchSql .= " AND dealer.userID IN (select ed.DealerID from tbl_make_promit_brand ed where ed.OrganID = {$organID} ) ";
}
}
}
// if(!empty($search['vehicleMake'])){
// $carcriteria=new CDbCriteria();
// if (!empty($search['vehicleModel'])){
// $carcriteria->addCondition("t.businessCar = '".$search['vehicleMake']."'",'AND');
// $carcriteria->addCondition("t.businessCarModel = '".$search['vehicleModel'])."'",'AND');
//// $searchSql.=" AND vehicle.businessCar = '".$search['vehicleMake']."' AND vehicle.businessCarModel= '".$search['vehicleModel']."'";
// }else {
// $carcriteria->addCondition("t.businessCar = '".$search['vehicleMake']."'",'AND');
//// $searchSql.=" AND vehicle.businessCar = '".$search['vehicleMake']."'";
// }
// $carcriteria->distinct=true;
// $carcriteria->select='t.userid';
// $carmodels=DealerVehicle::model()->findAll($carcriteria);
// if (!empty($carmodels)){
// foreach ($carmodels as $car){
// $users[]=$car->userid;
// }
// }
// $criteria->addInCondition('userID', $users);
// }
}
$sqldealer .= $searchSql;
$pagesize = 10;
$result = DBUtil::queryAll($sqldealer);
$count = count($result);
$pagess = 1;
if ($count % $pagesize) {
$pagess = floor($count / $pagesize) + 1;
}
$page = !empty($_GET['page']) ? $_GET['page'] : 1;
if ($page <= 1) {
$page = 1;
}
if ($page > $pagess) {
$page = $pagess;
}
$page = $pagesize * ($page - 1);
$limit = " limit {$page}, {$pagesize} ";
$dealers = DbUtil::queryAll($sqldealer . $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);
$this->render("search", array('search' => $search, 'dealers' => $dealers, 'count' => $count, 'page' => $page, 'pagesize' => $pagesize));
}
public function actionContact()
{
$OrganID = Commonmodel::getOrganID();
//获取共享关系表中机构ID
$ids = $this->getShareids();
//获取用户表中所有经销商ID
$users = User::getDealerID();
foreach ($users as $user) {
$identity[] = $user['id'];
}
//获取不在共享关系表中的机构信息
$criteria = new CDbCriteria();
$criteria->addInCondition('t.contact_user_id', $identity);
//业务联系人属于经销商
$criteria->addCondition("t.user_id = {$OrganID}", "AND");
//当前机构下
$criteria->addCondition("t.Status = 0", "AND");
//未删除
$criteria->addNotInCondition('t.contact_user_id', $ids);
//业务联系人不在确定共享关系中
$criteria->order = "t.create_time desc";
//以添加时间倒序
//通过机构名称模糊检索
if ($_GET['name']) {
$criteria->addSearchCondition('t.companyname', $_GET['name'], "AND");
}
//分页
$count = BusinessContacts::model()->count($criteria);
$pages = new CPagination($count);
$pages->pageSize = $_GET['rows'];
$pages->applyLimit($criteria);
$model = BusinessContacts::model()->findAll($criteria);
foreach ($model as $key => $value) {
$data[$key]['id'] = $value['id'];
$data[$key]['name'] = F::msubstr($value['name']);
$data[$key]['sex'] = $value['sex'];
$data[$key]['jiapart_ID'] = $value['jiapart_ID'];
$data[$key]['companyname'] = F::msubstr($value['companyname']);
$data[$key]['phone'] = F::msubstr($value['phone']);
$data[$key]['address'] = F::msubstr(Area::getCity($value['province']) . Area::getCity($value['city']) . Area::getCity($value['area']));
}
$rs = array('total' => $count, 'rows' => $data ? $data : array());
echo json_encode($rs);
}
public function actionCheckcar()
{
$organID = Commonmodel::getOrganID();
$criteria = new CDbCriteria();
$criteria->with = "owner";
$criteria->addCondition("t.OrganID = {$organID}");
$criteria->addSearchCondition('t.LicensePlate', "{$_POST['licenseplate']}", "AND");
$model = CarInfo::model()->findAll($criteria);
foreach ($model as $key => $value) {
//车辆ID
$data[$key]['ID'] = $value['ID'];
//车主信息
$data[$key]['Name'] = $value->owner->Name ? F::msubstr($value->owner->Name) : '未绑定';
$data[$key]['Phone'] = $value->owner->Phone ? F::msubstr($value->owner->Phone) : '未绑定';
$data[$key]['City'] = $value->owner->City ? F::msubstr(str_replace("/", "", $value->owner->City)) : '未绑定';
//车辆信息
$data[$key]['LicensePlate'] = F::msubstr($value['LicensePlate']);
if ($value['UseNature'] == '1') {
$data[$key]['Uses'] = "私家车";
} elseif ($value['UseNature'] == '2') {
$data[$key]['Uses'] = "公务车";
} else {
$data[$key]['Uses'] = "运营车辆";
}
$data[$key]['Car'] = F::msubstr(str_replace(",", "", $value['Car']));
$data[$key]['VinCode'] = $value['VinCode'];
$data[$key]['Miles'] = $value['Mileage'];
$data[$key]['BuyTime'] = date('Y-m-d', $value['BuyTime']);
}
$rs = array('totals' => count($model), 'rows' => $data ? $data : array());
echo json_encode($rs);
}
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 actionDelImgGoods()
{
$organID = Commonmodel::getOrganID();
$GoodsID = $_GET['goodsid'];
// $sql = "delete from tbl_dealer_goods_image_relation where OrganID = ".$organID." and GoodsID =".$GoodsID;
$model = DealerGoodsImageRelation::model()->deleteAll("OrganID= '{$organID}' and GoodsID='{$GoodsID}'");
if ($model) {
$model = 1;
}
echo json_encode($model);
}
public function actionDeltitle()
{
if (!isset($_GET['do']) || $_GET['do'] != 'unipei') {
echo '你没有权限访问！';
return;
}
$OrganID = Commonmodel::getOrganID();
$sql = "update pap_goods set Title ='' where OrganID = " . $OrganID;
$bool = Yii::app()->papdb->createCommand($sql)->execute();
if ($bool) {
echo "清楚成功";
var_dump($bool);
} else {
echo '清除失败';
}
}
/**
* 获取购买服务记录
*/
public function actionGetpushbuyrecord()
{
$organID = Commonmodel::getOrganID();
$criteria = new CDbCriteria();
$criteria->order = "ID DESC";
$criteria->condition = "OrganID = {$organID}";
$payway = $_GET['payway'];
$sendway = $_GET['sendway'];
$month = $_GET['month'];
if (!empty($month)) {
$recomtime = time();
if ($month == 1) {
// 1个月
$recomtime -= 24 * 60 * 60 * 30 * 1;
} elseif ($month == 3) {
// 3个月
$recomtime -= 24 * 60 * 60 * 30 * 3;
} elseif ($month == 6) {
// 6个月
$recomtime -= 24 * 60 * 60 * 30 * 6;
} elseif ($month == 12) {
// 1年
$recomtime -= 24 * 60 * 60 * 30 * 12;
} else {
$recomtime -= 24 * 60 * 60 * 30 * 44;
}
$criteria->addCondition("t.CreateTime >= {$recomtime} ", 'and');
}
if (!empty($sendway)) {
$criteria->addCondition("t.PushType = {$sendway}", 'and');
}
if (!empty($payway)) {
$criteria->addCondition("t.PayWay = {$payway}", 'and');
}
$count = PushbuyRecord::model()->count($criteria);
$pages = new CPagination($count);
$pages->pageSize = $_GET['rows'];
$pages->applyLimit($criteria);
$pushrecords = PushbuyRecord::model()->findAll($criteria);
$pushrecord = array();
foreach ($pushrecords as $key => $value) {
$pushrecord[$key]['ID'] = $value['ID'];
$pushrecord[$key]['PushType'] = $value['PushType'] == 1 ? '邮件' : '短信';
$pushrecord[$key]['Count'] = $value['Count'];
$pushrecord[$key]['PayWay'] = $this->payway($value['PayWay']);
$pushrecord[$key]['Amount'] = '￥ ' . $value['Amount'];
$pushrecord[$key]['CreateTime'] = date('Y年m月d日', $value['CreateTime']);
}
$rs = array('total' => $count, 'rows' => $pushrecord);
echo json_encode($rs);
}
/**
* 自定义验证规则 机构名称不能为空
*/
public function uniqueName()
{
if (!$this->hasErrors('Name')) {
$organID = Commonmodel::getOrganID();
if (!$this->ID) {
$model = self::model()->findAll("OrganID=:OrganID and Name=:name", array(':OrganID' => $organID, ':name' => $this->Name));
} else {
$model = self::model()->findAll("OrganID=:OrganID and Name=:name and ID!=:id", array(':OrganID' => $organID, ':name' => $this->Name, ':id' => $this->ID));
}
if (!empty($model)) {
$this->addError('Name', '该配送商名称已存在');
}
}
}
public function actionGetType()
{
$type_data = MakeType::model()->findAll(array("condition" => "OrganID = " . Commonmodel::getOrganID()));
//. " AND IsDefault = 0"
foreach ($type_data as $key => $type) {
$data[$key]['ID'] = $type->ID;
$data[$key]['TypeName'] = $type->TypeName;
}
echo json_encode($data);
}
public function actionPapeva()
{
$evarr = array();
$evarr = EvaluateService::getevainfo(3);
$this->pageTitle = Yii::app()->name . '-' . "添加评价";
$OrderID = Yii::app()->request->getParam('order');
//订单ID 传递前台(input)
if ($OrderID) {
$Status = $_GET['Status'];
//订单状态
$BuyerID = $_GET['BuyerID'];
//买家ID
$EvaStatus = $_GET['EvaStatus'];
//评价状态
$this->render('papeva', array('OrderID' => $OrderID, 'Status' => $Status, 'EvaStatus' => $EvaStatus, 'BuyerID' => $BuyerID, 'evarr' => $evarr));
exit;
} else {
$Status = $_POST['Status'];
$BuyerID = $_POST['BuyerID'];
$OrderID = $_POST['evalOrderID'];
$EvaStatus = $_POST['EvaStatus'] ? $_POST['EvaStatus'] : null;
$OrganID = Commonmodel::getOrganID();
$Message = Yii::app()->request->getParam('Evaluations');
// var_dump($Message);die;
$evaID = Yii::app()->request->getParam('evaID');
if (isset($_POST)) {
$addsql = "insert into pap_evaluation_organ (Identity,OrganID,Recier,JudgeID,OrderID,Score,Message,CreateTime) values ";
$keytop = 1;
foreach ($evaID as $ekeys => $evalue) {
if ($keytop != 1) {
$addsql .= ",";
}
$addsql .= "(";
$addsql .= 3;
$addsql .= ",";
$addsql .= $OrganID;
$addsql .= ",";
$addsql .= $BuyerID;
$addsql .= ",";
$addsql .= $ekeys;
$addsql .= ",";
$addsql .= $OrderID;
$addsql .= ",";
$addsql .= $evalue;
$addsql .= ",'";
$addsql .= htmlspecialchars($Message);
$addsql .= "',";
$addsql .= time();
$addsql .= ")";
$keytop = 2;
// EvaluateService::addjudgerecord($ekeys, $evalue, $BuyerID, 3, $OrderID);
}
$bool = Yii::app()->papdb->createCommand($addsql)->execute();
if ($bool) {
//获取被评价机构分数
$organScore = "select Recier,Score,OrderID from pap_evaluation_organ where OrganID={$OrganID} and OrderID=" . $OrderID;
$bool2 = Yii::app()->papdb->createCommand($organScore)->queryAll();
$sum = 0;
foreach ($bool2 as $v) {
$sum += $v['Score'];
}
//获取被评价的机构信用等级
$organGrade = "select Grade from jpd_organ where ID=" . $bool2[0]['Recier'];
$bool3 = Yii::app()->jpdb->createCommand($organGrade)->queryRow();
//更新被评价的机构信用等级
$sum2 = $sum + $bool3['Grade'];
$Gradesum = "update jpd_organ set Grade = {$sum2} where ID=" . $bool2[0]['Recier'];
$bool4 = Yii::app()->jpdb->createCommand($Gradesum)->execute();
if ($Status == 9 && $EvaStatus == null) {
$EvaStatus = 16;
//如果该订单经销商先评价，把状态改为16
} else {
if ($Status == 9 && $EvaStatus == 15) {
$EvaStatus = 20;
//如果该订单之前服务店评价过一次，则经销商此时评价状态改为20
}
}
$bool2 = PapOrder::model()->updateByPK($OrderID, array('EvaStatus' => $EvaStatus));
$rs = array('success' => 1, 'errorMsg' => '评价成功');
} else {
$rs = array('success' => 0, 'errorMsg' => '评价失败');
}
}
}
$this->render("evaresult", array('result' => $rs));
}
private function checkgoodno()
{
$organID = Commonmodel::getOrganID();
$sql = "select a.id, b.goods_no from tbl_make_goods a,tbl_make_goods_version b \n \twhere a.organID={$organID} and a.IsSale='0' and a.ISdelete='0' \n \tand a.id=b.goods_id and a.NewVersion=b.version_name and b.organID={$organID} \n \tand b.ISdelete='0'\n \t";
$datas = array();
$res = DBUtil::queryAll($sql);
foreach ($res as $key => $val) {
$datas[$val['id']] = $val['goods_no'];
}
return $datas;
}
public function actionUpdatelogistics()
{
$id = trim($_GET['ID']);
$organID = Commonmodel::getOrganID();
$model = Logistics::model()->findByPk($id);
if (isset($_POST)) {
$attributes['LogisticsDescription'] = $_POST['LogisticsDescription'];
$model->attributes = $attributes;
$model->LogisticsCompany = $_POST['LogisticsCompany'];
$model->OrganID = $organID;
$model->CreateTime = time();
$model->UpdateTime = time();
$model->Status = 2;
//状态为2是经销商物流
$bool = $model->save();
if ($bool) {
// 把地址添加到关系表里，可添加多个
$sprovince = $_POST['province'];
$scity = $_POST['city'];
$sarea = $_POST['area'];
$addlegth = count($sprovince);
for ($i = 0; $i < $addlegth; $i++) {
$model1 = new LogisticsAddress();
$model1->LogisticsID = $id;
$model1->Province = $sprovince[$i];
$model1->City = $scity[$i];
$model1->Area = $sarea[$i];
$model1->save();
}
}
if ($bool) {
$rs = array('success' => 1, 'errorMsg' => '物流公司修改成功');
} else {
$rs = array('success' => 0, 'errorMsg' => '物流公司修改失败');
}
}
echo json_encode($rs);
}
/**
* 商品编号接口
*/
public static function GetGoodsByGoodsNo($goodsno, $manufacturer_ID)
{
try {
//$userID=Yii::app()->user->id;
//$dealerID=Dealer::model()->find('userID=:userID',array(':userID'=>$userID));
//$grade=MakeEmpowerDealer::model()->find('up_userID=:up_userID and dealer_id=:dealer_id',array(':up_userID'=>$manufacturer_ID,':dealer_id'=>$dealerID->id));
// $sql=" select distinct a.id as goodsID,a.oe as OE, a.brand as brand ,a.NewVersion as verion_name,b.goodsno as goodsno,b.name as goodsname,b.price as makretprice,"
// ."b.price".$grade->grade." as goodsprice,"
// ." (select f.code from tbl_parts_level f where b.parts_level=f.id) as parts_level,"
// ." (select e.cp_name from tbl_goods_standard e where e.id=d.standard_id) as cp_name,"
// ." (select c.name from tbl_goods_category c where c.id=a.category_id and a.manufacturer_id=c.manufacturer_id) as category"
// //." (select n.car from tbl_goods_vehicle m,tbl_vehicle n where m.Goods_ID='$goodsID' and n.VehicleID in (m.VehicleID)) as car"
// ." from tbl_goods a ,tbl_goods_version b,tbl_goods_template d,tbl_vehicle n"
// .' where a.id=b.goods_id and a.NewVersion=b.version_name'
// ." and b.templet_id=d.id"
// ." and a.manufacturer_id=b.manufacturer_id"
// ." and a.ISdelete='N' and a.IsSale='Y' "
// ." and a.manufacturer_id=$manufacturer_ID "
// ." and a.id=$goodsID"
// ." group by a.id order by a.id desc";
//$sql=" select distinct a.id as goodsID ,a.oe as OE,a.brand as brand,a.NewVersion as verion_name,b.goodsno as goodsno,b.name as goodsname,b.price as marketprice,"
// ."b.price".$grade->grade." as goodsprice,"
// ." (select distinct f.code from tbl_parts_level f where b.parts_level=f.id) as parts_level,"
// ." (select distinct e.cp_name from tbl_goods_standard e where e.id=d.standard_id) as cp_name,"
// ." (select distinct c.name from tbl_goods_category c where c.id=a.category_id and a.manufacturer_id=c.manufacturer_id) as category"
// ." from tbl_goods a ,tbl_goods_version b,tbl_goods_category c,tbl_goods_template d,tbl_goods_standard e,tbl_parts_level f,tbl_goods_values g"
// .' where a.id=b.goods_id and a.NewVersion=b.version_name'
// ." and b.parts_level=f.id"
// ." and b.templet_id=d.id"
// ." and e.id=d.standard_id"
// ." and a.category_id=c.id"
// ." and b.values_id = g.id"
// ." and a.manufacturer_id=b.manufacturer_id"
// ." and a.ISdelete='N' and a.IsSale='Y'"
// ." and a.manufacturer_id='$manufacturer_ID' ";
// $sql.=" and b.goodsno='{$goodsno}'";
// $sql.=" group by a.id order by a.id desc";
//授权品牌
$organID = Commonmodel::getOrganID();
$brands = MakePromitBrand::model()->find('DealerID=' . $organID . ' and OrganID=' . $manufacturer_ID);
$sql2 = "select distinct a.id as goodsID ,b.goods_category as category_id,b.goods_oe as OE,b.goods_brand as brand,b.organID,\n \t\t \t a.NewVersion as verion_name,b.goods_no as goodsno,b.goods_name as goodsname,\n b.benchmarking_brand,b.benchmarking_sn,a.create_time,d.Price," . " b.inventory as inventory,b.senddays,b.description,a.IsSale,b.standard_id" . " from tbl_make_goods a ,tbl_make_goods_version b ,tbl_make_goods_vehicle c,tbl_make_price_relation d" . ' where a.id=b.goods_id and a.NewVersion=b.version_name' . " and a.ISdelete='0' and b.ISdelete=0" . " and a.organID='{$manufacturer_ID}' and b.goods_no='{$goodsno}'";
$identity = Commonmodel::getIdentity(Yii::app()->user->id);
if ($identity['identity'] == 2 && $brands['CustomerType']) {
$sql2 .= " and d.TypeID= {$brands['CustomerType']} and d.GoodsID=a.id and d.Price is not null and a.IsSale=0";
}
$result = Yii::app()->db->createCommand($sql2)->queryRow();
if ($result) {
//查询品牌名称
$brandmodel = MakeGoodsBrand::model()->findByPK($result['brand']);
$result['brand'] = $brandmodel['BrandName'];
//商品销售价
if ($result['Price']) {
$result['goodsprice'] = $result['Price'];
}
//$result['goodsprice']=sprintf("%.2f", $result['salesprice'] * $ratio / 100);
}
return $result;
} catch (CDbException $e) {
throw CDbException($e);
}
}
<?php
$controlerId = Yii::app()->getController()->id;
$actionId = $this->getAction()->getId();
$active = "class = 'active'";
$organID = Commonmodel::getOrganID();
$res = User::model()->findByPk($organID);
?>
<div class='tabs' pre='tab'>
<a class='left-indent'> </a>
<a <?php
if ($actionId == 'index') {
echo $active;
}
?>
href="<?php
echo Yii::app()->createUrl('cim/discountset/index');
?>
">商城订单</a>
<a <?php
if ($actionId == 'inquiry') {
echo $active;
}
?>
href="<?php
echo Yii::app()->createUrl('cim/discountset/inquiry');
?>
">询价单订单</a>
<a <?php
public static function delvehiclesgoods()
{
$Car = $_GET['cateid'];
$goodsid = $_GET['goodsid'];
$organID = Commonmodel::getOrganID();
$veh = PapGoodsVehicleRelation::model()->findAll("OrganID= '{$organID}' and Car='{$Car}' and GoodsID='{$goodsid}'");
$model = PapGoodsVehicleRelation::model()->deleteAll("OrganID= '{$organID}' and Car='{$Car}' and GoodsID='{$goodsid}'");
if ($model) {
$model = 1;
// PapGoods::model()->updateBypk($goodsid, array('VehVersion' => ''));
$time = time();
foreach ($veh as $vehv) {
$vehicle = array('Type' => 'del', 'Make' => $vehv->attributes['Make'], 'Car' => $vehv->attributes['Car'], 'Year' => $vehv->attributes['Year'], 'Model' => $vehv->attributes['Model'], 'Marktxt' => $vehv->attributes['Marktxt'], 'Cartxt' => $vehv->attributes['Cartxt'], 'Modeltxt' => $vehv->attributes['Modeltxt']);
$veharr = array('GoodsID' => (int) $vehv->attributes['GoodsID'], 'UpdateTime' => (int) $time, 'VehInfo' => $vehicle, 'Type' => 'del');
Yii::app()->mongodb->getDbInstance()->vehicle_log->insert($veharr);
}
}
return $model;
}
<script>
window.onload = function() {
var fileClass = "<?php
echo Commonmodel::getOrganID();
?>
";
// setTimeout(function() {
$("#file_upload").uploadify({
'auto': true,
'queueId': 'some_file+queue',
'swf': Yii_theme_baseUrl + '/js/uploadify/uploadify.swf',
'uploader': Yii_baseUrl + '/upload/uploadify',
'buttonText': '上传商品图片',
// 'width' : 82,//flash宽 由于设置的背景图片的宽是60 高是22 所以这里和下面设置60 22
'height': 25, //flash高
'method': 'post',
// 'formData': {'fileClass': fileClass, 'role': identity},
'formData': {'fileClass': fileClass, 'add': '0', 'role': 'second'},
'fileTypeExts': '*.gif; *.jpg; *.png; *.jpeg',
'queueSizeLimit': 5, //上传数量
'fileSizeLimit': '2MB', //上传文件的大小限制
'onFallback': function() {
$(".loadflash").show();
},
'onUploadStart': function(file) {
if ($("#showimglist").find("li").length >= 5) {
alert('上传图片过多，请删除队列中超过的图片');
$('#file_upload').uploadify('stop'); // 停止上传
$('#file_upload').uploadify('cancel'); // 清空队列
}
var imgarr = new Array();
private function Isexist($unitName, $ID = 0)
{
$organID = Commonmodel::getOrganID();
$bool = true;
if ($ID == 0) {
$count = DealerGoodsUnit::model()->count("OrganID= {$organID} and UnitName = '{$unitName}' ");
if ($count) {
$bool = false;
}
} else {
// 修改
$count = DealerGoodsUnit::model()->count("OrganID= {$organID} and ID!={$ID} and UnitName = '{$unitName}' ");
if ($count) {
$bool = false;
}
}
return $bool;
}
<?php
echo $form->labelEx($model, '经营级别：', array('class' => 'label'));
?>
<?php
echo $form->dropDownList($model, 'grade', CHtml::listData($level, 'level', 'level'), array('class' => 'width118 select', 'empty' => '选择级别'));
?>
<?php
echo $form->error($model, 'grade', array('style' => 'color: red;'));
?>
</p>
<p class="form-row">
<?php
echo $form->labelEx($model, '授权品类：', array('class' => 'label'));
?>
<?php
$cate_data = MakeEmpowerCategory::model()->findAll("userID=:userID", array(":userID" => Commonmodel::getOrganID()));
$categray = CHtml::listData($cate_data, "id", "cateName");
?>
<?php
echo $form->dropDownList($model, 'category', $categray, array('class' => 'width118 select', 'empty' => '选择品类'));
echo $form->error($model, 'category', array('style' => 'color: red;'));
?>
</p>
<p class="form-row">
<?php
echo $form->labelEx($model, '授权品牌：', array('class' => 'label'));
?>
<?php
echo $form->dropDownList($model, 'brand', array('A' => 'A', 'B' => 'B', 'C' => 'C'), array('class' => 'width118 select', 'empty' => '选择级别'));
?>
<?php
private static function getBrandByID($brand)
{
$organID = Commonmodel::getOrganID();
if (!$brand) {
return '';
}
$sql = "SELECT BrandName FROM `tbl_dealer_brand` WHERE ID = {$brand} and OrganID = {$organID}";
$brands = DBUtil::query($sql);
if ($brands) {
return $brands['BrandName'];
} else {
return '';
}
}
public function actionEditcategory()
{
$organID = Commonmodel::getOrganID();
$categoryid = intval($_GET['id']);
$userID = Yii::app()->user->id;
$model = MakeGoodsCategory::model()->find('name="' . $_POST['name'] . '" and organID=' . $organID . ' and id!=' . $categoryid);
if ($model) {
echo json_encode(array('msg' => 'nameexist'));
exit;
}
unset($model);
$model = MakeGoodsCategory::model()->findByPk($categoryid);
$model->attributes = $_POST;
$model->userID = $userID;
$model->updatetime = time();
if ($model->save()) {
echo json_encode(array('msg' => 'ok'));
} else {
echo json_encode(array('msg' => 'fail'));
}
}
public function actionSaveorgan()
{
$userId = Commonmodel::getOrganID();
//执行添加或修改操作
if ($_POST['Service']) {
$userId = Commonmodel::getOrganID();
$service = $_POST['Service'];
//获取营业时间、经营区域、地址
$openTime = $_POST['startWeek'] . "," . $_POST['endWeek'] . "," . $_POST['startTime'] . "," . $_POST['endTime'];
$service['serviceOpenTime'] = $openTime;
$service['serviceProvince'] = $_POST['serviceProvince'];
$service['serviceCity'] = $_POST['serviceCity'];
$service['serviceArea'] = $_POST['serviceArea'];
$service['serviceRegionProvince'] = $_POST['serviceRegionProvince'];
$service['serviceRegionCity'] = $_POST['serviceRegionCity'];
$service['serviceRegionArea'] = $_POST['serviceRegionArea'];
$rsType == false;
// 添加机构照片
if ($_POST['organImages']) {
$organImages = $_POST['organImages'];
$imglegth = count($organImages);
for ($i = 0; $i < $imglegth; $i++) {
$organImg = new ServicePhoto();
$organImg->userId = $userId;
$organImg->addTime = date("Y-m-d", time());
$organImg->photoName = $organImages[$i];
$organImg->save();
}
$rsType = true;
} else {
$rsType = true;
}
// 删除机构照片
if (!empty($_POST['photoName'])) {
$photoName = $_POST['photoName'];
//该处传过来的其实是图片名称
$imagenames = explode(',', $photoName);
foreach ($imagenames as $imagename) {
$myfileurl = Yii::app()->params['uploadPath'] . $imagename;
$oldpic = ServicePhoto::model()->find("photoName=:name", array(":name" => $imagename));
if ($oldpic) {
//存入数据库后删除
$bools = ServicePhoto::model()->deleteAll("photoName=:name", array(":name" => $imagename));
if ($bools) {
if (file_exists($myfileurl)) {
unlink($myfileurl);
}
}
} else {
//添加时删除（未存入数据库）
if (file_exists($myfileurl)) {
unlink($myfileurl);
}
}
}
$rsType = true;
} else {
$rsType = true;
}
//判断机构信息是否存在，存在则修改，不存在则添加
$model = Service::model()->find("userId=:userId", array(":userId" => $userId));
if (!empty($service)) {
if (empty($model)) {
$model = new Service();
$model->userId = $userId;
$model->attributes = $service;
if ($model->save()) {
$user = User::model()->findByPk($userId);
$user->OrganID = $userId;
$user->save();
}
$rsType = true;
}
$model->attributes = $service;
if ($model->updateByPk($userId, $service)) {
$rsType = true;
}
} else {
$rsType = true;
}
if ($rsType) {
echo json_encode('OK');
} else {
echo json_encode('NoOk');
}
}
}