function act_addPm($set)
{
return PackingMaterialsModel::addPm($set);
}
public static function getPmNameById($id)
{
self::initDB();
$sql = "select pmName from " . self::$table . " where id={$id} limit 1";
//echo $sql;
$query = self::$dbConn->query($sql);
if ($query) {
$ret = self::$dbConn->fetch_array_all($query);
return $ret[0]['pmName'];
} else {
self::$errCode = "1201";
self::$errMsg = "getPmList";
return false;
}
}
function content_526616b983b8b3_14494234($_smarty_tpl)
{
echo $_smarty_tpl->getSubTemplate("header.htm", $_smarty_tpl->cache_id, $_smarty_tpl->compile_id, null, null, array(), 0);
?>
<script type="text/javascript" src="./js/fancyBox/source/jquery.fancybox.js?v=2.1.3"></script>
<link rel="stylesheet" type="text/css" href="./js/fancyBox/source/jquery.fancybox.css?v=2.1.2" media="screen" />
<script type="text/javascript" src="./js/goodslist.js"></script>
<div class="fourvar">
<div class="pathvar">
<?php
echo $_smarty_tpl->getSubTemplate('pcNav.htm', $_smarty_tpl->cache_id, $_smarty_tpl->compile_id, null, null, array(), 0);
?>
</div>
<div class="texvar">
</div>
<div class="pagination">
<?php
echo $_smarty_tpl->tpl_vars['show_page']->value;
?>
</div>
</div>
<div class="servar products-servar">
<span>查找：
<input name="seachdata" type="text" id="seachdata" value="<?php
echo $_GET['seachdata'];
?>
"/>
<select name="searchs" id="searchs" >
<option value="1" <?php
if ($_GET['searchs'] == 1) {
?>
selected='selected'<?php
}
?>
>SPU</option>
<option value="2" <?php
if ($_GET['searchs'] == 2) {
?>
selected='selected'<?php
}
?>
>SKU</option>
</select>
</span>
<span>新/老品：
<select name="isNew" id="isNew" >
<option value="0" ></option>
<option value="1" <?php
if ($_GET['isNew'] == 1) {
?>
selected='selected'<?php
}
?>
>新品</option>
<option value="2" <?php
if ($_GET['isNew'] == 2) {
?>
selected='selected'<?php
}
?>
>老品</option>
</select>
</span>
<span>采购员：
<select name="purchaseId" id="purchaseId" >
<option value="0" > </option>
<?php
$_smarty_tpl->tpl_vars['value'] = new Smarty_Variable();
$_smarty_tpl->tpl_vars['value']->_loop = false;
$_from = Auth::getApiPurchaseUsers();
if (!is_array($_from) && !is_object($_from)) {
settype($_from, 'array');
}
foreach ($_from as $_smarty_tpl->tpl_vars['value']->key => $_smarty_tpl->tpl_vars['value']->value) {
$_smarty_tpl->tpl_vars['value']->_loop = true;
?>
<option value="<?php
echo $_smarty_tpl->tpl_vars['value']->value['userId'];
?>
" <?php
if ($_GET['purchaseId'] == $_smarty_tpl->tpl_vars['value']->value['userId']) {
?>
selected='selected'<?php
}
?>
><?php
echo $_smarty_tpl->tpl_vars['value']->value['userName'];
?>
</option>
<?php
}
?>
</select>
</span>
<span>类别
<select name="sku_category" id="pid_one" onchange="select_one();">
<option value="0"></option>
<?php
$_smarty_tpl->tpl_vars['value'] = new Smarty_Variable();
$_smarty_tpl->tpl_vars['value']->_loop = false;
$_from = CategoryModel::getCategoryList('*', "where is_delete=0 and pid=0");
if (!is_array($_from) && !is_object($_from)) {
settype($_from, 'array');
}
foreach ($_from as $_smarty_tpl->tpl_vars['value']->key => $_smarty_tpl->tpl_vars['value']->value) {
$_smarty_tpl->tpl_vars['value']->_loop = true;
?>
<option value="<?php
echo $_smarty_tpl->tpl_vars['value']->value['id'];
?>
"><?php
echo $_smarty_tpl->tpl_vars['value']->value['name'];
?>
</option>
<?php
}
?>
</select>
<span align="left" id="div_two" style="width:auto; display:none"></span>
<span align="left" id="div_three" style="width:auto; display:none"></span>
<span align="left" id="div_four" style="width:auto; display:none"></span>
</span>
<span><button id='seachGoods'/>搜索</button></span>
<?php
if ($_smarty_tpl->tpl_vars['categorySearch']->value != '') {
?>
<span style="color: green;">上次您搜索的类别为：<?php
echo $_smarty_tpl->tpl_vars['categorySearch']->value;
?>
</span>
<?php
}
?>
<span style="color: red;" id="error"><?php
echo $_GET['status'];
?>
</span>
</div>
<div class="main feedback-main">
<table class="products-action" cellspacing="0" width="100%">
<tr class="title">
<td>产品图片</td>
<td width="25%">产品名称</td>
<td>SPU</td>
<td>SKU</td>
<td>产品类别</td>
<td>产品成本</td>
<td>包材</td>
<td>重量</td>
<td>采购负责人</td>
<td>新/老品</td>
<td>供应商</td>
<td>操作</td>
</tr>
<?php
$_smarty_tpl->tpl_vars['value'] = new Smarty_Variable();
$_smarty_tpl->tpl_vars['value']->_loop = false;
$_from = $_smarty_tpl->tpl_vars['productList']->value;
if (!is_array($_from) && !is_object($_from)) {
settype($_from, 'array');
}
foreach ($_from as $_smarty_tpl->tpl_vars['value']->key => $_smarty_tpl->tpl_vars['value']->value) {
$_smarty_tpl->tpl_vars['value']->_loop = true;
?>
<tr id="<?php
echo $_smarty_tpl->tpl_vars['value']->value['id'];
?>
">
<td>
<a class="fancybox" href="http://192.168.200.200:9998/imgs/<?php
echo get_sku_imgName($_smarty_tpl->tpl_vars['value']->value['sku']);
?>
-G.jpg" target="_blank">
<img src="http://192.168.200.200:9998/imgs/<?php
echo get_sku_imgName($_smarty_tpl->tpl_vars['value']->value['sku']);
?>
-G_thumnail.jpg" width="50" height="50" style="border-style:solid;border-width:0" />
</a>
</td>
<td><?php
echo $_smarty_tpl->tpl_vars['value']->value['goodsName'];
?>
</td>
<td><?php
echo $_smarty_tpl->tpl_vars['value']->value['spu'];
?>
</td>
<td><?php
echo $_smarty_tpl->tpl_vars['value']->value['sku'];
?>
</td>
<td><?php
echo getAllCateNameByPath($_smarty_tpl->tpl_vars['value']->value['goodsCategory']);
?>
</td>
<td><?php
echo $_smarty_tpl->tpl_vars['value']->value['goodsCost'];
?>
</td>
<td><?php
echo PackingMaterialsModel::getPmNameById($_smarty_tpl->tpl_vars['value']->value['pmId']);
?>
</td>
<td><?php
echo $_smarty_tpl->tpl_vars['value']->value['goodsWeight'];
?>
</td>
<td><?php
echo getPersonNameById($_smarty_tpl->tpl_vars['value']->value['purchaseId']);
?>
</td>
<td><?php
if ($_smarty_tpl->tpl_vars['value']->value['isNew'] == 0) {
?>
老品<?php
} else {
?>
新品<?php
}
?>
</td>
<td><?php
echo OmAvailableModel::getParterNameBySku($_smarty_tpl->tpl_vars['value']->value['sku']);
?>
</td>
<td>
<input type="button" value="修改" tid="<?php
echo $_smarty_tpl->tpl_vars['value']->value['id'];
?>
" class="mod"/>
<input type="button" value="删除" tid="<?php
echo $_smarty_tpl->tpl_vars['value']->value['id'];
?>
" class="del"/>
</td>
</tr>
<?php
}
?>
</table>
</div>
<div class="bottomvar">
<div class="texvar">
</div>
<div class="pagination">
<?php
echo $_smarty_tpl->tpl_vars['show_page']->value;
?>
</div>
</div>
<?php
echo $_smarty_tpl->getSubTemplate("footer.htm", $_smarty_tpl->cache_id, $_smarty_tpl->compile_id, null, null, array(), 0);
?>
<script type="text/javascript">
$(document).ready(function() {
$(".fancybox").fancybox({
helpers: {
title : {
type : 'outside'
},
overlay : {
speedOut : 0
}
}
});
});
</script><?php
}
function act_skuVP2()
{
$goodsCode = post_check($_POST['goodsCode']);
$goodsLength = trim($_POST['goodsLength']);
$goodsWidth = trim($_POST['goodsWidth']);
$goodsHeight = trim($_POST['goodsHeight']);
$isPacking = trim($_POST['isPacking']);
$packageType = trim($_POST['packageType']);
$userId = $_SESSION['userId'];
if (intval($userId) <= 0) {
self::$errCode = 101;
self::$errMsg = '登陆超时，请重新登陆';
return false;
}
$pmId = trim($_POST['pmId']);
$pmCapacity = intval(trim($_POST['pmCapacity']));
if ($pmCapacity <= 0) {
$pmCapacity = 1;
}
$pmId = getPmIdByPmCode($pmId);
//获取对应的包材id,找不到对应包材返回false;
if (is_numeric($goodsLength) <= 0 || is_numeric($goodsLength) > 9999) {
self::$errCode = 102;
self::$errMsg = '长度有误';
return false;
}
if (is_numeric($goodsWidth) <= 0 || is_numeric($goodsWidth) > 9999) {
self::$errCode = 103;
self::$errMsg = '宽度有误';
return false;
}
if (is_numeric($goodsHeight) <= 0 || is_numeric($goodsHeight) > 9999) {
self::$errCode = 104;
self::$errMsg = '高度有误';
return false;
}
if (!$pmId) {
self::$errCode = 105;
self::$errMsg = '包材条码有误，找不到对应包材';
return false;
}
$skuList = getSkuBygoodsCode($goodsCode);
if (empty($skuList)) {
self::$errCode = 107;
self::$errMsg = '找不到对应SKU';
return false;
}
$skuTmp = $skuList[0]['sku'];
//旧的VP信息
$oldGoodsLength = $skuList[0]['goodsLength'];
$oldGoodsWidth = $skuList[0]['goodsWidth'];
$oldGoodsHeight = $skuList[0]['goodsHeight'];
//旧的包材信息
$oldPmId = $skuList[0]['pmId'];
$oldPmCapacity = $skuList[0]['pmCapacity'];
$vpArr = array();
//体积、包材、
$volumeFlag = false;
//体积变化标识，默认无变化
$pmFlag = false;
//包材变化标识，默认无变化
if ($oldGoodsLength != $goodsLength || $oldGoodsWidth != $goodsWidth || $oldGoodsHeight != $goodsHeight) {
//如果长，宽，高有一个与之前不相等
$vpArr['goodsLength'] = $goodsLength;
$vpArr['goodsWidth'] = $goodsWidth;
$vpArr['goodsHeight'] = $goodsHeight;
$volumeFlag = true;
//体积变化
}
if ($oldPmId != $pmId || $oldPmCapacity != $pmCapacity) {
$vpArr['pmId'] = $pmId;
$vpArr['pmCapacity'] = $pmCapacity;
$pmFlag = true;
//包材变化
}
$vpArr['isPacking'] = $isPacking;
$vpArr['packageType'] = $packageType;
try {
BaseModel::begin();
$tName = 'pc_goods';
$where = "WHERE sku='{$skuTmp}'";
OmAvailableModel::updateTNameRow2arr($tName, $vpArr, $where);
if ($volumeFlag) {
//体积变化则添加记录到对应表中
addVolumeBackupsModify($skuTmp, $goodsLength, $goodsWidth, $goodsHeight, $userId);
//添加体积变化记录
}
if ($pmFlag) {
//包材变化
addPmBackupsModify($skuTmp, $pmId, $pmCapacity, $userId);
//添加包材变化记录
}
$pName = PackingMaterialsModel::getPmNameById($pmId);
$paraArr = array();
$paraArr['goods_sn'] = str_pad($skuTmp, 3, 0, STR_PAD_LEFT);
$paraArr['goods_length'] = $goodsLength;
$paraArr['goods_width'] = $goodsWidth;
$paraArr['goods_height'] = $goodsHeight;
$is_packing = $isPacking;
$paraArr['ispacking'] = $is_packing == 1 ? 0 : 1;
$paraArr['ebay_packingmaterial'] = $pName;
$paraArr['package_type'] = $packageType;
$paraArr['capacity'] = $pmCapacity;
$res = OmAvailableModel::newData2ErpInterfOpen('pc.erp.addGoodsVp2', $paraArr, 'gw88');
BaseModel::commit();
BaseModel::autoCommit();
return array('state' => 200, 'sku' => $skuTmp . ' 单个SKU', 'pName' => $pName);
} catch (Exception $e) {
BaseModel::rollback();
BaseModel::autoCommit();
echo $e->getMessage();
}
}
