public function getStorageQuotationsToJson($code)
{
$cotations = $this->dao->getValuesFromAnAtive($code);
return $this->buildJsonArray($cotations);
}
/**
* 删除库房
* @param $id
* @return boolean
*/
public function deleted($data)
{
try {
$storeage = new StorageDao();
//检查仓库是否已经使用
$storageName = $data["storageName"];
$stocks = new CurrentStocksDao();
$count = $stocks->getCount("place='{$storageName}' or station = '{$storageName}'");
if ($count > 0) {
$this->setError("该" . $data['stype'] . "含有库存,不能删除!");
return false;
}
$id = $data["id"];
$result = $storeage->deleteById($id);
} catch (Exception $e) {
system_out("StorageAction delete exception:" . $e);
throw new Exception($e);
}
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;
}
<?php
error_reporting(E_ALL);
ini_set('display_errors', '1');
require_once '../../../DataBase/Connection.php';
require_once '../../../../util/Maps/HashMap.php';
require_once '../../../Link/LinkController.php';
require_once '../HtmlLib.php';
require_once 'StorageDao.php';
$allCots = HtmlLib::cotacoes();
$types = array("BMF", "NY", "London", 'Arabica', 'Dolar', 'Euro', 'IBovespa');
$storage = new StorageDao(Connection::connect());
foreach ($types as $val) {
if ($allCots->containsKey($val)) {
$cots = $allCots->get($val);
foreach ($cots as $cot) {
$cotation = turnItToObj($cot);
try {
if ($cotation->hasValidValues()) {
echo $storage->saveFuturas($cotation);
} else {
echo 'Não foi possível salvar os valores de ' . $cotation->getCode();
}
} catch (PDOException $err) {
echo $err->getMessage() . '<br />';
} catch (Exception $err) {
echo $err->getMessage() . '<br />';
}
}
}
}
/**
* 库存一览表
*
* @param string $condition
*/
public function queryCurrentStocksGeneral($condition)
{
try {
$storage = new StorageDao();
$sql = "select storageNo,storageName from " . (DB_PREFIX ? DB_PREFIX . "_" : "") . "storage where stype = '库房' or stype='库区' order by storageNo";
$storageList = $storage->query($sql)->toArray();
$stocks = new CurrentStocksDao();
$sql = "select goodsName,spec from " . (DB_PREFIX ? DB_PREFIX . "_" : "") . "currentstocks ";
if ($condition != '') {
$sql = $sql . " where " . $condition;
}
$sql .= "group by goodsName,spec";
//echo $sql ;
$goodsList = $stocks->query($sql)->toArray();
//数据
$data = array();
for ($i = 0; $i < sizeof($goodsList); $i++) {
$item = array();
$item["goodsName"] = $goodsList[$i]["goodsName"];
$item["spec"] = $goodsList[$i]["spec"];
//计算每个仓库的值
foreach ($storageList as $place) {
$sql = "goodsName = '" . $goodsList[$i]["goodsName"] . "' and spec ='" . $goodsList[$i]["spec"] . "' and placeno like'" . $place['storageNo'] . "%'";
if ($condition != '') {
$sql = $sql . " and " . $condition;
}
//echo $sql ."<br>";
$sum = $stocks->getSum('qty', $sql);
$item[$place['storageNo']] = $sum;
}
array_push($data, $item);
}
//计算合计
$sumrecord['goodsName'] = '合计:';
foreach ($storageList as $place) {
$sumrecord[$place['storageNo']] = ExFunction::ex_array_sum($data, $place['storageNo']);
}
array_push($data, $sumrecord);
//表的结构
$item = array("goodsName", "spec");
$label = array("goodsName" => "品名", "spec" => "型号");
foreach ($storageList as $place) {
array_push($item, $place['storageNo']);
$label[$place['storageNo']] = $place['storageName'];
}
$columnitem = $item;
$enabled = array("_type_" => "*");
$visible = array("_type_" => "*");
$align = array();
$width = array("qty" => 50);
$inputtype = array();
$struct["item"] = $item;
$struct["label"] = $label;
$struct["columnitem"] = $columnitem;
$struct["enabled"] = $enabled;
$struct["visible"] = $visible;
$struct["align"] = $align;
$struct["width"] = $width;
$struct["inputtype"] = $inputtype;
//返回值
$rtn["struct"] = $struct;
$rtn["data"] = $data;
return $rtn;
} catch (Exception $e) {
throw new Exception($e);
}
}
