<?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();
global $db;
validateMenuPriv("地域对比");
if (empty($_GET['start_time'])) {
$start_time = date("Y-m-d 00:00:00", strtotime("last year"));
} else {
$start_time = $_GET['start_time'];
}
if (empty($_GET['end_time'])) {
$end_time = date("Y-m-d 23:59:59");
} else {
$end_time = $_GET['end_time'];
}
$type = $_GET['type'];
if ($type == 'zhu' || $type == '') {
$swf = 'Column3D.swf';
} elseif ($type == 'bing') {
$swf = 'Pie2D.swf';
}
$sql = "SELECT c.`name`,SUM(a.totalmoney - a.oddment) as sum FROM sellplanmain a JOIN customer b on a.supplyid=b.ROWID JOIN customerarea c on b.style=c.rowid WHERE a.user_flag>0 and a.createtime>='" . $start_time . "' and a.createtime<='" . $end_time . "' GROUP BY b.style order by sum desc";
$rs = $db->Execute($sql);
$rs_a = $rs->GetArray();
//print_r($rs_a);exit;
$mingci = 20;
// 对前？条记录进行统计
<?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("开票记录");
//数据表模型文件,对应Model目录下面的kaipiaorecord_newai.ini文件
//如果是需要复制此模块,则需要修改$parse_filename参数的值,然后对应到Model目录 新文件名_newai.ini文件
if ($_GET['action'] == "add_default_data") {
global $db;
$db->StartTrans();
$CaiWu = new CaiWu($db);
$CaiWu->insertKaiPiao($_POST['customerid'], $_POST['dingdanbillid'], $_POST['kaipiaoneirong'], $_POST['piaojutype'], $_POST['fapiaono'], $_POST['piaojujine'], $_SESSION['LOGIN_USER_ID']);
//是否事务出现错误
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;
} else {
if ($_GET['action'] == "delete_array") {
$selectid = $_GET['selectid'];
$selectid = explode(",", $selectid);
//开启事务
global $db;
<?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();
global $db;
validateMenuPriv("月度利润走势图");
if (empty($_GET['start_time'])) {
$start_time = date("Y-m", strtotime("last year"));
} else {
$start_time = $_GET['start_time'];
}
if (empty($_GET['end_time'])) {
$end_time = date("Y-m");
} else {
$end_time = $_GET['end_time'];
}
if (strtotime($start_time) > strtotime($end_time)) {
exit('日期区间错误');
}
$start_time_year = date('Y', strtotime($start_time));
$start_time_month = date('m', strtotime($start_time));
//$start_time_day = date('d',strtotime($start_time));
$end_time_year = date('Y', strtotime($end_time));
$end_time_month = date('m', strtotime($end_time));
//$end_time_day = date('d',strtotime($end_time));
$type = $_GET['type'];
$list = array();
if (empty($type) || $type == 'month') {
<?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();
$SYSTEM_PRIV_STOP = "1";
validateMenuPriv("跟踪记录");
$customerid = $_GET['customerid'];
if ($customerid != '' && $_GET['action'] == 'add_default') {
$ADDINIT = array("customerid" => $customerid, "linkmanid" => $_GET['linkmanid'], "chance" => $_GET['chance']);
}
if ($_GET['action'] == "add_default_data") {
require_once "../Framework/uploadFile.php";
uploadFile();
page_css();
$db->StartTrans();
$sql = "select max(id) as max from crm_contact";
$rs = $db->Execute($sql);
$rs_a = $rs->GetArray();
$id = $rs_a[0]['max'] + 1;
$SQL = "INSERT INTO crm_contact(id,customerid,linkmanid,chance,user_id,createman,contact,stage,describes,createtime,contacttime,nextcontacttime,nextissue,alreadycontact,priority,public) value(" . $id . ",'" . $_POST[customerid] . "','" . $_POST[linkmanid] . "','" . $_POST[chance] . "','" . $_POST[user_id] . "','" . $_POST[createman] . "','" . $_POST[contact] . "','" . $_POST[stage] . "','" . $_POST[describes] . "','" . $_POST[createtime] . "','" . $_POST[contacttime] . "','" . $_POST[nextcontacttime] . "','" . $_POST[nextissue] . "','" . $_POST[alreadycontact] . "','" . $_POST[priority] . "','" . $_POST['public'] . "')";
$rs = $db->Execute($SQL);
//同步修改机会表
if ($_POST[chance] != '') {
$sql = "update crm_chance set `最后联系时间`='" . $_POST[contacttime] . "',`当前阶段`='" . $_POST[stage] . "' where `编号`=" . $_POST[chance];
$rs = $db->Execute($sql);
}
//设置提醒
if (!empty($_POST[nextcontacttime])) {
<?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();
$SYSTEM_PRIV_STOP = "1";
validateMenuPriv("任务执行");
function updateWorkplanmain($id)
{
global $db;
$state = 0;
$sql = "select * from workplanmain_detail where mainrowid={$id}";
$rs = $db->Execute($sql);
$rs_a = $rs->GetArray();
if (sizeof($rs_a) > 0) {
$state = 1;
}
$sql = "select * from workplanmain where id={$id}";
$rs = $db->Execute($sql);
$rs_a = $rs->GetArray();
if (sizeof($rs_a) == 1) {
$flag = true;
$zhixingren = $rs_a[0]['zhixingren'];
$zhixingrenArray = explode(",", $zhixingren);
for ($i = 0; $i < sizeof($zhixingrenArray); $i++) {
if ($zhixingrenArray[$i] != '') {
$sql = "select * from workplanmain_detail where createman='" . $zhixingrenArray[$i] . "' and mainrowid={$id} and result=1";
$rs = $db->Execute($sql);
$rs_b = $rs->GetArray();
<?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();
$SYSTEM_PRIV_STOP = "1";
validateMenuPriv("发送邮件");
//print_r($_GET);exit;
if ($_SESSION[SMTPServerIP] == '') {
print "<script language=javascript>alert('您还没有设置邮件发送账户，请先在菜单【我的办公桌】【个人参数配置】中进行设置');</script>";
}
if ($_GET['action'] == "add_default") {
print "<script type=\"text/javascript\" language=\"javascript\" src=\"" . ROOT_DIR . "general/ERP/Enginee/jquery/jquery.js\"></script>";
$sendlist = $_GET['sendlist'];
//print_r($sendlist);exit;
$sendlistarray = explode(",", $sendlist);
$textareaInitValue = "";
for ($i = 0; $i < count($sendlistarray); $i++) {
if ($sendlistarray[$i] == '') {
continue;
} else {
if ($_GET['fromsrc'] == 'supply') {
$linkman = returntablefield("supplylinkman", "rowid", $sendlistarray[$i], "email,supplyname");
if ($linkman['email'] != '') {
if ($textareaInitValue == '') {
$textareaInitValue = $linkman['email'] . ',';
} else {
$textareaInitValue = $textareaInitValue . $linkman['email'] . ',';
}
<?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("销售日报");
global $db;
if (!empty($_GET['start_time'])) {
$start_time = $_GET['start_time'];
} else {
exit('缺少参数');
}
if (!empty($_GET['end_time'])) {
$end_time = $_GET['end_time'];
} else {
exit('缺少参数');
}
if (!empty($_GET['createman'])) {
$createman = $_GET['createman'];
} else {
exit('缺少参数');
}
$where = '';
$data = array();
if ($_GET['where'] == 'yishou') {
$head = array("id" => "单号", "supplyname" => "客户名称", "USER_NAME" => "操作员", "opertype" => "类型", "bankname" => "帐户", "jine" => "收入", "createtime" => "创建时间");
$headtype = array("id" => "char", "supplyname" => "string", "USER_NAME" => "char", "opertype" => "char", "bankname" => "char", "jine" => "float", "createtime" => "string");
$title = "已收货款明细";
$sumcol = array("jine" => "");
<?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();
global $db;
validateMenuPriv("毛利汇总");
if (empty($_GET['start_time'])) {
$start_time = date("Y-m", strtotime("last year"));
} else {
$start_time = $_GET['start_time'];
}
if (empty($_GET['end_time'])) {
$end_time = date("Y-m");
} else {
$end_time = $_GET['end_time'];
}
function printError($errmsg)
{
print "<script>alert('{$errmsg}');history.back(-1);</script>";
}
if (strtotime($start_time) > strtotime($end_time)) {
printError('日期区间错误');
exit;
}
$show_type = empty($_GET['show_type']) ? 'table' : $_GET['show_type'];
$type1 = empty($_GET['type1']) ? 'customer' : $_GET['type1'];
if ($show_type == 'graph') {
if ($type1 == 'customer') {
<?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'] == "add_default_data") {
try {
$piaojujine = floatvalue($_POST['piaojujine']);
$billinfo = returntablefield("buyplanmain", "billid", $_POST['caigoubillid'], "totalmoney,shoupiaomoney");
$maxjine = $billinfo['totalmoney'] - $billinfo['shoupiaomoney'];
if ($maxjine > 0 && $piaojujine > $maxjine) {
throw new Exception("本次收票金额不能大于{$maxjine}");
}
if ($maxjine < 0 && $piaojujine < $maxjine) {
throw new Exception("本次收票金额不能小于{$maxjine}");
}
if ($piaojujine == 0) {
throw new Exception("本次收票金额不能为0");
}
global $db;
$db->StartTrans();
$CaiWu = new CaiWu($db);
$CaiWu->insertShouPiao($_POST['supplyid'], $_POST['caigoubillid'], $_POST['kaipiaoneirong'], $_POST['piaojutype'], $_POST['fapiaono'], $_POST['piaojujine'], $_SESSION['LOGIN_USER_ID'], $_POST['qici'], $_POST['beizhu'], $_POST['kaipiaodate']);
$db->CompleteTrans();
page_css("收票记录");
//是否事务出现错误
if ($db->HasFailedTrans()) {
throw new Exception($db->ErrorMsg());
<?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'] == "mingxi") {
print "<script>location='v_yingkaipiaohuizong_mingxi.php?supplyid=" . $_GET['rowid'] . "'</script>";
exit;
}
/*
if($_GET['action']=="add_default_data") {
//print_R($_GET);print_R($_POST);//exit;
global $db;
$入库数量 = (int)$_POST['入库数量'];$教材编号 = $_POST['教材编号'];
$sql = "update edu_jiaocai set 现有库存=现有库存+$入库数量 where 教材编号='".$教材编号."'";
$rs = $db->Execute($sql);//print $sql;exit;
$_POST['编作者'] = returntablefield("edu_jiaocai","教材编号",$教材编号,"编作者");
$_POST['出版社'] = returntablefield("edu_jiaocai","教材编号",$教材编号,"出版社");
//print "<META HTTP-EQUIV=REFRESH CONTENT='0;URL=?'>";
}
*/
//数据表模型文件,对应Model目录下面的v_yingkaipiaohuizong_newai.ini文件
//如果是需要复制此模块,则需要修改$parse_filename参数的值,然后对应到Model目录 新文件名_newai.ini文件
$filetablename = 'v_yingkaipiaohuizong';
$parse_filename = 'v_yingkaipiaohuizong';
require_once 'include.inc.php';
<?php
/*
版权归属:郑州单点科技软件有限公司;
联系方式:0371-69663266;
公司地址:河南郑州经济技术开发区第五大街经北三路通信产业园四楼西南;
公司简介:郑州单点科技软件有限公司位于中国中部城市-郑州,成立于2007年1月,致力于把基于先进信息技术（包括通信技术）的最佳管理与业务实践普及到教育行业客户的管理与业务创新活动中，全面提供具有自主知识产权的教育管理软件、服务与解决方案，是中部最优秀的高校教育管理软件及中小学校管理软件提供商。目前己经有多家高职和中职类院校使用通达中部研发中心开发的软件和服务;
软件名称:单点科技软件开发基础性架构平台,以及在其基础之上扩展的任何性软件作品;
发行协议:数字化校园产品为商业软件,发行许可为LICENSE方式;单点CRM系统即SunshineCRM系统为GPLV3协议许可,GPLV3协议许可内容请到百度搜索;
特殊声明:软件所使用的ADODB库,PHPEXCEL库,SMTARY库归原作者所有,余下代码沿用上述声明;
*/
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("竞争产品");
$customerid = $_GET['customerid'];
if ($customerid != '' && $_GET['action'] == 'add_default') {
$ADDINIT = array("customerid" => $customerid);
}
addShortCutByDate("createtime", "创建时间");
$SYSTEM_ADD_SQL = getCustomerRoleByCustID($SYSTEM_ADD_SQL, "customerid");
$limitEditDelCust = 'customerid';
$filetablename = "competeproduct";
require_once "include.inc.php";
<?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("解决方案");
$customerid = $_GET['customerid'];
if ($customerid != '' && $_GET['action'] == 'add_default') {
$ADDINIT = array("customerid" => $customerid);
}
$SYSTEM_ADD_SQL = getCustomerRoleByCustID($SYSTEM_ADD_SQL, "customerid");
$limitEditDelCust = 'customerid';
//数据表模型文件,对应Model目录下面的customer_fangan_newai.ini文件
//如果是需要复制此模块,则需要修改$parse_filename参数的值,然后对应到Model目录 新文件名_newai.ini文件
$filetablename = 'customer_fangan';
$parse_filename = 'customer_fangan';
require_once 'include.inc.php';
<?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'] == "action_jiaofu") {
require_once "sellcontract_plan_do.php";
exit;
}
if ($_GET['action'] == "add_default") {
$billid = $_GET['billid'];
$customerid = returntablefield("sellplanmain", "billid", $billid, "supplyid");
$ADDINIT = array("supplyid" => $customerid, "mainrowid" => $billid);
}
if ($_GET['action'] == "workplan") {
$hetongid = returntablefield("v_sellcontract_plan", "id", $_GET['id'], "mainrowid");
$hetongzhuti = returntablefield("v_sellcontract", "billid", $hetongid, "zhuti");
$guanlianurl = urlencode("../JXC/sellcontract_plan_newai.php?action=view_default&id=" . $_GET['id']);
$guanlianshiwu = "合同交付-" . $hetongid;
$zhuti = "执行合同《" . $hetongzhuti . "》";
print "<script>location='../CRM/workplanmain_newai.php?action=add_default&zhuti={$zhuti}&guanlianshiwu={$guanlianshiwu}&guanlianurl={$guanlianurl}'</script>";
exit;
}
if ($_GET['action'] == "add_default_data" || $_GET['action'] == "edit_default_data") {
page_css("合同计划交付");
$jine = round($_POST['num'] * $_POST['price'], 2);
$ifkucun = returntablefield("product", "productid", $_POST['prodid'], "ifkucun");
if ($ifkucun == "是") {
<?php
/*
版权归属:郑州单点科技软件有限公司;
联系方式:0371-69663266;
公司地址:河南郑州经济技术开发区第五大街经北三路通信产业园四楼西南;
公司简介:郑州单点科技软件有限公司位于中国中部城市-郑州,成立于2007年1月,致力于把基于先进信息技术（包括通信技术）的最佳管理与业务实践普及到教育行业客户的管理与业务创新活动中，全面提供具有自主知识产权的教育管理软件、服务与解决方案，是中部最优秀的高校教育管理软件及中小学校管理软件提供商。目前己经有多家高职和中职类院校使用通达中部研发中心开发的软件和服务;
软件名称:单点科技软件开发基础性架构平台,以及在其基础之上扩展的任何性软件作品;
发行协议:数字化校园产品为商业软件,发行许可为LICENSE方式;单点CRM系统即SunshineCRM系统为GPLV3协议许可,GPLV3协议许可内容请到百度搜索;
特殊声明:软件所使用的ADODB库,PHPEXCEL库,SMTARY库归原作者所有,余下代码沿用上述声明;
*/
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_default_data" || $_GET['action'] == "add_default_data") {
$_POST['supplycn'] = 汉字转拼音首字母($_POST['supplyname']);
}
if ($_GET['action'] == "addlinkman") {
print "<script>location.href='supplylinkman_newai.php?action=add_default&supplyid=" . $_GET['ROWID'] . "';</script>";
exit;
}
addShortCutByDate("startdate", "建立日期");
$filetablename = "supply";
require_once "include.inc.php";
<?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'] == 'init_default' || $_GET['action'] == '' || $_GET['action'] == 'init_default_search') {
print "<script type=\"text/javascript\" language=\"javascript\" src=\"" . ROOT_DIR . "general/ERP/Enginee/popup/js/popup.js\"></script>";
print "<script type=\"text/javascript\" language=\"javascript\" src=\"" . ROOT_DIR . "general/ERP/Enginee/popup/js/popupclass.js\"></script>";
}
if ($_GET['action'] == 'colorinput') {
global $db;
$id = $_GET['rowid'];
$colorarray = $_GET['colorarray'];
$colorarray = explode(",", $colorarray);
$sql = "delete from store_color where id={$id}";
$db->Execute($sql);
$sql = "select * from productcolor";
$rs = $db->Execute($sql);
$rs_a = $rs->GetArray();
for ($i = 0; $i < sizeof($rs_a); $i++) {
if (intval($colorarray[$i]) == 0) {
continue;
}
$sql = "insert into store_color values({$id}," . $rs_a[$i]['id'] . "," . $colorarray[$i] . ")";
$db->Execute($sql);
}
print "ok";
exit;
<?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();
$SYSTEM_PRIV_STOP = "1";
validateMenuPriv("公告通知");
global $db;
if ($_GET['action'] == "add_default_data" || $_GET['action'] == "edit_default_data") {
//新增消息通知
$touser = explode(",", $_POST["to_user"]);
$messagetitle = "公告通知";
$guanlianid = $_POST["id"];
if ($_GET['action'] == "edit_default_data") {
$guanlianid = $_GET["id"];
deleteMessage($messagetitle, $guanlianid);
}
$db->StartTrans();
for ($i = 0; $i < sizeof($touser); $i++) {
if ($touser[$i] != "") {
newMessage($touser[$i], $_POST['title'], $messagetitle, '../CRM/notify_newai.php?' . base64_encode('action=view_default&id=' . $guanlianid), $guanlianid);
$userInfo = returntablefield("user", "user_id", $touser[$i], "user_name,email,MOBIL_NO");
$destlist[$i]['email'] = $userInfo['email'];
$destlist[$i]['mobile'] = $userInfo['MOBIL_NO'];
$destlist[$i]['name'] = $userInfo['user_name'];
}
}
$db->CompleteTrans();
//新增邮件通知
<?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']=="add_default_data") {
//print_R($_GET);print_R($_POST);//exit;
global $db;
$入库数量 = (int)$_POST['入库数量'];$教材编号 = $_POST['教材编号'];
$sql = "update edu_jiaocai set 现有库存=现有库存+$入库数量 where 教材编号='".$教材编号."'";
$rs = $db->Execute($sql);//print $sql;exit;
$_POST['编作者'] = returntablefield("edu_jiaocai","教材编号",$教材编号,"编作者");
$_POST['出版社'] = returntablefield("edu_jiaocai","教材编号",$教材编号,"出版社");
//print "<META HTTP-EQUIV=REFRESH CONTENT='0;URL=?'>";
}
*/
$SYSTEM_ADD_SQL = " and mainrowid in (select billid from buyplanmain where user_flag>=1)";
//数据表模型文件,对应Model目录下面的buyplanmain_detail_newai.ini文件
//如果是需要复制此模块,则需要修改$parse_filename参数的值,然后对应到Model目录 新文件名_newai.ini文件
$filetablename = 'buyplanmain_detail';
$parse_filename = 'buyplanmain_detail';
require_once 'include.inc.php';
<?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_fukuan") {
print "<script>location='fukuanplan_do.php?id=" . $_GET['id'] . "&url=" . $_SERVER["PHP_SELF"] . "'</script>";
exit;
}
addShortCutByDate("createtime", "创建时间");
$filetablename = 'fukuanplan';
$parse_filename = 'fukuanplan';
require_once 'include.inc.php';
<?php
//print_r($_GET);
//print_r(base64_decode($_SERVER['QUERY_STRING']));exit;
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("导购排行");
global $db;
if (empty($_GET['start_time'])) {
$start_time = date("Y-m-d 00:00:00", strtotime("last month"));
} else {
$start_time = $_GET['start_time'];
}
if (empty($_GET['end_time'])) {
$end_time = date("Y-m-d 23:59:59");
} else {
$end_time = $_GET['end_time'];
}
switch ($_GET['ordername']) {
case 'name':
$order = 'b.USER_NAME';
break;
case 'num':
$order = 'count(0)';
break;
case 'huikuanjine':
$order = 'sum(huikuanjine)';
break;
<?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'] == "shenhedan") {
$CaiWu = new CaiWu($db);
$db->StartTrans();
$billid = $_GET['单号'];
$feiyonginfo = returntablefield("v_feiyong_sq", "单号", $billid, "金额,费用类型");
$jine = $feiyonginfo['金额'];
$fytype = $feiyonginfo['费用类型'];
$sql = "update crm_feiyong_sq set 是否审核='4',出纳员='" . $_SESSION['LOGIN_USER_ID'] . "',支付时间=now() where 单号='{$billid}'";
$rs = $db->Execute($sql);
$CaiWu->insertFeiYongAccount($fytype, $jine, 1, $_SESSION['LOGIN_USER_ID'], -1);
//是否事务出现错误
if ($db->HasFailedTrans()) {
print "<script language=javascript>alert('错误：" . str_replace("'", "\\'", $db->ErrorMsg()) . "');window.history.back(-1);</script>";
} else {
page_css("报销单审核");
$return = $return . "?" . FormPageAction("action", "init_default");
print_infor("已报销", 'trip', "location='?{$return}'", "{$return}", 0);
}
$db->CompleteTrans();
exit;
}
addShortCutByDate("创建时间", "申请时间");
$filetablename = 'v_feiyong_sq';
<?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();
$SYSTEM_PRIV_STOP = "1";
validateMenuPriv("发货方式", "客户联系人", "供应商联系人", "发货单");
if ($_GET['action'] == "delete_array") {
$selectid = explode(",", $_GET['selectid']);
for ($i = 0; $i < count($selectid); $i++) {
if ($selectid[$i] != '') {
$billid = returntablefield("fahuodan", "fahuotype", $selectid[$i], "billid");
if ($billid != '') {
$fahuoname = returntablefield("fahuotype", "id", $selectid[$i], "name");
print "<script language='javascript'>alert('" . $fahuoname . " 存在发货单记录，请先删除相关单据');window.history.back(-1);</script>";
exit;
}
}
}
}
if ($_POST['action'] == "postmoban") {
global $db;
$content = $_POST['moban'];
$content = urldecode($content);
$contentArray = explode("\r\n", $content);
$NewArray = array();
for ($i = 0; $i < sizeof($contentArray); $i++) {
$Element = $contentArray[$i];
$ElementArray = explode(".ADD_PRINT_TEXT", $Element);
<?php
require_once "lib.inc.php";
$GLOBAL_SESSION = returnsession();
validateMenuPriv("报废记录");
if ($_GET['action'] == "add_default_data") {
page_css('办公用品');
$办公用品编号 = $_POST['办公用品编号'];
$办公用品名称 = $_POST['办公用品名称'];
$所属仓库 = $_POST['所属仓库'];
$报废数量 = $_POST['报废数量'];
$kucun = returntablefield("officeproduct", "办公用品编号", $办公用品编号, "数量", "存放地点", $所属仓库);
if ($kucun < $报废数量) {
print "<script language=javascript>alert('此编号的办公用品库存不足');window.history.back(-1);</script>";
exit;
}
$sql = "update officeproduct set 数量=数量-{$报废数量},合计金额=round(数量*单价,2) where 办公用品编号='{$办公用品编号}' and 存放地点='{$所属仓库}'";
$db->Execute($sql);
}
$filetablename = 'officeproductbaofei';
require_once 'include.inc.php';
<?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();
$SYSTEM_PRIV_STOP = "1";
validateMenuPriv("积分兑换");
$customerid = $_GET['customerid'];
if ($customerid != '' && $_GET['action'] == 'add_default') {
$ADDINIT = array("customid" => $customerid);
}
if ($_GET['action'] == "add_default_data") {
global $db;
$sql = "select integral from customer where ROWID='" . $_POST[customid] . "'";
$rs = $db->Execute($sql);
$rs_a = $rs->GetArray();
$integral = $rs_a[0][integral];
if ($integral < $_POST['integral']) {
print "<script language=javascript>alert('积分不够，不能兑换！');window.history.back(-1);</script>";
exit;
}
$sql = "select num,price from store where prodid='" . $_POST[prodid] . "' and storeid='" . $_POST[stockid] . "'";
$rs = $db->Execute($sql);
$rs_a = $rs->GetArray();
$num = $rs_a[0][num];
$avgprice = $rs_a[0][price];
if ($num < $_POST[exchangenum]) {
print "<script language=javascript>alert('该商品库存不足！');window.history.back(-1);</script>";
exit;
<?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("产品流动表");
global $db;
if (empty($_GET['start_time'])) {
$start_time = date("Y-m-d 00:00:00", strtotime("last month"));
} else {
$start_time = $_GET['start_time'];
}
if (empty($_GET['end_time'])) {
$end_time = date("Y-m-d 23:59:59");
} else {
$end_time = $_GET['end_time'];
}
if (!empty($_GET['productid'])) {
$productid_where = " productid = '" . trim($_GET['productid']) . "' and (ruku<>'' or chuku<>'' or sunyi<>'' or diaobo<>'' or zuzhuang<>'' or nowkucun<>'')";
} else {
$productid_where = " ruku<>'' or chuku<>'' or sunyi<>'' or diaobo<>'' or zuzhuang<>'' or nowkucun<>''";
}
if (!empty($_GET['storeid'])) {
$bb_storeid = ' and bb.storeid=' . trim($_GET['storeid']);
$cc_storeid = ' and cc.storeid=' . trim($_GET['storeid']);
$dd_storeid = ' and dd.storeid=' . trim($_GET['storeid']);
$h_storeid = ' and h.storeid=' . trim($_GET['storeid']);
$zz_instoreid = ' and zz.instoreid=' . trim($_GET['storeid']);
$ee_outstoreid = ' and ee.outstoreid=' . trim($_GET['storeid']);
<?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("供应商供货汇总");
require_once './userdefine/buyplanstate.php';
require_once './userdefine/paystate.php';
require_once './userdefine/kaipiaostate.php';
require_once './userdefine/sellonePriv.php';
global $db;
if (!empty($_GET['start_time'])) {
$start_time = $_GET['start_time'];
} else {
exit('缺少参数');
}
if (!empty($_GET['end_time'])) {
$end_time = $_GET['end_time'];
} else {
exit('缺少参数');
}
$where = '';
if ($_GET['where'] == 'sum_paymoney') {
$where = "`a`.`paymoney`>0 and";
$title = '已支付金额明细';
} elseif ($_GET['where'] == 'sum_ruku') {
$where = "`a`.`rukumoney`>0 and";
$title = '已入库金额明细';
} elseif ($_GET['where'] == 'sum_qiankuan') {
<?php
/*
版权归属:郑州单点科技软件有限公司;
联系方式:0371-69663266;
公司地址:河南郑州经济技术开发区第五大街经北三路通信产业园四楼西南;
公司简介:郑州单点科技软件有限公司位于中国中部城市-郑州,成立于2007年1月,致力于把基于先进信息技术（包括通信技术）的最佳管理与业务实践普及到教育行业客户的管理与业务创新活动中，全面提供具有自主知识产权的教育管理软件、服务与解决方案，是中部最优秀的高校教育管理软件及中小学校管理软件提供商。目前己经有多家高职和中职类院校使用通达中部研发中心开发的软件和服务;
软件名称:单点科技软件开发基础性架构平台,以及在其基础之上扩展的任何性软件作品;
发行协议:数字化校园产品为商业软件,发行许可为LICENSE方式;单点CRM系统即SunshineCRM系统为GPLV3协议许可,GPLV3协议许可内容请到百度搜索;
特殊声明:软件所使用的ADODB库,PHPEXCEL库,SMTARY库归原作者所有,余下代码沿用上述声明;
*/
$filetablename = "certificate";
require_once "include.inc.php";
validateMenuPriv("证照情况");
<?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();
$SYSTEM_PRIV_STOP = "1";
validateMenuPriv("项目报备");
$customerid = $_GET['customerid'];
if ($customerid != '' && $_GET['action'] == 'add_default') {
$ADDINIT = array("customerid" => $customerid);
}
//$SYSTEM_PRINT_SQL = 1;
//print_r($_GET);exit;
if ($_GET['action'] == "edit_TongYi") {
print "<script>location='crm_shenqingbaobei_shenhe.php?id=" . $_GET['id'] . "';</script>";
exit;
}
if ($_POST['action'] == "TongYi") {
page_css();
$billid = $_GET['id'];
$sql = "update crm_shenqingbaobei set state='2',shenheman='" . $_SESSION['LOGIN_USER_ID'] . "',shenhetime=now(),piyu='" . $_POST['piyu'] . "',tixingren='" . $_POST["tixingren"] . "' where id='{$billid}'";
$rs = $db->Execute($sql);
$touser = explode(",", $_POST["tixingren"]);
$messagetitle = "项目报备";
$guanlianid = $billid;
for ($i = 0; $i < sizeof($touser); $i++) {
if ($touser[$i] != "") {
newMessage($touser[$i], $_POST['zhuti'], $messagetitle, '../JXC/crm_shenqingbaobei_newai.php?' . base64_encode('action=view_default&id=' . $guanlianid), $guanlianid);
}
<?php
/*
版权归属:郑州单点科技软件有限公司;
联系方式:0371-69663266;
公司地址:河南郑州经济技术开发区第五大街经北三路通信产业园四楼西南;
公司简介:郑州单点科技软件有限公司位于中国中部城市-郑州,成立于2007年1月,致力于把基于先进信息技术（包括通信技术）的最佳管理与业务实践普及到教育行业客户的管理与业务创新活动中，全面提供具有自主知识产权的教育管理软件、服务与解决方案，是中部最优秀的高校教育管理软件及中小学校管理软件提供商。目前己经有多家高职和中职类院校使用通达中部研发中心开发的软件和服务;
软件名称:单点科技软件开发基础性架构平台,以及在其基础之上扩展的任何性软件作品;
发行协议:数字化校园产品为商业软件,发行许可为LICENSE方式;单点CRM系统即SunshineCRM系统为GPLV3协议许可,GPLV3协议许可内容请到百度搜索;
特殊声明:软件所使用的ADODB库,PHPEXCEL库,SMTARY库归原作者所有,余下代码沿用上述声明;
*/
$filetablename = "property";
require_once "include.inc.php";
validateMenuPriv("隶属行业");
<?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("销售漏斗");
global $db;
if (empty($_GET['start_time'])) {
$start_time = date("Y-m-d 00:00:00", strtotime("last month"));
} else {
$start_time = $_GET['start_time'];
}
if (empty($_GET['end_time'])) {
$end_time = date("Y-m-d 23:59:59");
} else {
$end_time = $_GET['end_time'];
}
$sql = "SELECT b.`编号`,b.`阶段`,COUNT(*) as chance_num,SUM(a.`预计金额`) as money FROM crm_chance a LEFT JOIN crm_jieduan b on a.`当前阶段`=b.`编号` WHERE a.`创建时间`>='" . $start_time . "' and a.`创建时间`<='" . $end_time . "' GROUP BY a.`当前阶段`";
//exit($sql);
$rs = $db->Execute($sql);
$rs_data = $rs->GetArray();
$data = array();
$sum = 0;
$sum_money = 0;
foreach ($rs_data as $row) {
$data[$row['阶段']] = $row;
$sum += $row[chance_num];
$sum_money += $row[money];
}
<?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();
$SYSTEM_PRIV_STOP = "1";
validateMenuPriv("客户服务");
$customerid = $_GET['customerid'];
if ($customerid != '' && $_GET['action'] == 'add_default') {
$ADDINIT = array("客户名称" => $customerid);
}
if ($_GET['action'] == "workplan") {
$crm_servInfo = returntablefield("crm_service", "编号", $_GET['编号'], "服务编号,客户名称,解决人员");
$servertype = returntablefield("crm_dict_servicetypes", "编号", $crm_servInfo['服务编号'], "名称");
$custName = returntablefield("customer", "rowid", $crm_servInfo['客户名称'], "supplyname");
$content = urlencode($crm_servInfo['解决人员']);
$guanlianurl = urlencode("../JXC/crm_service_newai.php?action=view_default&编号=" . $_GET['编号']);
$guanlianshiwu = "客户服务";
$guanlianid = $_GET['编号'];
$zhuti = "处理{$servertype}-{$custName}";
print "<script>location.href='../CRM/workplanmain_newai.php?action=add_default&zhuti={$zhuti}&content=" . $content . "&guanlianshiwu={$guanlianshiwu}&guanlianurl={$guanlianurl}&guanlianid={$guanlianid}';</script>";
exit;
}
$SYSTEM_ADD_SQL = getCustomerRoleByCustID($SYSTEM_ADD_SQL, "客户名称");
$limitEditDelCust = '客户名称';
addShortCutByDate("创建时间", "创建时间");
//数据表模型文件,对应Model目录下面的crm_service_newai.ini文件
//如果是需要复制此模块,则需要修改$parse_filename参数的值,然后对应到Model目录 新文件名_newai.ini文件
$filetablename = 'crm_service';
