111 lines
2.6 KiB
PHP
111 lines
2.6 KiB
PHP
<?php
|
|
|
|
class flow_goodsClassModel extends flowModel
|
|
{
|
|
|
|
public $base;
|
|
public function initModel()
|
|
{
|
|
$this->base = m('goods');
|
|
}
|
|
|
|
protected function flowchangedata(){
|
|
$this->rs['typeid'] = $this->base->gettypename($this->rs['typeid']);
|
|
}
|
|
|
|
//导入数据的测试显示
|
|
public function flowdaorutestdata()
|
|
{
|
|
return array(
|
|
'typeid' => '办公耗材/笔',
|
|
'name' => '红色粉笔',
|
|
'num' => 'WP-829',
|
|
'guige' => '红色',
|
|
'xinghao' => '5厘米',
|
|
'price' => '0.1',
|
|
'unit' => '盒',
|
|
'stockcs' => '20',
|
|
);
|
|
}
|
|
|
|
public function flowxiangfields(&$fields)
|
|
{
|
|
$fields['stock'] = '总库存';
|
|
$where = '';
|
|
if(ISMORECOM){
|
|
$comid = arrvalue($this->rs,'comid','0');
|
|
$where = ' and `comid`='.$comid.'';
|
|
}
|
|
$kcrow = m('godepot')->getall('1=1'.$where.'','*','`sort`');
|
|
foreach($kcrow as $k1=>$rs1){
|
|
$fields['stock_'.$rs1['id'].''] = $rs1['depotname'];
|
|
}
|
|
return $fields;
|
|
}
|
|
|
|
//
|
|
public function flowrsreplace($rs, $lx=0)
|
|
{
|
|
|
|
if(isset($rs['typeid']) && is_numeric($rs['typeid']))
|
|
$rs['typeid'] = $this->base->gettypename($rs['typeid']);
|
|
|
|
//详情页下显示对应仓库库存
|
|
if($lx==1){
|
|
$drows = $this->db->getall("SELECT `depotid`,sum(count)count FROM `[Q]goodss` where aid=".$rs['id']." and `status`=1 GROUP BY `depotid`");
|
|
foreach($drows as $k1=>$rs1)$rs['stock_'.$rs1['depotid'].''] = $rs1['count'];
|
|
}
|
|
return $rs;
|
|
}
|
|
|
|
//导入之前
|
|
public function flowdaorubefore($rows)
|
|
{
|
|
$inarr = array();
|
|
$db = m('goods');
|
|
$num = 'goodstype';
|
|
if(ISMORECOM && $cnum=$this->adminmodel->getcompanynum())$num.='_'.$cnum.'';
|
|
foreach($rows as $k=>$rs){
|
|
$rs['typeid'] = $this->option->gettypeid($num,$rs['typeid']);
|
|
|
|
//判断是否存在
|
|
$odi = $db->existsgoods($rs);
|
|
if($odi)continue;
|
|
|
|
$rs['price'] = floatval($this->rock->repempt($rs['price'],'0')); //金额
|
|
//$rs['stockcs'] = (int)$this->rock->repempt(arrvalue($rs,'stockcs','0')); //无用
|
|
|
|
$inarr[] = $rs;
|
|
}
|
|
|
|
return $inarr;
|
|
}
|
|
|
|
//导入后处理（刷新库存）
|
|
public function flowdaoruafter($ddoa=array())
|
|
{
|
|
//初始库存
|
|
m('goods')->setstock();
|
|
}
|
|
|
|
//删除时
|
|
protected function flowdeletebill($sm)
|
|
{
|
|
m('goodss')->delete('`aid`='.$this->id.'');
|
|
m('goods')->setstock();
|
|
}
|
|
|
|
protected function flowbillwhere($uid, $lx)
|
|
{
|
|
$where = '';
|
|
$typeid = $this->rock->post('typeid','0');
|
|
if($typeid!='0'){
|
|
$alltpeid = m('option')->getalldownid($typeid);
|
|
$where .= ' and `typeid` in('.$alltpeid.')';
|
|
}
|
|
return array(
|
|
'where' => $where,
|
|
'order' => 'optdt desc',
|
|
);
|
|
}
|
|
} |