/**
* @param int $supplierId 供应商id
* @return array 渠道包管理列表
*/
public function getChannelListBySupplierId($supplierId, $page = 1, $page_size = 10)
{
if (!empty($supplierId) && is_numeric($supplierId)) {
$where = array("supplier_id" => $supplierId);
}
$offest = ($page - 1) * $page_size;
$channeList = $this->supplier_channel_channels->find($where, array(), $page_size, $offest);
if (!empty($channeList)) {
$supplierIds = array();
foreach ($channeList as $channeRow) {
$supplierIds[] = $channeRow['supplier_id'];
}
$supplierListRs = $this->supplier_channel_account->findById($supplierIds);
$supplierList = array();
foreach ($supplierListRs as $supplierRow) {
$supplierList[$supplierRow['id']] = $supplierRow;
}
foreach ($channeList as &$channeRow) {
$supplier_id = $channeRow['supplier_id'];
$channeRow['supplier'] = $supplierList[$supplier_id]['supplier'];
$channeRow['price'] /= 100;
// 数据库存储单位为分
}
}
return $channeList;
}
public function addSupplier($supplier, $new_username, $new_password)
{
$result = "";
if (!trim($supplier)) {
return "0aa";
}
$is_legal_username = preg_match("/^[a-zA-Z0-9_@.]{6,50}\$/", $new_username);
if (!$is_legal_username) {
return "a0a";
}
$is_legal_password = preg_match("/[0-9]{6}/", $new_password);
if (!$is_legal_password) {
return "aa0";
}
$suppliers = $this->getSuppliers();
if (in_array($supplier, $suppliers)) {
return "1aa";
}
$accounts = $this->getAccounts();
if (in_array($new_username, $accounts)) {
return "a1a";
}
$new_password = md5($new_password);
$row_affected = $this->supplier_channel_account->insert(array('supplier' => $supplier, 'account_name' => $new_username, 'password' => $new_password, 'is_admin' => 0));
if ($row_affected > 0) {
$result = "aaa";
}
return $result;
}
