acc_bgspzl.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_win.php';
echo "<center><span style='font-size:14px;'>";
$TAB = $xoopsDB->prefix("market_spinfo");
$TA0 = $xoopsDB->prefix("market_mdspfl");

if ( $_REQUEST['oper'] == 'sc' ) {
  $del = "delete from ".$TA0." where store_id='696'";
  $de0 = $xoopsDB->queryF($del);
  $ins = "insert into ".$TA0." select 0,'696',sp_date,sp_fl,sp_flm,rz_user_id,sp_bz from ".$TA0." where store_id='".$_REQUEST['s_id0']."'";
  $in0 = $xoopsDB->queryF($ins);

  $que = "select store_id,sp_code from ".$TAB." where store_id='696'";
  $res = $xoopsDB->query($que);
  $num = $xoopsDB->getRowsNum($res);
  $del = "delete from ".$TAB." where store_id='696'";
  $de0 = $xoopsDB->queryF($del);
  $ins = "insert into ".$TAB." select 0,'696',sp_date,sp_fl,sp_code,sp_level,sp_idcode,sp_barcode,sp_name,sp_desc,sp_readme,sp_ename,sp_edesc,sp_ereadme,sp_cb,sp_fjcb,sp_kd,sp_fd,sp_sl,sp_mll,sp_sj,sp_bzdw,sp_mz,sp_jz,sp_jldw,sp_tj,sp_bv,sp_pv,sp_sh,sp_abc_jm,sp_abc_lb,sp_bz,sp_ebz,lr_user_id from ".$TAB." where store_id='".$_REQUEST['s_id0']."'";
  ## echo $ins;
  $in0 = $xoopsDB->queryF($ins);
  $que = "select store_id,sp_code from ".$TAB." where store_id='696'";
  $res = $xoopsDB->query($que);
  $nu2 = $xoopsDB->getRowsNum($res);  
  if ( $de0 && $in0 ) {
    echo "上传商品资料到总店已完成<br /><br />\n";
    echo "<table border='1'>\n";
    echo "<tr><td>旧 数 据:".$num."条</td></tr>\n";
    echo "<tr><td>更新数据:".$nu2."条</td></tr>\n";
    echo "</table>\n";
  } else {
    echo "上传商品资料失败!!\n";
  }
}

if ( $_REQUEST['oper'] == 'xz' ) {
  $del = "delete from ".$TA0." where store_id='".$_REQUEST['s_id0']."'";
  $de0 = $xoopsDB->queryF($del);
  $ins = "insert into ".$TA0." select 0,'".$_REQUEST['s_id0']."',sp_date,sp_fl,sp_flm,rz_user_id,sp_bz from ".$TA0." where store_id='696'";
  $in0 = $xoopsDB->queryF($ins);

  $que = "select store_id,sp_code from ".$TAB." where store_id='".$_REQUEST['s_id0']."'";
  $res = $xoopsDB->query($que);
  $num = $xoopsDB->getRowsNum($res);
  $del = "delete from ".$TAB." where store_id='".$_REQUEST['s_id0']."'";
  $de0 = $xoopsDB->queryF($del);
  $ins = "insert into ".$TAB." select 0,'".$_REQUEST['s_id0']."',sp_date,sp_fl,sp_code,sp_level,sp_idcode,sp_barcode,sp_name,sp_desc,sp_readme,sp_ename,sp_edesc,sp_ereadme,sp_cb,sp_fjcb,sp_kd,sp_fd,sp_sl,sp_mll,sp_sj,sp_bzdw,sp_mz,sp_jz,sp_jldw,sp_tj,sp_bv,sp_pv,sp_sh,sp_abc_jm,sp_abc_lb,sp_bz,sp_ebz,lr_user_id from ".$TAB." where store_id='696'";
  $in0 = $xoopsDB->queryF($ins);
  $que = "select store_id,sp_code from ".$TAB." where store_id='".$_REQUEST['s_id0']."'";
  $res = $xoopsDB->query($que);
  $nu2 = $xoopsDB->getRowsNum($res);  
  if ( $de0 && $in0 ) {
    echo "从总店下载商品资料成功<br /><br />\n";
    echo "<table border='1'>\n";
    echo "<tr><td>旧 数 据:".$num."条</td></tr>\n";
    echo "<tr><td>更新数据:".$nu2."条</td></tr>\n";
    echo "</table>\n";
  } else {
    echo "下载商品资料失败!!\n";
  }
}
echo "<hr /><input type='button' value='关闭窗口' onclick='returnValue=1;window.close();' />";
echo "</span></center>\n";
?>

</body>
</html>