acc_dpkcmx.php

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

<?php
////////////////////////////////////////////////////////
// Author by Shuweich
// Date : 2007.07.27
// 2007.11.16 完成了前端界面的开发
// 建站支持: http://www.shuweich.net
// 作者: Shuweich
// QQ: 1502384
// ICQ: 190492112
// MSN: [e-mail]
// E-mail: [e-mail]
// E-mail: [e-mail]
////////////////////////////////////////////////////////
// 模块管理 by lssppxb
// For 单品库存明细
////////////////////////////////////////////////////////
// 考虑增面HTML头尾结构
$title='单品库存明细查询';
include_once '../../mainfile.php';
include_once 'head_acc.php';
include_once 'head_inc.php';

$_S_id = $_REQUEST['s_id0'];
$s_id = $_REQUEST['s_id0'];
echo "<span style='font-size:20px;'>单　品　库　存　明　细<br />
===================================\n";

## 根据`bybz`字段值定义具体语句    [2]       [3]         [4]    [5]    [6] ## To Debug ##

echo "<form method='post' action='".$_SERVER['PHP_SELF']."?s_id0=".$_REQUEST['s_id0']."' name='seri_prc' >\n";
?>

    <input type='hidden' size='1' value='1' id='dpmx_post' name='dpmx_post' />
      商品条码：<input type='text' value='6907305' id='sp_spbm0' name='sp_spbm0' size='19' autocomplete='off' onkeyup='javascript:if ( this.value.length == 13 ) { chk_code(this.value); }' />
      &nbsp;<input  type='text' value='' id='spmc0_1' name='spmc0_1' size='29' readonly />
      &nbsp;<input  type='text' value='' id='sp_code0_1' name='sp_code0_1' size='19' readonly />

    <hr width='606' align='left' />
    &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
    <input type='button' value='取消' onclick='javascript:window.location.href="<?php echo $_SERVER['PHP_SELF'].'?s_id0='.$_REQUEST['s_id0']; ?>";' />&nbsp;&nbsp;
    <input type='submit' name='B01' id='B01' value='查询' disabled />&nbsp;&nbsp;&nbsp;
  </form>
<script language='javascript'>
<!--
  var hs = 1;
  var curr_hs = 1;
  var pload = 'acc_dpkcmx';
  var _dj = false;
//-->
</script>

<?php
include_once 'inc_prod_arr.php';
?>

<script type="text/javascript">
<!--

  function sum_sj() {
    var f=1;
  }

  function chk_code(sp_barcode) {
    cre_prod_arr(sp_barcode);
    var mhs = products_search(sp_barcode,1);
    if ( mhs ) document.getElementById('B01').disabled=false;
  }

//-->
</script>
<?php
if ( $_REQUEST['dpmx_post'] == '1' ) {
  $que = array();
  $que[0] = "select sp_date,jzzy,jf,df,sp_kc,rz_user_id from ".$xoopsDB->prefix("market_spkcmx")." where store_id='".$_REQUEST['s_id0']."' and sp_code='".$_REQUEST['sp_code0_1']."' order by sp_date,jzzy";
  $title = $_REQUEST['spmc0_1']."库存明细帐";
  $tabHead = array
  (
  0 =>array('name' =>'记 帐 日 期','attr' =>'','w' =>138,'size' =>14,'sum' =>0,'func' =>'$out=substr($row[0],0,16);'),
  1 =>array('name' =>'摘　要','attr' =>'','w' =>84,'size' =>14,'sum' =>0,'func' =>'$out=$_ZY[$row[1]];'),
  2 =>array('name' =>'借(收入)方','attr' =>'','w' =>94,'size' =>14,'sum' =>1,'roundec' =>2),
  3 =>array('name' =>'贷(发出)方','attr' =>'','w' =>94,'size' =>14,'sum' =>1,'roundec' =>2),
  4 =>array('name' =>'结存','attr' =>'','w' =>54,'size' =>14,'sum' =>0,'roundec' =>2),
  5 =>array('name' =>'记帐员','attr' =>'','w' =>94,'size' =>14,'sum' =>0)
  );
  $Other='sumres=1';
  include_once 'head_func.php';
  DispData($que,$title,$tabHead,$Other,$_ZY);
  ## echo "数据查询域<hr />\n";
}

include_once '../../footer.php';
?>