public static function getCreateTime($id) { $dealer = Yii::app()->user->getOrganID(); if ($dealer && $id) { $model = PapClientType::model()->find("DealerID=:deal and ServiceID=:sid", array(':deal' => $dealer, ':sid' => $id))->attributes; if ($model['CreateTime']) { return date('Y-m-d H:i', $model['CreateTime']); } } return ""; }
public function actionEditclient() { $this->pageTitle = Yii::app()->name . '-' . "修改客户级别"; $DealerID = Yii::app()->user->getOrganID(); $ServiceID = $_POST['ServiceID']; $Cooperationtype = $_POST['Cooperationtype']; $model = PapClientType::model()->find('DealerID = :DealerID and ServiceID = :ServiceID', array(':DealerID' => $DealerID, ':ServiceID' => $ServiceID)); if ($model) { $model->ServiceID = $ServiceID; $model->Cooperationtype = $Cooperationtype; $model->CreateTime = time(); $model->UpdateTime = time(); $model->save(); if ($model->save()) { echo json_encode(array('success' => 1)); } } else { $sql = "insert into pap_client_type (DealerID,ServiceID,Cooperationtype,UpdateTime) values ('{$DealerID}','{$ServiceID}','{$Cooperationtype}'," . time() . ")"; $insert = Yii::app()->papdb->createCommand($sql)->query(); if ($insert) { echo json_encode(array('success' => 1)); } } }
public static function getContactprice($dealerID, $seriveID) { $criteria = new CDbCriteria(); $criteria->select = "Cooperationtype"; $criteria->addCondition("t.DealerID = {$dealerID}", "AND"); //经销商ID $criteria->addCondition("t.ServiceID = {$seriveID}", "AND"); //当前登录的修理厂ID $contact = PapClientType::model()->find($criteria); if (!$contact) { $contact['Cooperationtype'] = 'C'; } return PapGoodsPriceManage::model()->find(array("condition" => "OrganID = {$dealerID} AND CooperationType like '%{$contact['Cooperationtype']}%'")); }