/**
* 查询商品类型, 按照层次返回结果, 目前只支持两层
* 返回格式为:
* array(
* 0 => array (
* "id" => 1,
* "name" => "aaa",
* "parentId" => 0,
* "children" => array(
* 0 => array(
* "id" => 1,
* "name" => "aaa",
* "parentId" => 0,
* )
* )
* )
* )
* @param integer $typeId 父类型ID, 0表示返回所有
*/
public function getGoodsTypeTree()
{
$typeTree = array();
$types = $this->dao->fetchAllTypes();
// get the root type first
foreach ($types as $k => $type) {
if ($type["parentId"] <= 0) {
$typeTree[] = $type;
unset($types[$k]);
}
}
// fill the child types
foreach ($typeTree as $k => &$root) {
$children = array();
foreach ($types as $k2 => $type) {
if ($root["id"] === $type["parentId"]) {
$children[] = $type;
}
}
$root["children"] = $children;
}
return $typeTree;
}
/**
* 删除数据
*
* @param $data
*/
public function deleteById($id)
{
$dao = new GoodsDao();
$result = $dao->deleteById($id);
return $result;
}
/**
* 清理数据
*
* @param array $cleardata 要清理的类型
*/
public function clear($cleardata)
{
if (!is_array($cleardata)) {
return "数据清理失败";
}
try {
for ($i = 0; $i < sizeof($cleardata); $i++) {
$datatype = $cleardata[$i];
switch ($datatype) {
case '采购申请':
$dao = new PurchaseOrderHeadDao();
$dao->deleteAll('');
$dao = new PurchaseOrderDetailDao();
$dao->deleteAll('');
break;
case '客户资料':
$dao = new ClientsDao();
$dao->deleteAll('');
break;
case '故障登记':
$dao = new FaultLogsDao();
$dao->deleteAll('');
break;
case '定期检查':
$dao = new CheckLogsDao();
$dao->deleteAll('');
break;
case '投诉登记':
$dao = new ComplaintLogsDao();
$dao->deleteAll('');
break;
case '产品资料':
$dao = new GoodsDao();
$dao->deleteAll('');
break;
case '厂商资料':
$dao = new SupplyDao();
$dao->deleteAll('');
break;
case '库房资料':
$dao = new StorageDao();
$dao->deleteAll('');
break;
case '库存资料':
$dao = new StocksIndexDao();
$result = $dao->findAll()->toResultSet();
for ($j = 0; $j < sizeof($result); $j++) {
$tablename = $result[$j]['tablename'];
$dao->deleteAll('', $tablename);
}
$dao->deleteAll('', 'stc_currentstocks');
$dao->deleteAll('', 'stc_codeIndex');
break;
case '条码规则':
$dao = new CodeDictDao();
$dao->deleteAll('');
break;
case '开灯记录':
$dao = new UnconfirmstationDao();
$dao->deleteAll('');
break;
}
}
} catch (Exception $e) {
throw new Exception($e);
}
return true;
}
