public static function updateApplyApi($newApplyApi = array(), $where = '0')
{
$tableName = $this->getTableName();
$newApplyApi = $this->formatUpdateField($tableName, $newApplyApi);
if (!$newApplyApi) {
self::$errMsg = $this->validatemsg;
return false;
}
$updateApplyApi = '';
foreach ($newApplyApi as $k => $v) {
$updateApplyApi .= $k . '="' . $v . '",';
}
$updateApplyApi = rtrim($updateApplyApi, ',');
$sql = 'UPDATE `' . C("DB_PREFIX") . 'call_api` SET ' . $updateApplyApi . ' WHERE ' . $where;
return $this->sql($sql)->update();
}
/**
* ApiModel::getSkuByPurids($purIds)
*通过采购id获取sku
* @return array
*/
public static function getSkuByPurids($purIds)
{
self::initDB();
$sql = "SELECT sku FROM pc_goods WHERE purchaseId IN ({$purIds})";
$query = self::$dbConn->query($sql);
if ($query) {
$res = self::$dbConn->fetch_array_all($query);
if (empty($res)) {
self::$errMsg = "result empty ---{$sql}";
return false;
}
return $res;
}
self::$errMsg = "query error ---{$sql}";
return false;
}
