public function __construct()
{
parent::__construct();
$this->smarty->template_dir = WEB_PATH . 'pda/html/';
$this->smarty->assign('curusername', $_SESSION['userId'] ? getUserNameById($_SESSION['userId']) : '');
//设置当前用户名
}
/**
* 提交信息生成订单
* @param string type 来源 package ，cart 。普通
* @param int cart_ids 购物车id
*/
public function makeOrder()
{
$work_id = I('get.workid');
if (!is_numeric($work_id)) {
$this->assign('message', '作品信息');
$this->display('Public/error');
exit;
}
$data['work_id'] = $work_id;
$data['order_category'] = 2;
$session = session('user');
$user_id = 2;
// $session['user_id'];
$data['user_id'] = $user_id;
if (empty($user_id)) {
$this->assign('message', '请登录后再操作');
$this->display('Public/error');
exit;
}
$data['order_number'] = '2cyj' . makeOrderCardId();
$worksModel = D('Works');
$work = $worksModel->getOrderWorkByid($work_id);
if (!$work) {
$this->assign('message', '生成订单异常，请重新操作');
$this->display('Public/error');
exit;
}
$data['author_id'] = $work['user_id'];
$data['auther'] = getUserNameById($work['user_id']);
$data['work_title'] = $work['title'];
$data['create_date'] = date('Y-m-d H:i:s', time());
$data['update_date'] = $data['create_date'];
$data['money'] = $work['money'];
$data['order_type'] = 0;
$data['handle'] = 1;
$data['ajax_type'] = 0;
$OrderModel = D('Order');
$id = $OrderModel->add($data);
if ($id) {
redirect('/Order/pay/orderid/' . $id);
} else {
$this->assign('message', '订单生成异常');
$this->display('Public/error');
exit;
}
}
public function act_selectsku()
{
$sku = isset($_POST['sku']) ? trim($_POST['sku']) : "";
$sku = get_goodsSn($sku);
$goodsinfo = wrapperSkuOutModel::skuinfo($sku);
$res = array();
if (empty($goodsinfo)) {
self::$errCode = 3;
self::$errMsg = "<font color='red'>系统没有相应包装材料，请核对！</font>" . $sku;
return $sku;
} else {
self::$errCode = 2;
self::$errMsg = "包装材料正确，请扫描仓位！";
$cguser = getUserNameById($goodsinfo['purchaseId']);
$res['res_info'] = $goodsinfo['goodsName'] . "<br>采购:" . $cguser;
$res['sku'] = $sku;
return $res;
}
}
public function act_export()
{
$checkUser = $_GET['checkUser'];
$sku = $_GET['sku'];
$startdate = $_GET['startdate'];
$enddate = $_GET['enddate'];
if (empty($checkUser) && empty($sku) && empty($startdate) && empty($enddate)) {
echo "请选择导出条件";
exit;
}
if (!empty($checkUser)) {
$where[] = "tallyUserId='{$checkUser}'";
}
if (!empty($sku)) {
$where[] = "sku = '{$sku}'";
}
if (!empty($startdate)) {
$start = strtotime($startdate);
$where[] = "entryTime >{$start}";
}
if (!empty($enddate)) {
$end = strtotime($enddate);
$where[] = "entryTime <{$end}";
}
$where = implode(" AND ", $where);
$where = " where is_delete=0 and entryStatus=0 and " . $where;
$lists = packageCheckModel::selectList($where);
$excel = new ExportDataExcel('browser', "pointKpiExport" . date('Y-m-d') . ".xls");
$excel->initialize();
/** edit by Gary**/
$tharr = array("点货人", "点货时间", "SKU", "数量", "良品数", "上架数", "批次号", '打标时间', '贴标时间', '检测时间', '上架时间', '备注');
$excel->addRow($tharr);
foreach ($lists as $list) {
$user = getUserNameById($list['tallyUserId']);
$time = date('Y-m-d H:i:s', $list['entryTime']);
$sku = $list['sku'];
$num = $list['num'];
$ichibanNums = $list['ichibanNums'];
$shelvesNums = $list['shelvesNums'];
$batchNum = $list['batchNum'];
//新增打标、贴标、检测、上架时间
$printTime = $list['printTime'] ? date('Y-m-d H:i:s', $list['printTime']) : '无';
$pasteTime = getSkuTime(array('type' => 'paste', 'tallyList' => $list['id']));
$checkTime = $list['ichibanTime'] ? date('Y-m-d H:i:s', $list['ichibanTime']) : '无';
$inputArray = array('type' => 'input', 'sku' => $list['sku'], 'finishTime' => $list['finishTime'], 'shelvesNums' => $list['shelvesNums']);
$inputTime = getSkuTime($inputArray);
$tdarr = array($user, $time, $sku, $num, $ichibanNums, $shelvesNums, $batchNum, $printTime, $pasteTime, $checkTime, $inputTime, $list['note']);
/** end**/
$excel->addRow($tdarr);
}
$excel->finalize();
exit;
}
include_once 'app/users.php';
//include_once('../user.php');
if (empty($_SESSION['logged_in'])) {
redirect('index.php');
}
if (isset($_GET['uid'])) {
$user = $_GET['uid'];
} else {
$user = $_SESSION['uid'];
}
$interactions = getInteractions($user);
if ($interactions) {
foreach ($interactions as $i) {
$timestamp = $i['created_on'];
$user = getUserNameById($i['created_by']);
$author = getUserNameById($i['author']);
if ($i['type'] == 'ideathread') {
$title = getIdeaTitle($i['id']);
$url = SITE_URL . '/home.php?iid=' . $i['id'];
}
if ($i['type'] == 'project') {
$title = getProjectTitle($i['id']);
$url = SITE_URL . '/home.php?pid=' . $i['id'];
}
if ($i['action'] == 'like') {
$action = 'liked';
$icon_image = SITE_URL . '/images/icons/like.png';
}
if ($i['action'] == 'comment') {
$action = 'commented on';
$icon_image = SITE_URL . '/images/icons/comment.jpg';
function content_52b9238817e343_27919694($_smarty_tpl)
{
echo $_smarty_tpl->getSubTemplate("header.htm", $_smarty_tpl->cache_id, $_smarty_tpl->compile_id, null, null, array(), 0);
?>
<div class="fourvar">
<div class="pathvar">
您的位置：<a href="index.php?mod=productStockalarm&act=index">预警管理</a> >> <?php
echo $_smarty_tpl->tpl_vars['title']->value;
?>
</div>
<div class="pagination">
<?php
echo $_smarty_tpl->tpl_vars['pageStr']->value;
?>
</div>
</div>
<div class="servar">
<span>关键字：<input id="key" type="text" <?php
if ($_smarty_tpl->tpl_vars['key']->value) {
?>
value="<?php
echo $_smarty_tpl->tpl_vars['key']->value;
?>
" <?php
}
?>
/>
<span>搜索类型：<select id="type">
<option value='-1'>请选择类型</option>
<option value='sku' <?php
if ($_smarty_tpl->tpl_vars['type']->value == "sku") {
?>
selected="selected"<?php
}
?>
>料号子SKU</option>
<option value='spu' selected="selected">主料号</option>
<option value= "goodsName" <?php
if ($_smarty_tpl->tpl_vars['type']->value == "goodsName") {
?>
selected="selected"<?php
}
?>
>产品名称</option>
</select>
</span>
</span>
<span>产品状态：<select id="flag">
<option value='-1'>选择状态</option>
<option value='1' <?php
if ($_smarty_tpl->tpl_vars['status']->value == "1") {
?>
selected<?php
}
?>
>在线</option>
<option value='2' <?php
if ($_smarty_tpl->tpl_vars['status']->value == "2") {
?>
selected<?php
}
?>
>下线</option>
<option value='3' <?php
if ($_smarty_tpl->tpl_vars['status']->value == "3") {
?>
selected<?php
}
?>
>零库存</option>
<option value='4' <?php
if ($_smarty_tpl->tpl_vars['status']->value == "4") {
?>
selected<?php
}
?>
>停售</option>
<option value='5' <?php
if ($_smarty_tpl->tpl_vars['status']->value == "5") {
?>
selected<?php
}
?>
>部分平台在线</option>
</select>
</span>
<span>供应商：<select id="pid">
<option value='-1'>请选择供应商</option>
<?php
$_smarty_tpl->tpl_vars['list'] = new Smarty_Variable();
$_smarty_tpl->tpl_vars['list']->_loop = false;
$_from = $_smarty_tpl->tpl_vars['partnerList']->value;
if (!is_array($_from) && !is_object($_from)) {
settype($_from, 'array');
}
foreach ($_from as $_smarty_tpl->tpl_vars['list']->key => $_smarty_tpl->tpl_vars['list']->value) {
$_smarty_tpl->tpl_vars['list']->_loop = true;
?>
<option value="<?php
echo $_smarty_tpl->tpl_vars['list']->value['id'];
?>
" <?php
if ($_smarty_tpl->tpl_vars['pid']->value == $_smarty_tpl->tpl_vars['list']->value['id']) {
?>
selected="selected"<?php
}
?>
><?php
echo $_smarty_tpl->tpl_vars['list']->value['company_name'];
?>
</option>
<?php
}
?>
</select>
</span>
<span>采购员：
<select id="pcid">
<option value="-1">请选择采购员</option>
<?php
$_smarty_tpl->tpl_vars['list'] = new Smarty_Variable();
$_smarty_tpl->tpl_vars['list']->_loop = false;
$_from = $_smarty_tpl->tpl_vars['purchaseList']->value;
if (!is_array($_from) && !is_object($_from)) {
settype($_from, 'array');
}
foreach ($_from as $_smarty_tpl->tpl_vars['list']->key => $_smarty_tpl->tpl_vars['list']->value) {
$_smarty_tpl->tpl_vars['list']->_loop = true;
?>
<option value="<?php
echo $_smarty_tpl->tpl_vars['list']->value['userId'];
?>
" <?php
if ($_smarty_tpl->tpl_vars['pcid']->value == $_smarty_tpl->tpl_vars['list']->value['userId']) {
?>
selected="selected"<?php
}
?>
><?php
echo $_smarty_tpl->tpl_vars['list']->value["userName"];
?>
</option>
<?php
}
?>
</select>
</span>
<div style="border:2px red ;height:10px;"></div>
<span>
预警状态：
<select id="is_warn">
<option value='-1' <?php
if ($_smarty_tpl->tpl_vars['is_warn']->value == '-1') {
?>
selected<?php
}
?>
>全部货品信息</option>
<option value='1' <?php
if ($_smarty_tpl->tpl_vars['is_warn']->value == '1') {
?>
selected<?php
}
?>
>预警货品信息</option>
</select>
</span>
<span>每天均量排序：
<select id="dailyNum">
<option value='-1' <?php
if ($_GET['dailyNum'] == '-1') {
?>
selected<?php
}
?>
>--请选择顺序排列--</option>
<option value='1' <?php
if ($_GET['dailyNum'] == '1') {
?>
selected<?php
}
?>
>--销量从高到低--</option>
<option value='2' <?php
if ($_GET['dailyNum'] == '2') {
?>
selected<?php
}
?>
>--销量从低到高--</option>
</select>
</span>
<span>已订购筛选：
<select id="bookNum">
<option value='-1' <?php
if ($_GET['bookNum'] == '-1') {
?>
selected<?php
}
?>
>--请选择--</option>
<option value='1' <?php
if ($_GET['bookNum'] == '1') {
?>
selected<?php
}
?>
>已订购</option>
</select>
</span>
<span> <a href="javascript:void(0)" id="search-btn">搜 索</a>
</span>
<span> <a href="javascript:void(0)" id="createPur">生成采购订单</a>
</span>
<span> <a href="javascript:void(0)" id="pl-partner">批量更新供应商</a>
</span>
<span> <a href="javascript:void(0)" id="stop-sale">暂时停售</a></span>
<span> <a href="javascript:void(0)" id="forever-stop-sale">永久停售</a></span>
<span> <a href="javascript:void(0)" id="begin-sale">开始销售</a></span>
</div>
<div class="main products-main reply-main warning-main pagemargin-main">
<table cellspacing="0" width="100%">
<tbody>
<tr class="purchase-title title">
<td>
<input type="checkbox" name="inverse-check" id="inverse-check" />
</td>
<td>image</td>
<td>SKU</td>
<td>SPU</td>
<td>成本</td>
<td>实际库存</td>
<td>待发货</td>
<td>虚拟库存</td>
<td>被拦截</td>
<td>自动拦截</td>
<td>待审核</td>
<td>可用天数</td>
<td>每天均量</td>
<td>预警天数</td>
<td>采购天数</td>
<td>采购数量</td>
<td>已订购</td>
<td>在途数量</td>
<td>建议采购数量</td>
<td>下月预测</td>
<td>重量</td>
<td>在线状态</td>
<td>采购</td>
</tr>
<?php
$_smarty_tpl->tpl_vars['list'] = new Smarty_Variable();
$_smarty_tpl->tpl_vars['list']->_loop = false;
$_from = $_smarty_tpl->tpl_vars['skuInfo']->value;
if (!is_array($_from) && !is_object($_from)) {
settype($_from, 'array');
}
$_smarty_tpl->tpl_vars['smarty']->value['foreach']['foo']['iteration'] = 0;
foreach ($_from as $_smarty_tpl->tpl_vars['list']->key => $_smarty_tpl->tpl_vars['list']->value) {
$_smarty_tpl->tpl_vars['list']->_loop = true;
$_smarty_tpl->tpl_vars['smarty']->value['foreach']['foo']['iteration']++;
?>
<tr <?php
if ($_smarty_tpl->getVariable('smarty')->value['foreach']['foo']['iteration'] % 2 == 0) {
?>
style="background-color:#f2f2f2;"<?php
}
?>
>
<td class="table-line" rowspan="2" style="border-bottom:1px solid #ccc;">
<input type="checkbox" name="inverse" value="<?php
echo $_smarty_tpl->tpl_vars['list']->value['sku'];
?>
" data-rec="<?php
echo ceil($_smarty_tpl->tpl_vars['list']->value['purchaseDays'] * $_smarty_tpl->tpl_vars['list']->value['everyday_sale']);
?>
"/>
</td>
<td rowspan="2" class="table-line" style="border-bottom:1px solid #ccc;">
<a href="javascript:void(0)" id="imgb-<?php
echo $_smarty_tpl->tpl_vars['list']->value['sku'];
?>
" class="fancybox">
<img src="" class="skuimg" id="imgs-<?php
echo $_smarty_tpl->tpl_vars['list']->value['sku'];
?>
" width="60" height="60" data-spu="<?php
echo $_smarty_tpl->tpl_vars['list']->value['spu'];
?>
" data-sku="<?php
echo $_smarty_tpl->tpl_vars['list']->value['sku'];
?>
">
</a>
</td>
<td align="left" class="table-line" >
<a href="javascript:void(0)" class="<?php
if ($_smarty_tpl->tpl_vars['list']->value['is_warning']) {
?>
openwarning<?php
} else {
?>
unwarning<?php
}
?>
"></a>
<span class="font-16"><?php
echo $_smarty_tpl->tpl_vars['list']->value['sku'];
?>
</span>
</td>
<td><span class="font-16"><?php
echo $_smarty_tpl->tpl_vars['list']->value['spu'];
?>
</span></td>
<td class="table-line" >
<?php
echo $_smarty_tpl->tpl_vars['list']->value['goodsCost'];
?>
</td>
<td class="table-line" >
<?php
echo $_smarty_tpl->tpl_vars['list']->value['actualStockCount'];
?>
</td>
<td><?php
echo $_smarty_tpl->tpl_vars['list']->value['waitingSendCount'];
?>
</td>
<td class="table-line" >
<?php
echo $_smarty_tpl->tpl_vars['list']->value['availableStockCount'];
?>
</td>
<td class="table-line" >
<?php
echo $_smarty_tpl->tpl_vars['list']->value['interceptSendCount'];
?>
</td>
<td class="table-line" >
<?php
echo $_smarty_tpl->tpl_vars['list']->value['shortageSendCount'];
?>
</td>
<td class="table-line">
<?php
echo $_smarty_tpl->tpl_vars['list']->value['waitingAuditCount'];
?>
</td>
<td >
<?php
echo $_smarty_tpl->tpl_vars['availableStockCount']->value / $_smarty_tpl->tpl_vars['averageDailyCount']->value;
?>
</td>
<td>
<?php
echo $_smarty_tpl->tpl_vars['list']->value['averageDailyCount'];
?>
</td>
<td><?php
echo $_smarty_tpl->tpl_vars['list']->value['goodsdays'];
?>
</td>
<td><?php
echo $_smarty_tpl->tpl_vars['list']->value['purchasedays'];
?>
</td>
<td><?php
echo $_smarty_tpl->tpl_vars['list']->value['purchasedays'];
?>
</td>
<td><?php
echo checkSkuOnWayNum($_smarty_tpl->tpl_vars['list']->value['sku']);
?>
</td>
<td></td>
<td></td>
<td></td>
<td><?php
echo $_smarty_tpl->tpl_vars['list']->value['goodsWeight'];
?>
</td>
<td><?php
if ($_smarty_tpl->tpl_vars['list']->value['status'] == 1) {
?>
在线<?php
} elseif ($_smarty_tpl->tpl_vars['list']->value['status'] == 2) {
?>
暂时停售<?php
} elseif ($_smarty_tpl->tpl_vars['list']->value['status'] == 3) {
?>
永久性停售<?php
} else {
?>
在线<?php
}
?>
</td>
<td><?php
echo getUserNameById($_smarty_tpl->tpl_vars['list']->value['purchaseId']);
?>
</td>
</tr>
<tr <?php
if ($_smarty_tpl->getVariable('smarty')->value['foreach']['foo']['iteration'] % 2 == 0) {
?>
style="background-color:#f2f2f2;"<?php
}
?>
>
<td colspan="7" style="border-bottom:1px solid #ccc;">
<?php
echo $_smarty_tpl->tpl_vars['list']->value['goodsName'];
?>
</td>
<td colspan="2" style="border-bottom:1px solid #ccc;">
</td>
<?php
$_smarty_tpl->tpl_vars['ptlist'] = new Smarty_variable(CommonModel::getSkuPartner($_smarty_tpl->tpl_vars['list']->value['sku']), null, 0);
?>
<td colspan="7" style="border-bottom:1px solid #ccc;">
</td>
<td style="border-bottom:1px solid #ccc;">
</td>
<td colspan="7" style="border-bottom:1px solid #ccc;">
<?php
$_smarty_tpl->tpl_vars['pt'] = new Smarty_Variable();
$_smarty_tpl->tpl_vars['pt']->_loop = false;
$_from = $_smarty_tpl->tpl_vars['ptlist']->value;
if (!is_array($_from) && !is_object($_from)) {
settype($_from, 'array');
}
foreach ($_from as $_smarty_tpl->tpl_vars['pt']->key => $_smarty_tpl->tpl_vars['pt']->value) {
$_smarty_tpl->tpl_vars['pt']->_loop = true;
echo $_smarty_tpl->tpl_vars['pt']->value['company_name'];
}
?>
</td>
</tr>
<?php
}
?>
</tbody>
</table>
<div>
<div class="bottomvar">
<div class="pagination">
<?php
echo $_smarty_tpl->tpl_vars['pageStr']->value;
?>
</div>
</div>
<input type="hidden" value="<?php
echo $_smarty_tpl->tpl_vars['_userid']->value;
?>
" id="userid" />
<?php
echo $_smarty_tpl->getSubTemplate("footer.htm", $_smarty_tpl->cache_id, $_smarty_tpl->compile_id, null, null, array(), 0);
?>
<script type="text/javascript">
//搜索入口
function search(){
var type,key,pid,pcid,is_warn,flag,url,dailyNum;
url = "index.php?mod=productStockalarm&act=analyze";
key = encodeURIComponent($.trim($("#key").val()));
type = $.trim($("#type").val());
pid = $.trim($("#pid").val());
pcid = $.trim($("#pcid").val());
flag = $.trim($("#flag").val());
is_warn = $.trim($("#is_warn").val());
dailyNum = $.trim($("#dailyNum").val());
bookNum = $.trim($("#bookNum").val());
if(type != -1 && key != ''){
url += "&type="+type+"&key="+key;
}
if(flag != -1){
url += "&status="+flag;
}
if(pid != -1){
url += "&pid="+pid;
}
if(is_warn != -1){
url += "&is_warn="+is_warn;
}
if(pcid !=-1){
url += "&pcid="+pcid;
}
if(dailyNum != -1){
url += "&dailyNum="+dailyNum;
}
if(bookNum != -1){
url += "&bookNum="+bookNum;
}
if(type != -1 && key == ''){
alertify.error("请输入要查找的关键词！");
$("#key").focus();
return false;
}
window.location.href = url;
}
$("#search-btn").click(function() {
search();
});
//全选入口
$("#inverse-check").click(function(){
select_all("inverse-check","input[name='inverse']",0);
});
//生成采购订单
$("#createPur").click(function(){
var skuArr , url,skulist = [];
var skuArr = $('input[name="inverse"]:checked');
if(skuArr.length == 0){
alertify.alert('请选择需下订单的料号');
return false;
}else{
$.each(skuArr ,function(i,item){
var skuObj = {};
skuObj.sku = $(item).val();
skuObj.rec = $(item).data("rec"); //建议采购数量
skulist.push(skuObj);
});
}
var url = "json.php?mod=purchaseOrder&act=createOrder";
$.post(url, {"skulist":skulist}, function(rtn){
console.log(rtn);
var data = rtn.msg;
if(data == 'noPower'){
alertify.alert('您不是采购员,没有权限生成采购订单');
}else if(data == 'success'){
alertify.alert('生成采购订单成功',function(){
window.location.reload();
});
}else{
alertify.alert('生成采购订单失败'+data.msg);
}
},'jsonp');
});
$("#pl-partner").click(function(){
var skulist,partner,url;
skulist = getSkuList();
partnerId = $("#pid").val();
url = "json.php?mod=purchaseOrder&act=updatePartner";
if(skulist.length == 0 || partnerId == -1){
alertify.alert('请选择需要更新供应商的料号 and 供应商。。。');
}else{
$.post(url,{"skulist":skulist,"partnerId":partnerId},function(rtn){
//console.log(rtn);
alertify.alert('批量更新供应商成功。。。',function(){
window.location.reload();
});
});
}
});
//新更新缓存
$("#updateCache").click(function(){
var url = "json.php?mod=productStockalarm&act=updateWarnNew";
var skuArr = $('input[name="inverse"]:checked'), sku = "", tips = "", errmsg = "";
if (skuArr.length == 0) {
alertify.alert('请选择需要更新缓存的料号');
return false;
}
tips = "<span id='label-tips' style='line-height:180%;font-size:14px;'></span>";
alertify.alert(tips);
$("#aOK").hide();
var curid = isok = iserr = 0;
$.each (skuArr,function(i,item) {
sku = $(item).val();
$("#label-tips").html("正在批更新料号缓存,请稍候...<br/>处理期间，请不要关闭或刷新当前页面，谢谢配合！");
$.post (url, {"sku":sku}, function(rtn) {
if (rtn.errCode=='0') {
$("#label-tips").html(rtn.data);
} else {
$("#label-tips").html(rtn.errMsg);
iserr++
}
if (curid==(skuArr.length-1)) {
$("#aOK").show().click(function(){
window.location.reload();
});
}
if (iserr>0) {
errmsg = " 一共失败: "+iserr+" 个料号";
}
$("#label-tips").html($("#label-tips").html()+"<br/>处理进度："+ ((curid+1) +" / "+skuArr.length)+errmsg);
curid++
},'jsonp');
});
});
function getSkuList(){
var skuArr , skulist = [];
var skuArr = $('input[name="inverse"]:checked');
if(skuArr.length != 0){
$.each(skuArr ,function(i,item){
var sku = $(item).val();
skulist.push(sku);
});
}
return skulist;
}
$("#stop-sale").click(function(){//暂时停售
var skuArr = getSkuList();
if(skuArr.length == 0){
alertify.alert('请选择需要暂时停售的料号，这个操作日均量将不会更新');
return;
}
changeSkuStatus(skuArr,2);
});
$("#forever-stop-sale").click(function(){//永久停售
var skuArr = getSkuList();
if(skuArr.length == 0){
alertify.alert('请选择需要永久停售的料号，这个操作日均量将不会更新');
return;
}
changeSkuStatus(skuArr,3);
});
$("#begin-sale").click(function(){//开始上线销售
var skuArr = getSkuList();
if(skuArr.length == 0){
alertify.alert('请选择需要上线销售的料号');
return;
}
changeSkuStatus(skuArr,1);
});
function changeSkuStatus(skuArr,status){ //记录sku 在采购系统中的状态
var url = "json.php?mod=sku&act=changeSkuStatus";
$.post(url,{"skuArr":skuArr,"status":status},function(rtn){
console.log(rtn);
if($.inArray(0,rtn) == -1){
alertify.alert("操作成功。。。。",function(){
window.location.reload();
});
}else{
alertify.alert("操作failed。。。。。",function(){
window.location.reload();
});
}
},"json");
}
window.onkeyup = function(e) {
if(e.keyCode == 13) {
search();
}
}
</script>
<?php
}
if ($participants['sender'] == $_SESSION['uid']) {
$conv_partner = $participants['recipient'];
} else {
$conv_partner = $participants['sender'];
}
$messages = getMessageDetails($_GET['conv']);
?>
<div class="user-name-tops">
<a href ="<?php
echo SITE_URL;
?>
/user.php?uid=<?php
echo $conv_partner;
?>
"> <?php
echo ucwords(getUserNameById($conv_partner));
?>
</a>
</div>
<div class="inboxs-messages">
<?php
foreach ($messages as $message) {
$user = getUserData($message['sender']);
$recipent = $message['recipient'];
if ($user['user_id'] == $_SESSION['uid']) {
$classval = 'router-user-photo';
$alignmessage = 'message-right';
$alignphoto = 'photo-right';
} else {
$classval = 'router-user-photo';
</div>
</div>
</div>
</div>
<div class="col-md-6 col-xs-12">
<div class="panel panel-default">
<div class="panel-heading"><strong class="panel-title">Товар</strong></div>
<div class="panel-body">
<div class="container-fluid">
<div class="row" style="margin-bottom: 1em;">
<div class="col-xs-4">Отправитель:</div>
<div class="col-xs-8"><?php
echo getUserNameById($v->shipper_id);
?>
<a href="<?php
echo $cfg['options']['siteurl'];
?>
/newchat/<?php
echo $v->shipper_id;
?>
/new"><i class="fa fa-envelope"></i></a></div>
</div>
<div class="row" style="margin-bottom: 1em;">
<div class="col-xs-4">Товар:</div>
<div class="col-xs-8"><?php
echo $v->item;
?>
</div>
/**
* 导出料号与箱号关联报表
*/
public function view_exportBoxInfo()
{
require_once WEB_PATH . 'lib/PHPExcel.php';
$objPHPExcel = new PHPExcel();
$objPHPExcel->getProperties()->setCreator("Maarten Balliauw")->setLastModifiedBy("Maarten Balliauw")->setTitle("Office 2007 XLSX Test Document")->setSubject("Office 2007 XLSX Test Document")->setDescription("Test document for Office 2007 XLSX, generated using PHP classes.")->setKeywords("office 2007 openxml php")->setCategory("Test result file");
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('A1', '备货单号Shipment ID');
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('B1', '箱号CTN NO.');
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('C1', '料号SKU');
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('D1', '每箱个数');
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('E1', '优先上架Priority for Putaway');
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('F1', '纸箱长度L(cm)');
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('G1', '纸箱宽度W(cm)');
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('H1', '纸箱高度H(cm)');
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('I1', '体积CBM');
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('J1', '每箱净重N.W(kg)');
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('K1', '每箱毛重G.W(kg)');
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('L1', '中文描述Goods Desc(CN)');
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('M1', '英文描述 Goods Desc');
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('N1', '材质Material');
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('O1', '单价U/P(RMB)');
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('P1', '总价TTL(RMB)');
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('Q1', '单价U/P(USD)');
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('R1', '总价TTL(USD)');
$serOrderSn = isset($_GET['orderSn']) ? $_GET['orderSn'] : '';
$serStatus = isset($_GET['status']) ? $_GET['status'] : '';
$serSku = isset($_GET['sku']) ? $_GET['sku'] : '';
$serStartTime = isset($_GET['startTime']) ? $_GET['startTime'] : '';
$serEndTime = isset($_GET['endTime']) ? $_GET['endTime'] : '';
$condition = '';
if (!empty($serOrderSn)) {
$condition .= " AND a.replenshId = '{$serOrderSn}'";
}
if (!empty($serSku)) {
$condition .= " AND b.sku = '{$serSku}'";
}
if (!empty($serStatus)) {
$condition .= " AND a.status = '{$serStatus}'";
}
if (!empty($serStartTime) && $serEndTime >= $serStartTime) {
$serstart = strpos($serStartTime, ':') !== false ? strtotime($serStartTime) : strtotime($serStartTime . " 00:00:00");
$serend = strpos($serEndTime, ':') !== false ? strtotime($serEndTime) : strtotime($serEndTime . " 23:59:59");
$condition .= " AND a.addtime BETWEEN '{$serstart}' AND '{$serend}'";
}
$boxModel = new BoxManageModel();
$rtnData = $boxModel->getListBoxInfo($condition);
if (!empty($rtnData)) {
$row = 2;
foreach ($rtnData as $k => $v) {
$orderSn = $v['replenshId'];
$boxId = $v['boxid'];
$length = $v['length'];
$width = $v['width'];
$high = $v['high'];
$volume = round($v['volume'] / 1000000, 3);
$grossWeight = $v['grossWeight'];
$netWeight = $v['netWeight'];
$addtime = date('Y-m-d', $v['addtime']);
$status = $v['status'];
$userName = getUserNameById($v['adduser']);
$sku = $v['sku'];
$num = $v['num'];
$skuBase = $boxModel->getSkuBaseInfo($sku);
$skuName = $skuBase['goodsName'];
$skuPrice = $skuBase['goodsCost'];
$totalRmb = $skuPrice * $num;
switch ($status) {
case '1':
$stu = '已配货';
break;
case '2':
$stu = '已复核';
break;
case '3':
$stu = '已装柜';
break;
case '4':
$stu = '海外已收货';
break;
default:
$stu = '';
break;
}
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('A' . $row, $orderSn);
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('B' . $row, $boxId);
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('C' . $row, $sku);
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('D' . $row, $num);
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('E' . $row, '');
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('F' . $row, $length);
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('G' . $row, $width);
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('H' . $row, $high);
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('I' . $row, $volume);
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('J' . $row, $netWeight);
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('K' . $row, $grossWeight);
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('L' . $row, $skuName);
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('M' . $row, '');
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('O' . $row, $skuPrice);
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('P' . $row, $totalRmb);
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('Q' . $row, '');
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('R' . $row, '');
$row++;
}
}
$objPHPExcel->setActiveSheetIndex(0)->getColumnDimension('A')->setWidth(20);
$objPHPExcel->setActiveSheetIndex(0)->getColumnDimension('B')->setWidth(20);
$objPHPExcel->setActiveSheetIndex(0)->getColumnDimension('C')->setWidth(20);
$objPHPExcel->setActiveSheetIndex(0)->getColumnDimension('D')->setWidth(10);
$objPHPExcel->setActiveSheetIndex(0)->getColumnDimension('E')->setWidth(30);
$objPHPExcel->setActiveSheetIndex(0)->getColumnDimension('F')->setWidth(20);
$objPHPExcel->setActiveSheetIndex(0)->getColumnDimension('G')->setWidth(20);
$objPHPExcel->setActiveSheetIndex(0)->getColumnDimension('H')->setWidth(20);
$objPHPExcel->setActiveSheetIndex(0)->getColumnDimension('I')->setWidth(20);
$objPHPExcel->setActiveSheetIndex(0)->getColumnDimension('J')->setWidth(20);
$objPHPExcel->setActiveSheetIndex(0)->getColumnDimension('K')->setWidth(20);
$objPHPExcel->setActiveSheetIndex(0)->getColumnDimension('L')->setWidth(30);
$objPHPExcel->setActiveSheetIndex(0)->getColumnDimension('M')->setWidth(20);
$objPHPExcel->setActiveSheetIndex(0)->getColumnDimension('N')->setWidth(20);
$objPHPExcel->setActiveSheetIndex(0)->getColumnDimension('O')->setWidth(20);
$objPHPExcel->setActiveSheetIndex(0)->getColumnDimension('P')->setWidth(20);
$objPHPExcel->setActiveSheetIndex(0)->getColumnDimension('Q')->setWidth(20);
$objPHPExcel->setActiveSheetIndex(0)->getColumnDimension('R')->setWidth(20);
$title = "装柜清单" . date('Y-m-d');
$titlename = $title . ".xls";
$objPHPExcel->getActiveSheet()->setTitle($title);
$objPHPExcel->setActiveSheetIndex(0);
header('Content-Type: application/vnd.ms-excel');
header("Content-Disposition: attachment;filename={$titlename}");
header('Cache-Control: max-age=0');
$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');
$objWriter->save('php://output');
}
</div>
<?php
}
?>
<div class="col-md-2 col-xs-12">
Чат с <?php
if ($v[0]->from_id == $user['id']) {
$chatwith = $v[0]->to_id;
} else {
$chatwith = $v[0]->from_id;
}
?>
<?php
echo getUserIconById($chatwith);
echo " ";
echo getUserNameById($chatwith);
?>
</div>
<div class="col-md-7 col-xs-12"><?php
echo preg_replace("/[\n|\r|\r\n|\n\r]+/", "<br><br>", $v[0]->text);
?>
</div>
<div class="col-md-2 col-xs-12 text-right"><small class="text-muted"><?php
echo $v[0]->time;
?>
</small></div>
</div>
</a>
<hr style="margin: 0;">
<?php
/**
* WhGoodsAssignAct::export_data()
* 导出调拨数据
* @return void
*/
public function export_data()
{
$ids = trim($_GET['ids']);
if ($ids) {
$assignList = WhGoodsAssignModel::getAssignList(" and a.id in ({$ids})", '', '', 'a.id');
$assign_status = C('assign_status');
//print_r($assign_status);exit;
$name = 'assignList' . date('Y-m-d') . ".xls";
//$name = iconv('UTF-8', 'gb2312//ignore', $name);
$excel = new ExportDataExcel('browser', $name);
$excel->initialize();
$tharr = array("调拨单号", "SKU", "产品名称", "转出仓库", "转入仓库", "需求数量", "配货数量", '出库复核数量', '接收数量', '生成人员', '生成时间', '调拨单状态', '状态变更时间');
$excel->addRow($tharr);
if (!empty($assignList)) {
foreach ($assignList as $assign) {
$outStore = WarehouseManagementModel::warehouseManagementModelList(" where id = {$assign['outStoreId']}");
$outStore = $outStore[0]['whName'];
$inStore = WarehouseManagementModel::warehouseManagementModelList(" where id = {$assign['inStoreId']}");
$inStore = $inStore[0]['whName'];
$maker = getUserNameById($assign['createUid']);
$make_date = date('Y-m-d H:i:s', $assign['createTime']);
$state_date = date('Y-m-d H:i:s', $assign['statusTime']);
$status = $assign_status[$assign['status']];
$details = WhGoodsAssignModel::getsAssignListDetail($assign['id']);
foreach ($details as $k => $val) {
$tdarr = array($k == 0 ? $assign['assignNumber'] : '', $val['sku'], $val['goodsName'], $outStore, $inStore, $val['num'], $val['assignNum'], $val['outCheckNum'], $val['inCheckNum'], $k == 0 ? $maker : '', $k == 0 ? $make_date : '', $k == 0 ? $status : '', $k == 0 ? $state_date : '');
//print_r($tdarr);exit;
$excel->addRow($tdarr);
}
}
}
$excel->finalize();
exit;
}
}
function getEmpathizerUserNameByDbToken($iDbTokenSg)
{
global $wpdb;
$tTableNameSg = getCallRecordTableName();
$tDbTokenColNameSg = DatabaseAttributes::database_token;
$tEmpathizerColumnSg = DatabaseAttributes::empathizer_id;
$tQuerySg = "SELECT {$tEmpathizerColumnSg} FROM {$tTableNameSg} WHERE {$tDbTokenColNameSg}='{$iDbTokenSg}'";
$tCallRecordsItemsMix = $wpdb->get_results($tQuerySg, ARRAY_N);
$userId = $tCallRecordsItemsMix[0][0];
$rEmailSg = getUserNameById($userId);
return $rEmailSg;
}
<?php
foreach ($chat as $v) {
?>
<div class="row <?php
if ($v->is_read == 0) {
echo 'bg-unread';
}
?>
" style="padding:1em;">
<div class="col-md-2 col-xs-12">
<?php
echo getUserIconById($v->from_id);
echo " ";
echo getUserNameById($v->from_id);
?>
</div>
<div class="col-md-7 col-xs-12"><?php
echo preg_replace("/[\n|\r|\r\n|\n\r]+/", "<br><Br>", $v->text);
?>
</div>
<div class="col-md-2 col-xs-12 text-right"><small class="text-muted"><?php
echo $v->time;
?>
</small></div>
</div>
<hr style="margin:0;">
<?php
}
"></ul>
</div>
<div style="width:296px;float:right;margin-left:-5px;">
<ul class="rater-users raterusers-<?php
echo $project['project_id'];
?>
" data-id="<?php
echo $project['project_id'];
?>
">
<!-- --><?php
//$raters = getRatersForProject($project_id);
if ($raters) {
foreach ($raters as $rater) {
echo '<div class="rater-users-list" data-id="' . $rater['rater_id'] . '" user-id="' . $rater['user_id'] . '"><span class="remove-rater" data-id="' . $rater['rater_id'] . '" user-id="' . $rater['user_id'] . '">X</span><a href="' . SITE_URL . '/user.php?uid=' . $rater['user_id'] . '"><li class="rater-name">' . getUserNameById($rater['user_id']) . '</li></a></div>';
}
}
?>
</ul>
<div class="success-message"></div>
</div>
</div> <!-- project-rater-area -->
</td>
<td>
<?php
// $rate = getAdminRatedStatus($project['project_id'], $_SESSION['uid']);
$value = getAdminRateForProject($project['project_id'], $_SESSION['uid']);
if ($project['seed_rating'] == 0) {
$seed = 'N/A';
<input type="text" id="route-search" placeholder="Type Your Router Name"
data-id="<?php
echo $_SESSION['uid'];
?>
"/>
<input type="hidden" id="route-button" value="Search"/>
<ul id="route-result"></ul>
</div>
<div style="width:296px;float:right;margin-left:-20px;cursor: pointer;">
<ul class="routed-users">
<?php
$routers = getRoutersForProject($project['project_id'], $_SESSION['uid']);
if ($routers) {
foreach ($routers as $router) {
echo '<div class="routed-users-list" data-id="' . $router['router_id'] . '" user-id="' . $router['routed_to'] . '"><span class="unroute" data-id="' . $router['router_id'] . '" user-id="' . $router['routed_to'] . '">X</span><a href="' . SITE_URL . '/user.php?uid=' . $router['routed_to'] . '"><li class="routed-name">' . getUserNameById($router['routed_to']) . '</li></a></div>';
}
}
//
?>
</ul>
<div class="success-message"></div>
</div>
<!-- <div class="routers-set">-->
<!-- </div> <!-- routers-set -->
</div> <!-- route-area -->
<!-- report area -->
<div class="report-area">
public function view_getWhIoRecordsList()
{
$type = isset($_GET['type']) ? $_GET['type'] : '';
$status = isset($_GET['status']) ? $_GET['status'] : '';
$ioType = isset($_GET['ioType']) ? $_GET['ioType'] : '';
if (intval($ioType) != 1 && intval($ioType) != 2) {
//1为出库，2为入库
$this->smarty->assign('$toptitle', '出入库记录列表');
$this->smarty->assign('status', '参数错误');
$this->smarty->assign('whIoRecordsList', null);
//循环列表
$this->smarty->display("whIoRecords.htm");
} else {
$ioType = intval($ioType);
$whIoRecordsAct = new WhIoRecordsAct();
$where = "WHERE ioType='{$ioType}' ";
if ($type == 'search') {
$id = isset($_GET['id']) ? post_check($_GET['id']) : '';
$ordersn = isset($_GET['ordersn']) ? post_check($_GET['ordersn']) : '';
$ioTypeId = isset($_GET['ioTypeId']) ? post_check($_GET['ioTypeId']) : '';
$sku = isset($_GET['sku']) ? post_check($_GET['sku']) : '';
$purchaseId = isset($_GET['purchaseId']) ? post_check($_GET['purchaseId']) : '';
$userId = isset($_GET['userId']) ? post_check($_GET['userId']) : '';
$positionId = isset($_GET['position']) ? post_check($_GET['position']) : '';
$cStartTime = isset($_GET['cStartTime']) ? post_check($_GET['cStartTime']) : '';
$cEndTime = isset($_GET['cEndTime']) ? post_check($_GET['cEndTime']) : '';
if (!empty($id)) {
$where .= "AND id='{$id}' ";
}
if (!empty($ordersn)) {
$where .= "AND ordersn='{$ordersn}' ";
}
if (!empty($ioTypeId)) {
$where .= "AND ioTypeId='{$ioTypeId}' ";
}
if (!empty($sku)) {
$where .= "AND sku='{$sku}' ";
}
if (!empty($purchaseId)) {
$purchaseId = getUserIdByName($purchaseId);
$where .= "AND purchaseId='{$purchaseId}' ";
}
if (!empty($userId)) {
$userId = getUserIdByName($userId);
$where .= "AND userId='{$userId}' ";
}
if ($positionId) {
$positionId = WhPositionDistributionModel::get_position_info('id', '', $positionId);
$positionId = empty($positionId) ? '-1' : $positionId[0]['id'];
$where .= "AND positionId = '{$positionId}' ";
}
if (!empty($cStartTime)) {
$startTime = strtotime($cStartTime . '00:00:00');
$where .= "AND createdTime >='{$startTime}' ";
}
if (!empty($cEndTime)) {
$endTime = strtotime($cEndTime . '23:59:59');
$where .= "AND createdTime <='{$endTime}' ";
}
}
$total = $whIoRecordsAct->act_getTNameCount('wh_iorecords', $where);
$num = 100;
//每页显示的个数
$page = new Page($total, $num, '', 'CN');
$where .= "ORDER BY createdTime DESC " . $page->limit;
$whIoRecordsList = $whIoRecordsAct->act_getTNameList('wh_iorecords', '*', $where);
if (!empty($_GET['page'])) {
if (intval($_GET['page']) <= 1 || intval($_GET['page']) > ceil($total / $num)) {
$n = 1;
} else {
$n = (intval($_GET['page']) - 1) * $num + 1;
}
} else {
$n = 1;
}
if ($total > $num) {
//输出分页显示
$show_page = $page->fpage(array(0, 2, 3, 4, 5, 6, 7, 8, 9));
} else {
$show_page = $page->fpage(array(0, 2, 3));
}
$toptitle = '出库记录列表';
$ioSearchName = '出库类型';
$navlist = array(array('url' => 'index.php?mod=skuStock&act=getSkuStockList', 'title' => '库存信息'), array('url' => '', 'title' => '出库记录列表'));
$this->smarty->assign('toplevel', 0);
$this->smarty->assign('secondlevel', '34');
$ioTypeList = WhIoStoreModel::getIoTypeListByioType(0);
if ($ioType == 2) {
$toptitle = '入库记录列表';
$ioSearchName = '入库类型';
$this->smarty->assign('secondlevel', 35);
$navlist = array(array('url' => 'index.php?mod=skuStock&act=getSkuStockList', 'title' => '库存信息'), array('url' => '', 'title' => '入库记录列表'));
$ioTypeList = WhIoStoreModel::getIoTypeListByioType(1);
}
$this->smarty->assign('toptitle', $toptitle);
$this->smarty->assign('ioSearchName', $ioSearchName);
$this->smarty->assign('ioTypeList', $ioTypeList);
$this->smarty->assign('navlist', $navlist);
$this->smarty->assign('show_page', $show_page);
$this->smarty->assign('status', $status);
$usermodel = UserModel::getInstance();
foreach ($whIoRecordsList as $key => $val) {
$whIoRecordsList[$key]['ioTypeName'] = WhIoStoreModel::getIoTypeNameById($val['ioTypeId']);
$whIoRecordsList[$key]['whName'] = WhIoStoreModel::getWhNameById($val['storeId']);
$purchase_user_info = $usermodel->getGlobalUserLists('global_user_name', "where a.global_user_id='{$val['purchaseId']}'", '', 'limit 1');
$whIoRecordsList[$key]['purchaseName'] = $purchase_user_info[0]['global_user_name'];
//$user_info = $usermodel->getGlobalUserLists('global_user_name',"where a.global_user_id='{$val['userId']}'",'','limit 1');
//$whIoRecordsList[$key]['userName'] = $user_info[0]['global_user_name'];
$whIoRecordsList[$key]['userName'] = getUserNameById($val['userId']);
$position_info = whShelfModel::selectPosition("where id={$val['positionId']}");
$whIoRecordsList[$key]['pName'] = $position_info[0]['pName'];
}
$this->smarty->assign('whIoRecordsList', $whIoRecordsList ? $whIoRecordsList : null);
//循环列表
$this->smarty->display("whIoRecords.htm");
}
}
<?php
// тут все фотки и лейблы
if ($user['rankname'] == 'admin') {
?>
<div class="panel panel-default">
<div class="panel-heading"><strong class="panel-title">Загрузки</strong></div>
<div class="panel-body">
<?php
$qUploads = $db->query("SELECT * FROM `uploads` WHERE `pkg_id` = " . $v->id . " ORDER BY `time` DESC");
if (isset($qUploads[0])) {
foreach ($qUploads as $vUploads) {
?>
<div class="row" style="margin-bottom: 1em;">
<div class="col-xs-4"><?php
echo getUserNameById($vUploads->user_id);
?>
</div>
<div class="col-xs-8">
<?php
if (preg_match("/\\.pdf\$/is", $vUploads->filename)) {
echo "<a href='" . $cfg['options']['siteurl'] . '/upload/' . $vUploads->filename . "'>PDF файл</a><br>";
} else {
echo "<img src='" . $cfg['options']['siteurl'] . '/upload/' . $vUploads->filename . "' height=120>" . "<br>";
}
echo $vUploads->time;
?>
</div>
</div>
<hr>
function content_53185b7c9df157_47226703($_smarty_tpl)
{
if (!is_callable('smarty_modifier_date_format')) {
include 'E:\\erpNew\\wh.valsun.cn\\lib\\template\\smarty\\plugins\\modifier.date_format.php';
}
echo $_smarty_tpl->getSubTemplate("header.htm", $_smarty_tpl->cache_id, $_smarty_tpl->compile_id, null, null, array(), 0);
?>
<?php
echo $_smarty_tpl->getSubTemplate('whNav.htm', $_smarty_tpl->cache_id, $_smarty_tpl->compile_id, null, null, array(), 0);
?>
<script type="text/javascript" src="./js/whIoStore.js"></script>
<script type="text/javascript" src="./js/fancybox.js"></script>
<script type="text/javascript" src="./js/My97DatePicker/WdatePicker.js"></script>
<div class="servar wh-servar">
<span>
<input id="ioType" type="hidden" value="<?php
echo $_smarty_tpl->tpl_vars['ioType']->value;
?>
"/>
<!-- TODO: <input id="userId" type="hidden" value="<?php
echo $_SESSION['userId'];
?>
"/> -->
<label for="ordersn">单据编码:</label>
<input name="ordersn" id="ordersn" value="<?php
echo $_smarty_tpl->tpl_vars['g_ordersn']->value;
?>
"/>
|
<label for="ioStatus">状态:</label>
<select name="ioStatus" id="ioStatus">
<option value='1' <?php
if ($_GET['iostatus'] == 1) {
?>
selected="selected"<?php
}
?>
>待审核</option>
<option value='2' <?php
if ($_GET['iostatus'] == 2) {
?>
selected="selected"<?php
}
?>
>审核通过</option>
<option value='3' <?php
if ($_GET['iostatus'] == 3) {
?>
selected="selected"<?php
}
?>
>审核不通过</option>
</select>
|
<label for="invoiceTypeId"><?php
echo $_smarty_tpl->tpl_vars['ioSearchName']->value;
?>
：</label>
<select name="invoiceTypeId" id="invoiceTypeId">
<option value='0' <?php
if ($_GET['select'] == 0) {
?>
selected="selected"<?php
}
?>
>请选择</option>
<?php
$_smarty_tpl->tpl_vars['value'] = new Smarty_Variable();
$_smarty_tpl->tpl_vars['value']->_loop = false;
$_from = $_smarty_tpl->tpl_vars['invoiceTypeList']->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;
?>
<option value='<?php
echo $_smarty_tpl->tpl_vars['value']->value['id'];
?>
' <?php
if ($_GET['invoicetypeid'] == $_smarty_tpl->tpl_vars['value']->value['id']) {
?>
selected="selected"<?php
}
?>
><?php
echo $_smarty_tpl->tpl_vars['value']->value['invoiceName'];
?>
</option>
<?php
}
?>
</select>
|
<label for="cStartTime">创建时间：</label>
<input onclick="WdatePicker()" id='cStartTime' name="cStartTime" value='<?php
echo $_smarty_tpl->tpl_vars['g_cStartTime']->value;
?>
'/>
至
<input onclick="WdatePicker()" id='cEndTime' name="cEndTime" value='<?php
echo $_smarty_tpl->tpl_vars['g_cEndTime']->value;
?>
' />
|
<button id="search">搜索</button>
</span>
<span style="color: red;"><?php
echo $_smarty_tpl->tpl_vars['status']->value;
?>
</span>
</div>
<div class="align-main main order-main products-main">
<?php
$_smarty_tpl->tpl_vars['InStoreList'] = new Smarty_Variable();
$_smarty_tpl->tpl_vars['InStoreList']->_loop = false;
$_from = $_smarty_tpl->tpl_vars['InStoreLists']->value;
if (!is_array($_from) && !is_object($_from)) {
settype($_from, 'array');
}
foreach ($_from as $_smarty_tpl->tpl_vars['InStoreList']->key => $_smarty_tpl->tpl_vars['InStoreList']->value) {
$_smarty_tpl->tpl_vars['InStoreList']->_loop = true;
?>
<table cellspacing="0" width="100%" class="products-action">
<tr class="title">
<td colspan="5">
<span>单号:<?php
echo $_smarty_tpl->tpl_vars['InStoreList']->value['ordersn'];
?>
</span>
<span>类型:<?php
echo $_smarty_tpl->tpl_vars['InStoreList']->value['invoiceName'];
?>
</span>
<span>申请人:<?php
echo getUserNameById($_smarty_tpl->tpl_vars['InStoreList']->value['userId']);
?>
</span>
<span>状态:<?php
if ($_smarty_tpl->tpl_vars['InStoreList']->value['ioStatus'] == 1) {
?>
待审核<?php
}
if ($_smarty_tpl->tpl_vars['InStoreList']->value['ioStatus'] == 2) {
?>
审核通过<?php
}
if ($_smarty_tpl->tpl_vars['InStoreList']->value['ioStatus'] == 3) {
?>
审核不通过<?php
}
?>
</span>
<span>提交时间:<?php
echo smarty_modifier_date_format($_smarty_tpl->tpl_vars['InStoreList']->value['createdTime'], "Y-m-d H:i");
?>
</span>
<span>付款方式:<?php
echo $_smarty_tpl->tpl_vars['InStoreList']->value['paymentMethods'];
?>
</span>
<span>仓库:<?php
echo $_smarty_tpl->tpl_vars['InStoreList']->value['whName'];
?>
</span>
<span>备注:<?php
echo $_smarty_tpl->tpl_vars['InStoreList']->value['note'];
?>
</span>
</td>
</tr>
<?php
$_smarty_tpl->tpl_vars['detailList'] = new Smarty_Variable();
$_smarty_tpl->tpl_vars['detailList']->_loop = false;
$_from = $_smarty_tpl->tpl_vars['InStoreList']->value['detail'];
if (!is_array($_from) && !is_object($_from)) {
settype($_from, 'array');
}
foreach ($_from as $_smarty_tpl->tpl_vars['detailList']->key => $_smarty_tpl->tpl_vars['detailList']->value) {
$_smarty_tpl->tpl_vars['detailList']->_loop = true;
?>
<tr>
<td style="width:100px;" class="unpicurl">
<a href="javascript:void(0)" id="imga-<?php
echo $_smarty_tpl->tpl_vars['detailList']->value['sku'];
?>
" class="fancybox">
<img src="./images/ajax-loader.gif" name="skuimg" width="50" height="50" id="imgs-<?php
echo $_smarty_tpl->tpl_vars['detailList']->value['sku'];
?>
" spu="<?php
echo $_smarty_tpl->tpl_vars['detailList']->value['spu'];
?>
">
</a>
</td>
<td width="30%"><?php
echo getSKUName($_smarty_tpl->tpl_vars['detailList']->value['sku']);
?>
</td>
<td><?php
echo $_smarty_tpl->tpl_vars['detailList']->value['sku'];
?>
</td>
<td>数量:<?php
echo $_smarty_tpl->tpl_vars['detailList']->value['amount'];
?>
</td>
<td>单价:<?php
echo $_smarty_tpl->tpl_vars['detailList']->value['cost'];
?>
</td>
</tr>
<?php
}
if (!$_smarty_tpl->tpl_vars['detailList']->_loop) {
?>
<tr>
<td colspan="5" style="width:100px;">
无SKU数据
</td>
</tr>
<?php
}
?>
<tr>
<td colspan="5">
<table>
<tr>
<?php
$_smarty_tpl->tpl_vars['auditlist'] = new Smarty_Variable();
$_smarty_tpl->tpl_vars['auditlist']->_loop = false;
$_from = $_smarty_tpl->tpl_vars['InStoreList']->value['auditlist'];
if (!is_array($_from) && !is_object($_from)) {
settype($_from, 'array');
}
foreach ($_from as $_smarty_tpl->tpl_vars['auditlist']->key => $_smarty_tpl->tpl_vars['auditlist']->value) {
$_smarty_tpl->tpl_vars['auditlist']->_loop = true;
?>
<?php
if ($_smarty_tpl->tpl_vars['auditlist']->value['auditinfo']) {
?>
<td valign="middle" class="<?php
if ($_smarty_tpl->tpl_vars['auditlist']->value['auditinfo']['auditStatus'] == 1) {
?>
font-pass<?php
}
if ($_smarty_tpl->tpl_vars['auditlist']->value['auditinfo']['auditStatus'] == 2) {
?>
font-red<?php
}
?>
"><?php
echo getUserNameById($_smarty_tpl->tpl_vars['auditlist']->value['auditinfo']['auditUser']);
?>
</td>
<td class="pass" style="width:120px;padding-bottom:40px;" valign="middle" align="center">
<?php
echo smarty_modifier_date_format($_smarty_tpl->tpl_vars['auditlist']->value['auditinfo']['auditTime'], "Y-m-d H:i");
?>
</td>
<?php
if ($_smarty_tpl->tpl_vars['auditlist']->value['auditinfo']['auditStatus'] == 2) {
?>
<td valign="middle" class="unpassendding"></td>
<?php
break 1;
?>
<?php
}
?>
<?php
} else {
?>
<td valign="middle">
<ul>
<?php
$_smarty_tpl->tpl_vars['audituserlist'] = new Smarty_Variable();
$_smarty_tpl->tpl_vars['audituserlist']->_loop = false;
$_from = $_smarty_tpl->tpl_vars['auditlist']->value['audituserlist'];
if (!is_array($_from) && !is_object($_from)) {
settype($_from, 'array');
}
foreach ($_from as $_smarty_tpl->tpl_vars['audituserlist']->key => $_smarty_tpl->tpl_vars['audituserlist']->value) {
$_smarty_tpl->tpl_vars['audituserlist']->_loop = true;
?>
<li class="font-unpass" ><?php
echo getUserNameById($_smarty_tpl->tpl_vars['audituserlist']->value['auditorId']);
?>
</li>
<?php
}
?>
</ul>
</td>
<td class="unpass" style="width:120px;padding-bottom:37px;" valign="middle" align="center">
<?php
}
?>
<?php
}
?>
</td>
<?php
if ($_smarty_tpl->tpl_vars['InStoreList']->value['ioStatus'] == 2) {
?>
<td valign="middle" class="passendding">
<?php
}
?>
</td>
</tr>
</table>
</td>
</tr>
</table>
<?php
}
if (!$_smarty_tpl->tpl_vars['InStoreList']->_loop) {
?>
<div align="center">无数据</div>
<?php
}
?>
</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() {
var url = "json.php?mod=common&act=getSkuImg";
var skuArr = $('img[name="skuimg"]'), imgurl="", spu="", sku="";
$.each(skuArr,function(i,item){
sku = $(item).attr('id').substring(5);
spu = $(item).attr('spu');
$.ajax({
url: url,
type: "POST",
async: true,
data : {spu:spu,sku:sku},
dataType: "jsonp",
success: function(rtn){
sku = $(item).attr('id').substring(5);
//console.log(rtn);
if ($.trim(rtn.data)) {
$("#imgs-"+sku).attr({"src":rtn.data,"width":"60px","height":"60px"});
$("#imga-"+sku).attr("href",rtn.data);
} else {
$("#imgs-"+sku).attr({"src":"./images/no_image.gif","width":"60px","height":"60px"});
$("#imga-"+sku).attr("href","./images/no_image.gif");
}
}
});
});
});
</script><?php
}
public function view_invList()
{
$now_time = date("Y-m-d H:i:s", time());
$state = isset($_GET['state']) ? post_check($_GET['state']) : '';
$this->smarty->assign('state', $state);
$reason = array();
$invPeople = isset($_GET['invPeople']) ? $_GET['invPeople'] : '';
$sku = isset($_GET['sku']) ? post_check($_GET['sku']) : '';
$invType = isset($_GET['invType']) ? $_GET['invType'] : '';
$auditStatus = isset($_GET['auditStatus']) ? $_GET['auditStatus'] : 3;
$startdate = isset($_GET['startdate']) ? post_check($_GET['startdate']) : '';
$enddate = isset($_GET['enddate']) ? post_check($_GET['enddate']) : '';
$InventoryAct = new InventoryAct();
$where = 'where storeId=1 ';
if ($invPeople) {
$where .= "and invPeople ='{$invPeople}' ";
$this->smarty->assign('invPeople', $invPeople);
}
if ($sku) {
$where .= "and sku ='{$sku}' ";
$this->smarty->assign('sku', $sku);
}
if ($invType) {
$where .= "and invType ='{$invType}' ";
$this->smarty->assign('invType', $invType);
}
if ($auditStatus != 3) {
$where .= "and auditStatus ='{$auditStatus}' ";
}
$this->smarty->assign('auditStatus', $auditStatus);
if ($startdate) {
$starttime = strtotime($startdate);
$where .= "and invTime >='{$starttime}' ";
} else {
$startdate = $now_time;
}
$this->smarty->assign('startdate', $startdate);
if ($enddate) {
$endtime = strtotime($enddate);
$where .= "and invTime <='{$endtime}' ";
} else {
$enddate = $now_time;
}
$this->smarty->assign('enddate', $enddate);
$total = $InventoryAct->act_getInvNum($where);
$num = 80;
//每页显示的个数
$page = new Page($total, $num, '', 'CN');
$where .= "order by sku, id " . $page->limit;
$inventory_info = $InventoryAct->act_getInvRecordList('*', $where);
if (!empty($_GET['page'])) {
if (intval($_GET['page']) <= 1 || intval($_GET['page']) > ceil($total / $num)) {
$n = 1;
} else {
$n = (intval($_GET['page']) - 1) * $num + 1;
}
} else {
$n = 1;
}
if ($total > $num) {
//输出分页显示
$show_page = $page->fpage(array(0, 2, 3, 4, 5, 6, 7, 8, 9));
} else {
$show_page = $page->fpage(array(0, 2, 3));
}
$this->smarty->assign('show_page', $show_page);
//盘点原因
if (!empty($inventory_info)) {
foreach ($inventory_info as $key => $info) {
$reason_info = InvReasonModel::getInvReasonList("reasonName", "where id='{$info['reasonId']}'");
$reason[$info['id']] = $reason_info[0]['reasonName'];
$sku_info = getSkuInfoBySku($info['sku']);
$inventory_info[$key]['goodsCost'] = $sku_info['goodsCost'];
$inventory_info[$key]['purchaseName'] = $sku_info['purchaseId'] ? getUserNameById($sku_info['purchaseId']) : '无';
$inventory_info[$key]['remark'] = $info['remark'] ? $info['remark'] : '';
//新增等待上架数量 add by Gary
$tallyList = OmAvailableModel::getTNameList('wh_tallying_list', 'sum(ichibanNums) ichibanNums, sum(shelvesNums) shelvesNums', "where sku='{$info['sku']}' and tallyStatus=0 and is_delete = 0");
$ichibanNums = intval($tallyList[0]['ichibanNums']);
$shelvesNums = intval($tallyList[0]['shelvesNums']);
$inventory_info[$key]['wait_whself'] = $ichibanNums - $shelvesNums;
}
}
$usermodel = UserModel::getInstance();
//盘点员
$iqc_user = $usermodel->getGlobalUserLists('global_user_id,global_user_name', "where a.global_user_job in(162,165)", '', '');
$this->smarty->assign('iqc_user', $iqc_user);
$this->smarty->assign('inventory_info', $inventory_info ? $inventory_info : array());
$this->smarty->assign('reason', $reason);
$navlist = array(array('url' => 'index.php?mod=skuStock&act=getSkuStockList', 'title' => '仓库'), array('url' => 'index.php?mod=inventory&act=inventory', 'title' => '盘点管理'), array('url' => 'index.php?mod=inventory&act=invList', 'title' => '盘点列表'));
$toplevel = 0;
//一级菜单的序号 0 开始
$this->smarty->assign('toplevel', $toplevel);
$secondlevel = 04;
//当前的二级菜单
$this->smarty->assign('secondlevel', $secondlevel);
$this->smarty->assign('navlist', $navlist);
$this->smarty->assign('toptitle', '盘点列表');
$this->smarty->assign('curusername', $_SESSION['userName']);
$this->smarty->display('inventoryInfo.htm');
}
function showJoinApprove()
{
$leader_id = $_SESSION["user_id"];
$leader_name = getUserNameById($leader_id);
try {
$pdo = new PDO("mysql:host=" . DBHOST . "; port=" . DBPORT . "; dbname=" . DBNAME, DBUSER, DBPASS);
//$pdo = new PDO("mysql:host=localhost; dbname=pray","pray", "pray");
$smt = $pdo->prepare("SELECT * FROM waitForJoinGroup, groups WHERE groups.leader_id={$leader_id} AND groups.group_id=waitForJoinGroup.group_id");
if (!$smt->execute()) {
print_r($smt->errorInfo());
}
// 取第一个记录进行处理
if ($row = $smt->fetch()) {
$user_id = $row["user_id"];
$group_id = $row["group_id"];
$user_name = getUserNameById($user_id);
$group_name = $row["name"];
$output = <<<HERE
<header class="fixedHeader">
<div class="headerLeftButton">
<a href="groupList.php"><img border="0" src="images\\backButton.jpg" width="30" height="30"></a>
</div>
<div class="headerTitle">
join request
</div>
</header>
<section class="sectionWithFooter">
<br/>
<h1><mark>{$user_name}</mark> want to join group <mark>{$group_name}</mark>, do you accept?</h1>
<form method="post">
<input type="hidden" name="user_id" value={$user_id}/>
<input type="hidden" name="group_id" value={$group_id}/>
<button class="largeButton" name="isAccept" value=1>accept</button><br/>
<button class="mediumButton" name="isAccept" value=0>reject</button>
</form>
</section>
<footer class="fixedFooter">
<div class="footerTitle">user: {$leader_name}</div>
</footer>
HERE;
print $output;
}
} catch (Exception $ex) {
echo 'ERROR: ' . $ex->getMessage();
}
}
function setNotificationDeatils($friends, $msg)
{
if (isset($_SESSION['user_id'])) {
$user_id = $_SESSION['user_id'];
} else {
$user_id = 0;
}
$userdetails = getUserNameById($user_id);
$conn = getDBConnection();
try {
$notify = mysql_query("select * from users where id in ({$friends})", $conn);
if (mysql_num_rows($notify) > 0) {
while ($row = mysql_fetch_array($notify)) {
$to = $row['push_notify_id'];
//registration ID of the device
$title = $userdetails[0];
$message = $msg;
$this->sendPushNotification($to, $title, $message);
}
}
closeDBConnection($conn);
} catch (Exception $ex) {
echo $ex->getMessage();
}
}
public function act_export()
{
$checkUser = $_GET['checkUser'];
$status = $_GET['status'];
$sku = $_GET['sku'];
$startdate = $_GET['startdate'];
$enddate = $_GET['enddate'];
if (empty($checkUser) && empty($status) && empty($sku) && empty($startdate) && empty($enddate)) {
echo "请选择导出条件";
exit;
}
if (!empty($checkUser)) {
$where[] = "a.labelUserId='{$checkUser}'";
}
if (!empty($status)) {
if ($status == 1) {
$where[] = "a.labelUserId is NULL";
}
if ($status == 2) {
$where[] = "a.labelUserId is not NULL";
}
}
if (!empty($sku)) {
$where[] = "b.sku = '{$sku}'";
}
if (!empty($startdate)) {
$start = strtotime($startdate);
$where[] = "a.labelTime >={$start}";
}
if (!empty($enddate)) {
$end = strtotime($enddate);
$where[] = "a.labelTime <={$end}";
}
$where = implode(" AND ", $where);
$where = " where a.is_delete=0 and a.status=1 and " . $where . " order by a.id desc";
$lists = PasteLabelModel::selectList($where);
$excel = new ExportDataExcel('browser', "labelKpiExport" . date('Y-m-d') . ".xls");
$excel->initialize();
$tharr = array("贴标人", "贴标时间", "SKU", "数量", "分组号", "批次号");
$excel->addRow($tharr);
foreach ($lists as $list) {
if (!empty($list['labelUserId'])) {
$user = getUserNameById($list['labelUserId']);
$time = date('Y-m-d H:i:s', $list['labelTime']);
} else {
$user = '';
$time = '';
}
$sku = $list['sku'];
$num = $list['labelNum'];
$id = $list['id'];
$batchNum = $list['batchNum'];
$tdarr = array($user, $time, $sku, $num, $id, $batchNum);
$excel->addRow($tdarr);
}
$excel->finalize();
exit;
}
function declineRoute($routed_by, $user_id, $notify_id)
{
global $db_con;
$q = 'DELETE FROM `routers` WHERE `user_id` = ' . $user_id . ' AND `routed_by` = ' . $routed_by;
$db_con->query($q);
$q = 'DELETE FROM `notifications` WHERE `notify_id` = ' . $notify_id;
$db_con->query($q);
$author = getUserNameById($user_id);
$text = $author . ' declined your route';
addNotification($routed_by, $text, $user_id);
}
/**
* 获取海外料号新品迁移记录信息返回更新到旧ERP系统海外采购人
*/
public static function getOverSkuMoveLogInfo($page, $pagenum)
{
self::initDB();
$rtnData = array();
$rtnInfo = array();
$start = ($page - 1) * 200;
$pagenum = 200;
$sql = "SELECT * FROM ow_new_sku_move ";
$sql .= "limit {$start}, {$pagenum} ";
$query = self::$dbConn->query($sql);
$data = self::$dbConn->fetch_array_all($query);
if (!empty($data)) {
$rtnData = $data;
$mark = 0;
foreach ($rtnData as $k => $v) {
$sku = $v['sku'];
$purId = $v['cguserId'];
$cguser = getUserNameById($purId);
$rtnInfo[$mark]['sku'] = $sku;
$rtnInfo[$mark]['cguser'] = $cguser;
$mark++;
$upd = "UPDATE pc_goods SET OverSeaSkuCharger = '{$purId}' WHERE sku = '{$sku}'";
self::$dbConn->query($upd);
}
}
return $rtnInfo;
}
* 日期：2014/01/16
* 作者：管拥军
* add cxy
* data 2014-8-20
*/
error_reporting(-1);
set_time_limit(0);
require_once WEB_PATH . "framework.php";
//Core::getInstance();
global $dbConn;
$userId = $_SESSION['userId'];
if (empty($userId)) {
exit("{\"errCode\":\"-1\",\"errMsg\":\"登录超时\"}");
}
############### 基础信息配置 ######################
$truename = getUserNameById($userId);
//echo $truename;exit;
$orderid_arr = isset($_POST['ids']) ? trim($_POST['ids']) : '';
//print_r($orderid_arr);exit;
if (empty($orderid_arr)) {
exit('{"errCode":"-1","errMsg":"没有选择需要导出的订单信息！"}');
}
$accouts = "'360beauty','365digital','befashion','befdi','befdimall','bestinthebox','betterdeals255','cafase88','charmday88','choiceroad','cndirect55','cndirect998','dealinthebox','digitalzone88','doeon','dresslink','easebon','easydeal365','easydealhere','easyshopping678','easytrade2099','elerose88','enicer','enjoy24hours','eshop2098','freemart21cn','futurestar99','happydeal88','ishop2099','itshotsale77','keyhere','niceforu365','niceinthebox','starangle88','sunwebhome','sunwebzone','tradekoo','voguebase55','wellchange','work4best','zealdora'";
$country = "United States";
//$author = array('vipchen','guanyongjun','孙学轩','陈前');
$today = date('Y-m-d', time());
$stime = strtotime($today . "-1 day 00:00:01");
$etime = strtotime($today . " 23:59:59");
//$condition = "1 AND ebay_id IN({$orderids}) AND ebay_carrier='UPS美国专线' ";
//$filename = "ship_ups_us_".$truename."_".$today."_".time().".xml";
//$shipxml = WEB_PATH."/html/temp/".$filename;
function getLinkToUserProfile($id)
{
global $user, $cfg;
if ($user['rankname'] != 'admin' && $user['rankname'] != 'support' && $user['rankname'] != 'labler') {
$out = getFullUserNameById($id);
} else {
if (getRankNameByUserId($id) == 'drop') {
$note = getUserNote($id);
$out = '<a href="' . $cfg['options']['siteurl'] . '/userInfo/' . $id . '" data-title="' . $note . '" data-toggle="tooltip" data-placement="top">' . colorText(getFullUserNameById($id), getUserColor($id)) . '</a>';
} else {
$note = getUserNote($id);
$out = '<a href="' . $cfg['options']['siteurl'] . '/userInfo/' . $id . '" data-title="' . $note . '" data-toggle="tooltip" data-placement="top">' . colorText(getUserNameById($id), getUserColor($id)) . '</a>';
}
}
return $out;
}
?>
<form action="" method="post">
<div class="form-item no-height"><textarea name="footnote" id="footnote"
maxlength="111"></textarea> <input
type="submit" name="add_foonote" value="Add"></div>
<input type="hidden" name="investor_id" value="<?php
echo $investor['investor_id'];
?>
">
</form>
<?php
}
$footnotes = getFootnotesForInvestor($investor['investor_id']);
if ($footnotes) {
foreach ($footnotes as $ix => $notes) {
echo '<a href="' . SITE_URL . '/user.php?uid=' . $notes['created_by'] . '"><p>' . getUserNameById($notes['created_by']) . '</a>' . ' : ' . $notes['text'] . '</p>';
}
}
?>
</div> <!-- footnote content-block -->
</div> <!-- main-content -->
</div> <!-- account inner-page content -->
<?php
include DIR_INCLUDE . 'right_side.php';
?>
/**
* whGoodsAssignView::view_editAssignList()
* 调拨单修改界面
* @return void
*/
public function view_editAssignList()
{
self::bulidNav('修改调拨单', '修改调拨单', 51);
$id = intval(trim($_GET['id'])) ? intval(trim($_GET['id'])) : 0;
if ($id) {
$where = 'where status = 1';
$storeLists = WarehouseManagementModel::warehouseManagementModelList($where);
//获取可用仓库列表
$data = WhGoodsAssignModel::getAssignList(" and a.id={$id}", '', '', 'a.id');
if (!empty($data)) {
$res = $data[0];
$detail = WhGoodsAssignModel::getsAssignListDetail($id);
//调拨单明细
$this->smarty->assign('detail', $detail);
$this->smarty->assign('res', $res);
$createUser = getUserNameById($res['createUid']);
$this->smarty->assign('createUser', $createUser);
//$user = array('name'=>$userName, 'uid'=>$_SESSION['userId']);
$this->smarty->assign('storeLists', $storeLists);
$this->smarty->display('editAssignList.htm');
}
//$userName = getUserNameById($_SESSION['userId']); //获取用户名
}
}
public function act_export()
{
$invPeople = isset($_GET['invPeople']) ? $_GET['invPeople'] : '';
$sku = isset($_GET['sku']) ? post_check($_GET['sku']) : '';
$invType = isset($_GET['invType']) ? $_GET['invType'] : '';
$startdate = isset($_GET['startdate']) ? post_check($_GET['startdate']) : '';
$enddate = isset($_GET['enddate']) ? post_check($_GET['enddate']) : '';
$auditStatus = isset($_GET['auditStatus']) ? post_check($_GET['auditStatus']) : '';
if (empty($invPeople) && empty($sku) && empty($invType) && empty($startdate) && empty($enddate) && empty($auditStatus)) {
echo "请选择导出条件";
exit;
}
$where = 'where storeId=1 ';
if ($invPeople) {
$where .= "and invPeople ='{$invPeople}' ";
}
if ($sku) {
$where .= "and sku ='{$sku}' ";
}
if ($invType) {
$where .= "and invType ='{$invType}' ";
}
if ($startdate) {
$starttime = strtotime($startdate);
$where .= "and invTime >='{$starttime}' ";
}
if ($enddate) {
$endtime = strtotime($enddate);
$where .= "and invTime <='{$endtime}' ";
}
if ($auditStatus != '' && $auditStatus != 3) {
$where .= "and auditStatus = {$auditStatus}";
}
$lists = InvRecordModel::getInvRecordList('*', $where);
$excel = new ExportDataExcel('browser', "Files_warehouse" . date('Y-m-d') . ".xls");
$excel->initialize();
$tharr = array("日期", "料号", "仓位", "系统数量", "盘点数量", "差异数量", "料号单价", "类型", "盘点原因", "盘点人", "采购员", "物料管理人", "状态", '备注信息');
$excel->addRow($tharr);
foreach ($lists as $list) {
$time = date('Y-m-d', $list['invTime']);
$sku = $list['sku'];
$location = $list['location'];
$systemNums = $list['systemNums'];
$sku_info = getSkuInfoBySku($list['sku']);
$goodsCost = $sku_info['goodsCost'];
$invNums = $list['invNums'];
if ($list['invType'] == 1) {
$num = $list['adjustNums'];
$type = "盘盈";
} elseif ($list['invType'] == 2) {
$num = '-' . $list['adjustNums'];
$type = "盘亏";
} else {
$num = $list['adjustNums'];
$type = "";
}
$remark = $list['remark'] ? $list['remark'] : '';
$reason_info = InvReasonModel::getInvReasonList("reasonName", "where id='{$list['reasonId']}'");
$reason = $reason_info[0]['reasonName'];
$invPeople = getUserNameById($list['invPeople']);
//$sku_info = getSkuInfoBySku($list['sku']);
$purchaseName = $sku_info['purchaseId'] ? getUserNameById($sku_info['purchaseId']) : '无';
$menergeMan = '';
$mark = '';
if ($list['auditStatus'] == 0) {
$mark = '未审核';
} else {
if ($list['auditStatus'] == 1) {
$mark = '通过';
} else {
if ($list['auditStatus'] == 2) {
$mark = '拒绝';
}
}
}
$tdarr = array($time, $sku, $location, $systemNums, $invNums, $num, $goodsCost, $type, $reason, $invPeople, $purchaseName, $menergeMan, $mark, $remark);
$excel->addRow($tdarr);
}
$excel->finalize();
exit;
}
public function outStock($sku, $num, $opuser, $orderid, &$isEnd, $waitScan, $orderSn)
{
$isLastOne = true;
//是否为最后一个待配货sku
$preGoods_Obj = new PreGoodsOrdderManageModel();
$allSkuInfo = $preGoods_Obj->getSKUDetail($orderid);
//订单的全部sku列表
foreach ($allSkuInfo as $row) {
//判断该料号配完以后是否可以终结该备货单
if ($row['amount'] != $row['scantnum'] && $row['sku'] != $sku) {
$isLastOne = FALSE;
}
}
if ($waitScan != $num) {
$isLastOne = FALSE;
}
$isEnd = $isLastOne;
//$this->logRequest(" sku==> $sku 数量==> $num"); //记录请求日志
$paramArr['method'] = 'ow_pregood_changestock';
//API名称
$paramArr['sku'] = $sku;
$paramArr['num'] = $num;
$paramArr['orderSn'] = $orderSn;
$paramArr['operUser'] = getUserNameById($opuser);
$messageInfo = UserCacheModel::callOpenSystem2($paramArr);
//先到老系统扣库存
if (FALSE === $messageInfo) {
//请求开发系统出错
self::$errmsg = '请求开放系统出错!';
return FALSE;
}
$code = isset($messageInfo['code']) ? trim($messageInfo['code']) : '';
if ($code !== 'success') {
//扣库存失败
self::$errmsg = $messageInfo['msg'];
return FALSE;
}
$sku = mysql_real_escape_string($sku);
$this->dbConn->begin();
$rcordInfo = $this->getSkuInboxRecords($sku);
if (FALSE === $rcordInfo) {
//还没有封箱库存记录 则新增一条记录
$insertResult = $this->insertNewInboxRecords($sku, $num);
if (FALSE === $insertResult) {
//插入失败 回滚
$this->dbConn->rollback();
self::$errmsg = "新增封箱库存记录失败!";
return FALSE;
}
} else {
//追加库存
$updateSql = "update wh_inboxStock set num=num+{$num} where sku='{$sku}'";
$updateQuery = $this->dbConn->query($updateSql);
if (FALSE === $updateQuery) {
//更新封箱库存失败 回滚
$this->dbConn->rollback();
self::$errmsg = "更新封箱库存失败!";
return FALSE;
}
}
$time = time();
$updateOrder = "\n update wh_prepDetail set scantnum=scantnum+{$num}, scantime={$time}, scanuser='******' where \n sku='{$sku}' and orderid='{$orderid}'\n ";
$upOrderQuery = $this->dbConn->query($updateOrder);
//更新备货单的扫描数量
if (FALSE === $upOrderQuery) {
$this->dbConn->rollback();
self::$errmsg = '更新备货单数据失败!';
return FALSE;
}
if (TRUE === $isLastOne) {
//配货完成 修改备货单状态
$upStatusSql = "update wh_prepGoodsOrder set status=3 where id='{$orderid}'";
$upStatusQuery = $this->dbConn->query($upStatusSql);
if (FALSE === $upStatusQuery) {
$this->dbConn->rollback();
self::$errmsg = '更新备货单状态失败!';
return FALSE;
}
}
$originNum = isset($rcordInfo['num']) ? $rcordInfo['num'] : 0;
$logSql = "insert into wh_skuscanLog (orderId, sku, scanNum, originNum, opuser, scanTime) values\n ({$orderid}, '{$sku}', '{$num}', '{$originNum}', '{$opuser}', '{$time}')\n ";
$logResult = $this->dbConn->query($logSql);
//记录操作日志
if (FALSE === $logResult) {
//写日志失败 回滚
$this->dbConn->rollback();
self::$errmsg = '写入操作日志失败!';
return FALSE;
}
$this->dbConn->commit();
return TRUE;
}
