/**
* 添加供应商的函数
* @return $result $result > 0 成功，否则失败
*/
public function addPartner()
{
global $dbConn;
$data = array('company_name' => post_check($_POST['company_name']), 'username' => post_check($_POST['username']), 'tel' => post_check($_POST['tel']), 'phone' => post_check($_POST['phone']), 'fax' => post_check($_POST['fax']), 'e_mail' => post_check($_POST['e_mail']), 'address' => post_check($_POST['address']), 'note' => post_check($_POST['note']), 'city' => post_check($_POST['city']), 'QQ' => post_check($_POST['QQ']), 'AliIM' => post_check($_POST['AliIM']), 'shoplink' => post_check($_POST['shoplink']), 'type_id' => post_check($_POST['type_id']), 'company_id' => post_check($_POST['company_id']), 'purchaseuser_id' => post_check($_POST['purchaser_id']), 'sms_status' => post_check($_POST['sms_status']), 'email_status' => post_check($_POST['email_status']), 'limit_money' => post_check($_POST['limitmoney']), 'limit_alert_money' => post_check($_POST['alertmoney']), 'payWay' => $_POST['payWay']);
$row = PartnerModel::getOne($_POST['company_name']);
if (!empty($row)) {
$arr = array('code' => 2, 'msg' => '该供应商已存在');
return json_encode($arr);
}
$dbConn->begin();
//开启事务
$dataSql = array2sql($data);
$sql = "insert into ph_partner set {$dataSql}";
if ($dbConn->execute($sql)) {
$partnerid = mysql_insert_id();
$sql = "insert into ph_user_partner_relation (`partnerId`, `purchaseId`, `companyname`) VALUES ({$partnerid},{$_POST['purchaser_id']},'{$_POST['company_name']}')";
if ($dbConn->execute($sql)) {
$dbConn->commit();
//提交事务
$arr = array('code' => 1, 'msg' => '添加成功');
} else {
$dbConn->rollback();
//事务回滚
$arr = array('code' => 0, 'msg' => '添加失败');
}
} else {
$arr = array('code' => 0, 'msg' => '添加失败');
}
return json_encode($arr);
}
