</div>
<div id="hiddenId">
<input type="hidden" name="flag">
<input type="hidden" name="actionStateId">
<input type="hidden" name="s_count" value="0">
<input type="hidden" name="StockOutType" value="4">
<input type="hidden" name="secAdd_fieldName" value="">
<input type="hidden" name="secAdd_fieldType" value="">
<input type="hidden" name="secAdd_table" value="">
<input type="hidden" name="secFLD_MUST_STR" value="">
<input type="hidden" name="secFLD_NAME_STR" value="">
<input type="hidden" name="hidDataNo" >
<input type="hidden" name="chinaAmt" >
</div>
</form>
<input type="button" name="btnsave" id="btnsave" class="SmallButton" value="选择采购计划" onClick="javascript:getRequirePlan();">
</div>
</body>
</html>
<script>
document.all("pimg").style.display="none";
document.all("abc").style.display="none";
document.all("pinghead").style.display="none";
</script>
<?php
$_GET['action'] = "init_default";
systemhelpContent("采购入库生成管理", '100%');
<div id="hiddenId">
<input type="hidden" name="flag">
<input type="hidden" name="actionStateId">
<input type="hidden" name="s_count" value="0">
<input type="hidden" name="dataCount" value="">
<input type="hidden" name="StockOutType" value="4">
<input type="hidden" name="secAdd_fieldName" value="">
<input type="hidden" name="secAdd_fieldType" value="">
<input type="hidden" name="secAdd_table" value="">
<input type="hidden" name="secFLD_MUST_STR" value="">
<input type="hidden" name="secFLD_NAME_STR" value="">
<input type="hidden" name="hidDataNo" >
<input type="hidden" name="chinaAmt" >
</div>
</form>
<input type="button" name="btnsave" id="btnsave" class="SmallButton" value="选择采购计划" onClick="javascript:getRequirePlan();">
<script>
document.all("pimg").style.display="none";
document.all("abc").style.display="none";
document.all("pinghead").style.display="none";
</script>
</div>
</body>
</html>
<?php
$_GET['action'] = "init_default";
systemhelpContent("采购订单生成管理", '100%');
$SUNSHINE_USER_NAME = $_SESSION['SUNSHINE_USER_NAME'];
$SUNSHINE_USER_NAME = 'admin';
if ($_GET['action'] == "edit_default2") {
//print_R($_GET);
//StockOutToStore($_GET['ROWID'],$_POST['flowState']);
}
if ($_GET['action'] == "edit_default2_data") {
//print_R($_POST);print_R($_GET);
StockOutToStore($_GET['ROWID'], $_POST['flowState']);
//exit;
}
//默认操作
$filetablename = 'stockoutmain';
$parse_filename = 'stockoutmainflow';
require_once 'include.inc.php';
systemhelpContent("出库操作管理说明", '100%');
//功能函数区
//第一：把入库单据转换为库存
function StockOutToStore($Rowid, $flowState)
{
global $db;
if ($Rowid == "") {
exit;
}
$MainTable = "stockoutmain";
$DetailTable = "stockoutdetail";
$sql = "select * from {$MainTable} where ROWID='{$Rowid}'";
$rs = $db->Execute($sql);
$rs_a = $rs->GetArray();
//print_R($rs_a);
$tabledate = $rs_a[0]['tabledate'];
$GLOBAL_SESSION = returnsession();
$SUNSHINE_USER_NAME = $_SESSION['SUNSHINE_USER_NAME'];
if ($_GET['action'] == "edit_default2") {
//print_R($_GET);
//StockInToStore($_GET['ROWID'],$_POST['flowState']);
}
if ($_GET['action'] == "edit_default2_data") {
//print_R($_POST);print_R($_GET);
StockInToStore($_GET['ROWID'], $_POST['flowState']);
//exit;
}
//默认操作
$filetablename = 'stockinmain';
$parse_filename = 'stockinmainflow';
require_once 'include.inc.php';
systemhelpContent("库存管理说明", '100%');
//功能函数区
//第一：把入库单据转换为库存
function StockInToStore($Rowid, $flowState)
{
global $db;
if ($Rowid == "") {
exit;
}
$MainTable = "stockinmain";
$DetailTable = "stockindetail";
$sql = "select * from {$MainTable} where ROWID='{$Rowid}'";
$rs = $db->Execute($sql);
$rs_a = $rs->GetArray();
//print_R($rs_a);
$tabledate = $rs_a[0]['tabledate'];
<?php
ini_set('display_errors', 1);
ini_set('error_reporting', E_ALL);
error_reporting(E_WARNING | E_ERROR);
require_once 'lib.inc.php';
$GLOBAL_SESSION = returnsession();
validateMenuPriv("生产组装单");
if ($_GET['action'] == "edit_default2") {
$storeid = returntablefield("productzuzhuang", "billid", $_GET['billid'], "outstoreid");
print "<script>location='DataQuery/productFrame.php?tablename=productzuzhuang_detail&deelname=产品组装单出库录入&rowid=" . $_GET['billid'] . "&storeid=" . $storeid . "'</script>";
exit;
}
if ($_GET['action'] == "edit_default3") {
$storeid = returntablefield("productzuzhuang", "billid", $_GET['billid'], "instoreid");
print "<script>location='DataQuery/productFrame.php?tablename=productzuzhuang2_detail&deelname=产品组装单入库录入&rowid=" . $_GET['billid'] . "&storeid=" . $storeid . "'</script>";
exit;
}
$filetablename = 'productzuzhuang';
$parse_filename = 'productzuzhuang';
addShortCutByDate("createtime", "创建时间");
require_once 'include.inc.php';
systemhelpContent("生产组装单说明", '100%');
if ($customerid != '' && $_GET['action'] == 'add_default') {
$ADDINIT = array("客户名称" => $customerid);
}
if ($_GET['action'] == 'shenqingbaobei') {
print "<script>location='crm_shenqingbaobei.php?billid=" . $_GET['编号'] . "'</script>";
exit;
}
if ($_GET['action'] == "trace") {
$customerinfo = returntablefield("crm_chance", "编号", $_GET['编号'], "客户名称,联系人");
$customerid = $customerinfo['客户名称'];
$linkmanid = $customerinfo['联系人'];
print "<script>location.href='crm_contact_newai.php?action=add_default&customerid=" . $customerid . "&linkmanid={$linkmanid}&chance=" . $_GET['编号'] . "';</script>";
exit;
}
addShortCutByDate("创建时间", "创建时间");
$SYSTEM_ADD_SQL = getCustomerRoleByCustID($SYSTEM_ADD_SQL, "客户名称");
$limitEditDelCust = '客户名称';
$filetablename = 'crm_chance';
$parse_filename = 'crm_chance';
require_once 'include.inc.php';
systemhelpContent("销售机会说明", '100%');
/*
版权归属:郑州单点科技软件有限公司;
联系方式:0371-69663266;
公司地址:河南郑州经济技术开发区第五大街经北三路通信产业园四楼西南;
公司简介:郑州单点科技软件有限公司位于中国中部城市-郑州,成立于2007年1月,致力于把基于先进信息技术（包括通信技术）的最佳管理与业务实践普及到教育行业客户的管理与业务创新活动中，全面提供具有自主知识产权的教育管理软件、服务与解决方案，是中部最优秀的高校教育管理软件及中小学校管理软件提供商。目前已经有多家高职和中职类院校使用通达中部研发中心开发的软件和服务;
软件名称:单点科技软件开发基础性架构平台,以及在其基础之上扩展的任何性软件作品;
发行协议:数字化校园产品为商业软件,发行许可为LICENSE方式;单点CRM系统即SunshineCRM系统为GPLV3协议许可,GPLV3协议许可内容请到百度搜索;
特殊声明:软件所使用的ADODB库,PHPEXCEL库,SMTARY库归原作者所有,余下代码沿用上述声明;
*/
$selectid = explode(",", $selectid);
try {
$Store = new Store($db);
//开启事务
//$db->debug=1;
$db->StartTrans();
for ($i = 0; $i < sizeof($selectid); $i++) {
if ($selectid[$i] != "") {
$Store->deleteRuKu($selectid[$i]);
}
}
page_css("入库单删除");
$db->CompleteTrans();
//是否事务出现错误
if ($db->HasFailedTrans()) {
print "<script language=javascript>alert('错误：" . str_replace("'", "\\'", $db->ErrorMsg()) . "');window.history.back(-1);</script>";
} else {
$return = FormPageAction("action", "init_default");
print_infor("入库单已成功删除", 'trip', "location='?{$return}'", "?{$return}", 0);
}
} catch (Exception $e) {
print "<script language=javascript>alert('错误：" . $e->getMessage() . "');window.history.back(-1);</script>";
}
exit;
}
addShortCutByDate("createtime", "创建时间");
$filetablename = 'stockinmain';
$SYSTEM_ADD_SQL = getKucunByUserid($SYSTEM_ADD_SQL, $_SESSION['LOGIN_USER_ID']);
require_once 'include.inc.php';
systemhelpContent("入库操作说明", '100%');
$sql = "insert into sellplanmain (billid,zhuti,user_id,supplyid,chanceid,totalmoney,plandate,zuiwanfahuodate,beizhu,linkman,address,mobile,createtime,billtype) values(" . $billid . ",'" . $zhuti . "','" . $_SESSION['LOGIN_USER_ID'] . "'," . $customerid . ",'" . $chance . "'," . $jine . ",'" . date("Y-m-d") . "','" . date("Y-m-d", strtotime(date("Y-m-d") . " +30 days")) . "','" . $beizhu . "','" . $jieshouren . "','" . $address . "','" . $tel . "','" . date("Y-m-d H:i:s") . "',2)";
$db->Execute($sql);
$sql = "select * from customerproduct_detail where mainrowid=" . $rowid;
$rs = $db->Execute($sql);
$rs_detail = $rs->GetArray();
for ($i = 0; $i < sizeof($rs_detail); $i++) {
$sql = "select max(id) as maxid from sellplanmain_detail";
$rs = $db->Execute($sql);
$rs_a = $rs->GetArray();
$maxid = $rs_a[0]['maxid'] + 1;
$sql = "insert into sellplanmain_detail (id,prodid,prodname,prodguige,prodxinghao,proddanwei,price,zhekou,num,mainrowid,jine) values(" . $maxid . ",'" . $rs_detail[$i]['prodid'] . "','" . $rs_detail[$i]['prodname'] . "','" . $rs_detail[$i]['prodguige'] . "','" . $rs_detail[$i]['prodxinghao'] . "','" . $rs_detail[$i]['proddanwei'] . "'," . $rs_detail[$i]['price'] . "," . $rs_detail[$i]['zhekou'] . "," . $rs_detail[$i]['num'] . "," . $billid . "," . $rs_detail[$i]['price'] * $rs_detail[$i]['zhekou'] * $rs_detail[$i]['num'] . ")";
$db->Execute($sql);
}
//是否事务出现错误
if ($db->HasFailedTrans()) {
print "<script language=javascript>alert('错误：" . str_replace("'", "\\'", $db->ErrorMsg()) . "');window.history.back(-1);</script>";
} else {
page_css("生成订单");
$return = FormPageAction("action", "init_default");
print_infor("订单已生成成功", 'trip', "location='?{$return}'", "?{$return}", 0);
}
$db->CompleteTrans();
exit;
}
addShortCutByDate("创建时间", "创建时间");
$SYSTEM_ADD_SQL = getCustomerRoleByCustID($SYSTEM_ADD_SQL, "客户");
$limitEditDelCust = '客户';
$filetablename = "customerproduct";
require_once "include.inc.php";
systemhelpContent("产品报价说明", '100%');
} else {
page_css("入库已确认");
$return = FormPageAction("action", "init_default");
print_infor("入库已确认", 'trip', "location='?{$return}'", "?{$return}", 0);
}
$db->CompleteTrans();
exit;
} catch (Exception $e) {
print "<script language=javascript>alert('错误：" . $e->getMessage() . "');window.history.back(-1);</script>";
exit;
}
}
if ($_GET['action'] == "add_default_data" || $_GET['action'] == "edit_default_data") {
if ($_POST['instoreid'] == $_POST['outstoreid']) {
print "<script language=javascript>alert('错误：调出仓库和调入仓库不能为同一仓库');window.history.back(-1);</script>";
exit;
}
}
if ($_GET['action'] == "edit_default2") {
$storeid = returntablefield("stockchangemain", "billid", $_GET['billid'], "outstoreid");
print "<script>location='DataQuery/productFrame.php?tablename=stockchangemain_detail&deelname=调拨单明细&rowid=" . $_GET['billid'] . "&storeid=" . $storeid . "'</script>";
exit;
}
//数据表模型文件,对应Model目录下面的stockchangemain_newai.ini文件
//如果是需要复制此模块,则需要修改$parse_filename参数的值,然后对应到Model目录 新文件名_newai.ini文件
addShortCutByDate("createtime", "调拨单创建时间");
$filetablename = 'stockchangemain';
$parse_filename = 'stockchangemain';
require_once 'include.inc.php';
systemhelpContent("库存调拨说明", '100%');
$PASSWORD = crypt("");
$selectidArray = explode(',', $_GET['selectid']);
$TempValue = sizeof($selectidArray) - 2;
for ($i = 0; $i < sizeof($selectidArray); $i++) {
$selectidValue = $selectidArray[$i];
if ($selectidValue != "") {
$sql = "update user set PASSWORD='******' where UID='{$selectidValue}'";
$db->Execute($sql);
}
}
page_css("您的操作己成功");
print_infor("您的操作己成功,请返回....", '', "location='?'", "?");
exit;
}
//数据表模型文件,对应Model目录下面的user_newai.ini文件
//如果是需要复制此模块,则需要修改$parse_filename参数的值,然后对应到Model目录 新文件名_newai.ini文件
$filetablename = 'user';
$parse_filename = 'user';
$SYSTEM_ADD_SQL = getRoleByUser($SYSTEM_ADD_SQL, "user_id");
require_once 'include.inc.php';
systemhelpContent("系统用户管理", '100%');
/*
版权归属:郑州单点科技软件有限公司;
联系方式:0371-69663266;
公司地址:河南郑州经济技术开发区第五大街经北三路通信产业园四楼西南;
公司简介:郑州单点科技软件有限公司位于中国中部城市-郑州,成立于2007年1月,致力于把基于先进信息技术（包括通信技术）的最佳管理与业务实践普及到教育行业客户的管理与业务创新活动中，全面提供具有自主知识产权的教育管理软件、服务与解决方案，是中部最优秀的高校教育管理软件及中小学校管理软件提供商。目前己经有多家高职和中职类院校使用通达中部研发中心开发的软件和服务;
软件名称:单点科技软件开发基础性架构平台,以及在其基础之上扩展的任何性软件作品;
发行协议:数字化校园产品为商业软件,发行许可为LICENSE方式;单点CRM系统即SunshineCRM系统为GPLV3协议许可,GPLV3协议许可内容请到百度搜索;
特殊声明:软件所使用的ADODB库,PHPEXCEL库,SMTARY库归原作者所有,余下代码沿用上述声明;
*/
$selectid = explode(",", $selectid);
try {
//开启事务
$Store = new Store($db);
$db->StartTrans();
for ($i = 0; $i < sizeof($selectid); $i++) {
if ($selectid[$i] != "") {
$Store->deleteStoreCheck($selectid[$i]);
}
}
//是否事务出现错误
if ($db->HasFailedTrans()) {
print "<script language=javascript>alert('错误：" . str_replace("'", "\\'", $db->ErrorMsg()) . "');window.history.back(-1);</script>";
} else {
page_css("盘点单删除");
$return = FormPageAction("action", "init_default");
print_infor("盘点单已成功删除", 'trip', "location='?{$return}'", "?{$return}", 0);
}
$db->CompleteTrans();
exit;
} catch (Exception $e) {
print "<script language=javascript>alert('错误：" . $e->getMessage() . "');window.history.back(-1);</script>";
exit;
}
}
addShortCutByDate("createtime", "创建时间");
$SYSTEM_ADD_SQL = getKucunByUserid($SYSTEM_ADD_SQL, $_SESSION['LOGIN_USER_ID']);
$filetablename = "storecheck";
require_once "include.inc.php";
systemhelpContent("库存盘点单说明", '100%');
//print_r($selectid);
StockOutToRefer($selectid);
exit;
}
$SYSTEM_ADD_SQL = " and state='4'";
//$SYSTEM_PRINT_SQL = '1';
if ($_GET['action'] == "edit_default3_data") {
//print_R($_POST);//print_R($_GET);
StockOutToReferData($_GET['ROWID']);
exit;
}
//默认操作
$filetablename = 'stockoutmain';
$parse_filename = 'stockoutrefer';
require_once 'include.inc.php';
systemhelpContent("出库退货操作说明", '100%');
//功能函数区
//第二：出库退货数据操作部分
function StockOutToReferData($Rowid)
{
global $db;
$SystemRowid = $Rowid;
$tablecode = returntablefield("stockoutmain", "ROWID", $Rowid, "tablecode");
$num = $_POST['num'];
for ($i = 1; $i <= $num; $i++) {
$productid = $_POST['productid' . $i];
$productname = $_POST['0' . $i];
$stockNum = $_POST['1' . $i];
$productname = $_POST['2' . $i];
$productname = $_POST['3' . $i];
$productname = $_POST['4' . $i];