acc_dypdcy.php

自己实现一个实用的商店应用系统

<?php
////////////////////////////////////////////////////////
// Author by Shuweich
// Date : 2007.11.13
// 建站支持: http://www.shuweich.net
// 作者: Shuweich
// QQ: 1502384
// ICQ: 190492112
// MSN: [e-mail]
// E-mail: [e-mail]
// E-mail: [e-mail]
////////////////////////////////////////////////////////
// 模块管理 by txdyz
// For 查询当日流水
////////////////////////////////////////////////////////
$title='打印盘点差异';
include_once '../../mainfile.php';
include_once 'head_inc.php';

include_once 'head_win.php';

if ( isset($_REQUEST['wrt_diff']) && $_REQUEST['wrt_diff'] == '1' ) {
  if ( $_REQUEST['wrt_stat'] == 'inst' ) {

  		## 取本店最大流水　+　1(代码待改进)　　！！！！！
    $que = "select sdbh ";
    $que.= " from ".$xoopsDB->prefix("market_mdseri");
    $que.= " where store_id='".$_REQUEST['s_id0']."' order by sdbh desc limit 0,1";
    $res = $xoopsDB->query($que);
    $row = $xoopsDB->fetchrow($res);
    $sdbh0 = $row[0] + 1;
    ## echo "<hr />$que<hr />\n";
  		## 取本店最大流水　+　1　　！！！！！

    $que = "select a.store_id,a.pd_date,b.sp_barcode,a.sp_code,sum(a.pd_cl)-b.sp_kc as pd_cy ";
    $que.= " from ".$xoopsDB->prefix("market_pdsj")." a left join ";
    $que.= $xoopsDB->prefix("market_spkc")." b using (store_id,sp_code) where ";
    $que.= "a.store_id='".$_REQUEST['s_id0']."' and pd_shbz!='2' and substring(a.pd_date,1,10)='".$_REQUEST['pd_date']."'";
    $que.= " group by a.sp_code order by a.sp_code";
    $res = $xoopsDB->query($que);
    $dque =  "insert into ".$xoopsDB->prefix("market_mdseri");
    $dque .= " (bh,store_id,sdbh,bdxh,date_q,date_h,sp_barcode,sp_code,xssl,rz_user_id,shbz,zy,oth_read) values ";
    $S_ID = $_REQUEST['s_id0'];
    $i=0;
    ## echo $que."<hr />\n";
    while ( $row = $xoopsDB->fetchArray($res) ) {
      ## echo "<pre>\n"; print_r($row); echo "</pre>\n";
      $i++;
      if ( $row['pd_cy'] > 0 ) {
        $pd_zy='mdpy';	$pd_sm='盘盈+';
      } elseif ( $row['pd_cy'] < 0 ) {
        $pd_zy='mdpk';	$pd_sm='盘亏-';	$row['pd_cy'] = 0 - $row['pd_cy']; 
      } elseif ( $row['pd_cy'] == 0 ) {
        $pd_zy='mdpy';	$pd_sm='√';
      }
      $dque .= "(0,";
      $dque .= "'".$_REQUEST['s_id0']."',";
      $dque .= $sdbh0.",";
      $dque .= $i.",";
      $dque .= "'".$row['pd_date']."',";
      $dque .= "now(),";
      $dque .= "'".$row['sp_barcode']."',";
      $dque .= "'".$row['sp_code']."',";
      $dque .= "'".$row['pd_cy']."',";
      $dque .= "'".$xoopsUser->getVar("uid")."',";
      $dque .= "'0',";
      $dque .= "'".$pd_zy."',";			## 交易代码
      $dque .= "'".$pd_sm."'";			## 说明或留言
      $dque .= "),";
    }
    $dque = substr($dque,0,-1);
  } elseif ( $_REQUEST['wrt_stat'] == 'dele' ) {
    $dque  = "update ".$xoopsDB->prefix("market_pdsj");
    $dque .= " set pd_shbz='2' ";
    $dque .= " where substring(pd_date,1,10)='".$_REQUEST['pd_date']."' and store_id='".$_REQUEST['s_id0']."'";
  } elseif ( $_REQUEST['wrt_stat'] == 'zero' ) {
    $que = "select distinct sp_code from ".$xoopsDB->prefix("market_pdsj");
    $que .=" where substring(pd_date,1,10)='".$_REQUEST['pd_date']."' and store_id='".$_REQUEST['s_id0']."'";
    $res = $xoopsDB->query($que);
    $in_code = "'"; while ($row = $xoopsDB->fetchrow($res) ) { $in_code .= $row[0]."','"; }
    $in_code = substr($in_code,0,-2);
    $dque = "insert into ".$xoopsDB->prefix("market_pdsj");
    $dque .=" (pd_id,store_id,pd_date,pd_xh,sp_code,pd_cl,pd_shbz,pd_user_id) "; 
    $dque .="select distinct 0,'".$_REQUEST['s_id0']."','".$_REQUEST['pd_date']."',sp_id+100000,sp_code,0,'1','".$xoopsUser->getVar("uid")."' ";
    $dque .=" from ".$xoopsDB->prefix("market_spkc");
    $dque .=" where store_id='".$_REQUEST['s_id0']."' and sp_code not in (".$in_code.")";
  }
  ## echo "<hr />".$dque."<hr />\n";
  $do_que  = $xoopsDB->queryF($dque);
}
?>

<script language='javascript'>
<!--
  function pdcy_sm(stat,pd_date) {
    var act = '<?php echo $_SERVER['PHP_SELF']."?stat="; ?>'+stat+'&s_id0=<?php echo $_REQUEST['s_id0']; ?>';
    document.getElementById('wrt_stat').value=stat;
    document.getElementById('pd_date').value=pd_date;
    document.getElementById('pdcy01').action=act;
    document.getElementById('pdcy01').submit();
  }
// -->
</script>

<?php
$que = "select a.store_id,a.pd_date,b.sp_barcode,a.sp_code,c.sp_name,sum(a.pd_cl) sc,b.sp_kc ";
$que.= " from ".$xoopsDB->prefix("market_pdsj")." a left join ";
$que.= $xoopsDB->prefix("market_spkc")." b using (store_id,sp_code) left join ";
$que.= $xoopsDB->prefix("market_spinfo")." c using (store_id,sp_code) ";
$que.= " where a.store_id='".$_REQUEST['s_id0']."' and a.pd_shbz!='2' group by substring(a.pd_date,1,10),a.sp_code order by substring(a.pd_date,1,10),a.sp_code";
echo "<br /><center>打印盘点差异\n";
## echo $que."<hr />\n";
echo "<table border='1'>\n";
echo "<tr class='v'><th>№</th><th>记帐日期</th><th>商品条码</th><th>商品名称</th><th>盘点数量</th><th>库存数据</th><th>差异</th></tr>\n";

$res = $xoopsDB->query($que);
$i=1;
while ( $row = $xoopsDB->fetchrow($res) ) {
  $pdcy = $row[5] - $row[6];
  if ( $pdcy < 0 ) $cysc = "style='color:#f00;'";
  elseif ( $pdcy > 0 )  $cysc = "style='color:#00f;'";
  elseif ( $pdcy == 0 )  { $cysc = "style='color:#0f0;'"; $pdcy = '√'; }
  echo "<tr>";
  echo "<td>".$i."</td>\n";
  echo "<td><nobr>".substr($row[1],0,10)."</nobr></td>\n";
  echo "<td><nobr>".$row[2]."</nobr></td>\n";
  echo "<td><nobr>".$row[4]."</nobr></td>\n";
  echo "<td align='right'><nobr>".$row[5]."</nobr></td>\n";
  echo "<td align='right'><nobr>".$row[6]."</nobr></td>\n";
  echo "<td ".$cysc." align='right'><nobr>".$pdcy."</nobr></td>\n";
  echo "</tr>";
  $i++;
}

echo "<tr class='v'><th>№</th><th>记帐日期</th><th>商品条码</th><th>商品名称</th><th>盘点数量</th><th>库存数据</th><th>差异</th></tr>\n";
echo "</table>\n";

echo "<form action='' method='post' id='pdcy01' name='pdcy01'>\n";
echo "<input type='hidden' value='1' name='wrt_diff' id='wrt_diff' />\n";
echo "<input type='hidden' value='inst' name='wrt_stat' id='wrt_stat' />\n";
echo "<input type='hidden' value='' name='pd_date' id='pd_date' />\n";
$que = "select substring(pd_date,1,10) from ".$xoopsDB->prefix("market_pdsj");
$que.= " where pd_shbz!='2' group by substring(pd_date,1,10)";
$res = $xoopsDB->query($que);
$c = 'font-size:14px;background-color:#ff9;color:#00F;width:138px;height:20px;';
$s = 'font-size:14px;background-color:#ff9;color:#F00;width:138px;height:20px;';
echo "<nobr>\n";
while ( $row = $xoopsDB->fetchrow($res) ) {
  echo "<input style='$c' type='button' value='建立零库存盘点记录' title='自动生成".$row[0]."零库存单品的盘点记录' onclick=\"javascript:pdcy_sm('zero','$row[0]');\" />";
  echo "&nbsp;\n";
  echo "<input style='$c' type='button' value='差异入帐".$row[0]."' title='建立单品盘点差异流水帐' onclick=\"javascript:pdcy_sm('inst','$row[0]');\" />";
  echo "&nbsp;\n";
  echo "<input style='$s' type='button' value='".$row[0]."数据清除' title='清除".$row[0]."的盘点数据' onclick=\"javascript:pdcy_sm('dele','$row[0]');\" />";
  echo "<br />\n";
}
echo "</nobr>\n";
echo "</form>\n";

echo "<hr /><input type='button' value='关闭窗口' onclick='returnValue=1;window.close();' />\n";

echo "</center>\n";
include_once '../../footer.php';
?>