21,886
社区成员
发帖
与我相关
我的任务
分享
function mydg($bom){
global $db;
global $total;
$sql = "SELECT *,InvCode as yclwlbm, InvCode as wlbm FROM `pub_pp_bom_wl` where `bom` ='".$bom."' and `lock` = '0'";
$_list = $db->getAll($sql); //得到材料清单
foreach($_list as $inx=>$_rs){
if(intval($_rs['check_bom']) > 0){
$total += = mydg($_rs['InvCode']);
}else{
$sql = "SELECT unit_price FROM `public_co_material_price` where wlbm = '".$_rs['InvCode']."'";
$unit_price = $db->getOne($sql); //得到单价
if($unit_price==".0000000000") $unit_price = 0;
$total += ($_rs['sl'] * $unit_price) + (($unit_price * $_rs['sh'])*$_rs['sl']);
}
}
return $total;
}
function getOne($sql, $limited = false)
{
if ($limited == true)
{
$sql = trim($sql . ' LIMIT 1');
}
$res = $this->query($sql);
if ($res !== false)
{
$row = mysql_fetch_row($res);
if ($row !== false)
{
return $row[0];
}
else
{
return '';
}
}
else
{
return false;
}
}