Пример #1
0
<?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";
Пример #2
0
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';
$parse_filename = 'v_feiyong_sq';
require_once 'include.inc.php';
Пример #3
0
    $db->StartTrans();
    $fahuoinfo = returntablefield("fahuodan", "billid", $_GET['billid'], "yunfei,jiesuantype,dingdanbillid");
    $yunfei = $fahuoinfo['yunfei'];
    $jiesuantype = $fahuoinfo['jiesuantype'];
    $dingdanbillid = $fahuoinfo['dingdanbillid'];
    //撤销运费
    if ($yunfei != 0 && $jiesuantype == 1) {
        $CaiWu->insertFeiYongAccount(6, -$yunfei, 1, $_SESSION['LOGIN_USER_ID'], -1);
    }
    //撤销发货
    $Store->cancelFaHuo($_GET['billid']);
    //是否事务出现错误
    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;
}
if ($_GET['action'] == 'printKuaiDi') {
    $selectid = $_GET['billid'];
    print "<script>location.href='../CRM/printKuaiDi.php?CustOrSupply=fahuodan&linkmanlist={$selectid}',null,'height=600,width=855,status=1,toolbar=no,menubar=no,location=no,scrollbars=yes,resizable=yes';</script>";
    exit;
}
addShortCutByDate("fahuodate", "发货日期");
$filetablename = 'fahuodan';
$parse_filename = 'fahuodan';
require_once 'include.inc.php';
ini_set('error_reporting', E_ALL);
// display warnings and errors
error_reporting(E_WARNING | E_ERROR);
//header("Content-Type:text/html;charset=gbk");
//######################教育组件-权限较验部分##########################
require_once "lib.inc.php";
$GLOBAL_SESSION = returnsession();
$SYSTEM_PRIV_STOP = 1;
require_once "systemprivateinc.php";
CheckSystemPrivate("人力资源-行政考勤-原始打卡");
//######################教育组件-权限较验部分##########################
$当前学期 = returntablefield("edu_xueqiexec", "当前学期", '1', "学期名称");
if ($_GET['学期'] == "") {
    $_GET['学期'] = $当前学期;
}
addShortCutByDate("考勤日期");
if ($_GET['action'] == "init_default" || $_GET['action'] == "") {
    //print "		<table border=0 class=TableBlock width=100% height=20>		<tr class=TableData><td valign=bottom align=left>该部分数据从考勤机里面提取,数据格式项:教师用户名,教师姓名,考勤日期,刷卡时间.数据导入前,请先<input type=button accesskey=c name=cancel value=\"删除上月考勤数据\" class=SmallButton onClick=\"location='?".base64_encode("action=DeleteCurMonth")."'\" > <BR></td></tr>		</table><BR>		";
}
if ($_GET['action'] == "DeleteCurMonth") {
    page_css("考勤数据清理中...");
    $LikeMonth = date("Y-m-", mktime(1, 1, 1, date("m") - 1, date("d"), date("Y")));
    $sql = "delete from edu_teacherkaoqin where 考勤日期 like '{$LikeMonth}%'";
    $db->Execute($sql);
    //exit;
    print "\n\t\t<table border=0 class=TableBlock width=100% height=20>\n\t\t<tr class=TableHeader><td valign=bottom align=left>当月考勤信息已经被删除,你可以重新导入该月考勤数据,系统返回中...<BR></td></tr>\n\t\t</table><BR>\n\t\t";
    EDU_Indextopage('?', $nums = '0');
    exit;
}
$filetablename = 'edu_teacherkaoqin';
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();
addShortCutByDate("申请日期");
$SYSTEM_ADD_SQL = " and 录单员='" . $_SESSION['LOGIN_USER_ID'] . "'";
//$SYSTEM_PRINT_SQL = 1;
if ($_GET['action'] == "edit_default_data") {
    page_css("佣金申请");
    $单号 = $_POST['单号'];
    $sql = "select * from crm_yongjin_sq where 单号='{$单号}'";
    $rs = $db->Execute($sql);
    $rs_a = $rs->GetArray();
    if ($rs_a[0]['是否审核'] == 1 && 0) {
        print "\n\t\t\t<div align=\"center\" title=\"审核记录管理\">\n\t\t\t<table class=\"MessageBox\" align=\"center\" width=\"650\"><tr><td class=\"msg info\">\n\t\t\t<div class=\"content\" style=\"font-size:12pt\">&nbsp;&nbsp;此项记录已经通过审核,系统禁止编辑操作.</div>\n\t\t\t</td></tr></table>\n\t\t\t<br>\n\t\t\t<div align=center>\n\t\t\t";
        print "<input type=button  value=\"返回\" class=\"SmallButton\" onClick=\"history.go(-2);\">\n\t\t\t</div>\n\t\t\t";
        exit;
    }
    if ($rs_a[0]['是否作废'] == 1) {
        print "\n\t\t\t<div align=\"center\" title=\"作废记录管理\">\n\t\t\t<table class=\"MessageBox\" align=\"center\" width=\"650\"><tr><td class=\"msg info\">\n\t\t\t<div class=\"content\" style=\"font-size:12pt\">&nbsp;&nbsp;此项记录已经作废,系统禁止操作.</div>\n\t\t\t</td></tr></table>\n\t\t\t<br>\n\t\t\t<div align=center>\n\t\t\t";
        print "<input type=button  value=\"返回\" class=\"SmallButton\" onClick=\"history.go(-2);\">\n\t\t\t</div>\n\t\t\t";
        exit;
    }
}
//数据表模型文件,对应Model目录下面的crm_yongjin_sq_newai.ini文件
//如果是需要复制此模块,则需要修改$parse_filename参数的值,然后对应到Model目录 新文件名_newai.ini文件
$filetablename = 'crm_yongjin_sq';
$parse_filename = 'crm_yongjin_sq';
Пример #6
0
        $db->StartTrans();
        for ($i = 0; $i < sizeof($selectid); $i++) {
            if ($selectid[$i] != "") {
                $billid = $selectid[$i];
                $sql = "update buyplanmain set user_flag=-1 where billid={$billid} and user_flag>-1";
                $rs = $db->Execute($sql);
                if ($rs === false) {
                    throw new Exception("不存在此记录");
                }
                $CaiWu->deleteFukuanReocordByBillid($billid);
                $CaiWu->deleteshoupiaoByBillid($billid);
            }
        }
        $db->CompleteTrans();
        page_css("");
        //是否事务出现错误
        if ($db->HasFailedTrans()) {
            throw new Exception($db->ErrorMsg());
        } 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("caigoudate", "采购日期");
$filetablename = "buyplanmain";
require_once "include.inc.php";
systemhelpcontent("采购订单管理", "100%");
<?php

require_once 'lib.inc.php';
$GLOBAL_SESSION = returnsession();
$SYSTEM_PRIV_STOP = 1;
require_once "systemprivateinc.php";
CheckSystemPrivate("人力资源-行政考勤-考勤数据");
$当前学期 = returntablefield("edu_xueqiexec", "当前学期", '1', "学期名称");
if ($_GET['学期'] == "") {
    $_GET['学期'] = $当前学期;
}
addShortCutByDate("日期");
if ($_GET['人员用户名'] != "") {
    $_GET['人员用户名'] = addslashes($_GET['人员用户名']);
    $SYSTEM_ADD_SQL .= " and 人员用户名='" . $_GET['人员用户名'] . "'";
}
$filetablename = 'edu_xingzheng_kaoqinmingxi';
require_once 'include.inc.php';
require_once '../Help/module_xingzhengkaoqin_datalist.php';
if ($_GET['action'] == "delete_array") {
    $selectid = $_GET['selectid'];
    $selectid = explode(",", $selectid);
    $db->StartTrans();
    require_once "../Framework/uploadFile.php";
    for ($i = 0; $i < sizeof($selectid); $i++) {
        if ($selectid[$i] != "") {
            deleteFile("workplanmain_detail", "id", $selectid[$i], "fujian");
            $mainrowid = returntablefield("workplanmain_detail", "id", $selectid[$i], "mainrowid");
            $sql = "delete from workplanmain_detail where id=" . $selectid[$i];
            $db->Execute($sql);
            updateWorkplanmain($mainrowid);
        }
    }
    //是否事务出现错误
    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("begintime", "开始时间");
$SYSTEM_ADD_SQL = getRoleByUser($SYSTEM_ADD_SQL, "createman");
//$SYSTEM_PRINT_SQL=1;
$filetablename = 'workplanmain_detail';
$parse_filename = 'workplanmain_detail';
require_once 'include.inc.php';
            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;
    }
}
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%');
Пример #10
0
<?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("手机短信");
addShortCutByDate("nowtime", "提交时间");
$SYSTEM_ADD_SQL = $SYSTEM_ADD_SQL = getRoleByUser($SYSTEM_ADD_SQL, "userid");
//数据表模型文件,对应Model目录下面的sms_sendlist_newai.ini文件
//如果是需要复制此模块,则需要修改$parse_filename参数的值,然后对应到Model目录 新文件名_newai.ini文件
$filetablename = 'sms_sendlist';
$parse_filename = 'sms_sendlist';
require_once 'include.inc.php';
if ($_GET['action'] == "add_default") {
    $sendlist = $_GET['sendlist'];
    $sendlistarray = explode(",", $sendlist);
    $textareaInitValue = "";
    for ($i = 0; $i < count($sendlistarray); $i++) {
        if ($sendlistarray[$i] == '') {
            continue;
        }
        if ($_GET['fromsrc'] == 'user') {
            $linkman = returntablefield("user", "UID", $sendlistarray[$i], "MOBIL_NO,USER_NAME");
            if ($linkman['MOBIL_NO'] != '') {
                if ($textareaInitValue == '') {
                    $textareaInitValue = $linkman['MOBIL_NO'] . " " . $linkman['USER_NAME'];
                } else {
                    $textareaInitValue = $textareaInitValue . "\\n" . $linkman['MOBIL_NO'] . " " . $linkman['USER_NAME'];
                }
<?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=?'>";
}
*/
//数据表模型文件,对应Model目录下面的v_sellplanmain_detail_newai.ini文件
//如果是需要复制此模块,则需要修改$parse_filename参数的值,然后对应到Model目录 新文件名_newai.ini文件
$SYSTEM_ADD_SQL = getCustomerRoleByCustID($SYSTEM_ADD_SQL, "supplyid");
addShortCutByDate("selltime", "创建时间");
$filetablename = 'v_sellplanmain_detail';
$parse_filename = 'v_sellplanmain_detail';
require_once 'include.inc.php';
Пример #12
0
<?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("供应商报价管理");
addShortCutByDate("pricedate", "报价日期");
$filetablename = "supplyproduct";
require_once "include.inc.php";
Пример #13
0
                $sql = "delete from sellplanmain_detail where mainrowid={$billid}";
                $db->Execute($sql);
                $sql = "update sellplanmain set user_flag=-1 where billid={$billid} and user_flag>-1";
                $rs = $db->Execute($sql);
                if ($rs === false) {
                    throw new Exception("不存在此记录");
                }
            }
        }
        $db->CompleteTrans();
        //是否事务出现错误
        page_css("");
        if ($db->HasFailedTrans()) {
            throw new Exception($db->ErrorMsg());
        } 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;
}
$realtablename = "sellplanmain";
addShortCutByDate("plandate", "有效期起始");
$SYSTEM_ADD_SQL = getCustomerRoleByCustID($SYSTEM_ADD_SQL, "supplyid");
$limitEditDelCust = 'supplyid';
$filetablename = "v_sellcontract";
$parse_filename = "sellcontract";
require_once "include.inc.php";
systemhelpcontent("销售合同", "100%");
Пример #14
0
                array_push($FILENAMEArray, $FILENAME);
            }
        }
        //$mail->AddAttachment('images/phpmailer_mini.gif'); // attachment
        $mail->Send();
        $_POST['SEND_FLAG'] = 1;
        while (list($key, $value) = each($FILENAMEArray)) {
            @unlink($value);
        }
    } catch (phpmailerException $e) {
        $error = $e->errorMessage();
        //Pretty error messages from PHPMailer
    } catch (Exception $e) {
        $error = $e->getMessage();
        //Boring error messages from anything else!
    }
    if ($error != '') {
        $error = str_replace("\n", '', $error);
        $error = str_replace("\r", '', $error);
        $error = preg_replace('/<[^>]+>/iU', '', $error);
        print "<script language=javascript>alert('邮件发送失败,原因:" . $error . "');history.back(-1);</script>";
        exit;
    }
}
addShortCutByDate("SEND_TIME", "发送时间");
$SYSTEM_ADD_SQL = $SYSTEM_ADD_SQL = getRoleByUser($SYSTEM_ADD_SQL, "FROM_ID");
//数据表模型文件,对应Model目录下面的email_newai.ini文件
//如果是需要复制此模块,则需要修改$parse_filename参数的值,然后对应到Model目录 新文件名_newai.ini文件
$filetablename = 'email';
$parse_filename = 'email';
require_once '../JXC/include.inc.php';
Пример #15
0
    $sql_today = getRoleByUser($sql_today, "fahuoren");
    $rs = $db->Execute($sql_today);
    $rs_today = $rs->fields['NUM'];
    if ($rs_today > 0) {
        echo "<br>发货单:<a href=../JXC/fahuodan_newai.php?action=init_default&desksearch=" . urlencode($today) . " target=_blank>" . number_format($rs_today, 0, '', ',') . "个</a>";
    }
    exit;
}
if ($_GET['action'] == "shenhe") {
    print "<script>location='crm_workreport_shenhe.php?id=" . $_GET['id'] . "';</script>";
    exit;
}
if ($_GET['action'] == "shenhe_finish") {
    page_css();
    $billid = $_GET['id'];
    $sql = "update workreport set state='已审核',shenheren='" . $_SESSION['LOGIN_USER_ID'] . "',shenhetime=now(),piyu='" . $_POST['piyu'] . "' where id='{$billid}'";
    $rs = $db->Execute($sql);
    $billinfo = returntablefield("workreport", "id", $billid, "createman,workdate");
    $touser = explode(",", $_POST["tixingren"]);
    $messagetitle = "工作报告";
    $guanlianid = $billid;
    newMessage($billinfo['createman'], $billinfo['workdate'] . "的工作报告已被审核", $messagetitle, '../CRM/workreport_newai.php?' . base64_encode('action=view_default&id=' . $guanlianid), $guanlianid);
    $return = FormPageAction("action", "init_default");
    print_infor("<b>审核通过</b>", 'trip', "location='?{$return}'", "?" . $return, 1);
    exit;
}
addShortCutByDate("workdate", "工作日期");
$filetablename = 'workreport';
$parse_filename = 'workreport';
$SYSTEM_ADD_SQL = getRoleByUser($SYSTEM_ADD_SQL, "createman");
require_once 'include.inc.php';
Пример #16
0
    exit;
}
if ($_GET['action'] == "delete_array") {
    $selectid = $_GET['selectid'];
    $selectid = explode(",", $selectid);
    for ($i = 0; $i < sizeof($selectid); $i++) {
        if ($selectid[$i] != "") {
            deleteMessage('客户联系提醒', $selectid[$i]);
            deleteCalendar('联系客户 ', $selectid[$i]);
        }
    }
}
function updateLastTrace($customerid)
{
    global $db;
    $sql = "select max(contacttime) as maxtime from crm_contact where customerid={$customerid}";
    $rs = $db->Execute($sql);
    $rs_a = $rs->GetArray();
    if ($rs_a[0]['maxtime'] != '') {
        $sql = "update customer set `lasttracetime`='" . $rs_a[0]['maxtime'] . "' where `rowid`=" . $customerid;
        $rs = $db->Execute($sql);
    }
}
addShortCutByDate("contacttime", "联系时间");
$SYSTEM_ADD_SQL = getCustomerRoleByCustID($SYSTEM_ADD_SQL, "customerid");
$limitEditDelCust = 'customerid';
//数据表模型文件,对应Model目录下面的crm_contact_newai.ini文件
//如果是需要复制此模块,则需要修改$parse_filename参数的值,然后对应到Model目录 新文件名_newai.ini文件
$filetablename = 'crm_contact';
$parse_filename = 'crm_contact';
require_once 'include.inc.php';
Пример #17
0
                    throw new Exception("不存在此记录");
                }
            }
        }
        $db->CompleteTrans();
        //是否事务出现错误
        page_css("");
        if ($db->HasFailedTrans()) {
            throw new Exception($db->ErrorMsg());
        } 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;
}
if ($_GET['action'] == "print_order") {
    @($global_config_ini_file = @parse_ini_file(DOCUMENT_ROOT . 'general/ERP/Interface/Framework/global_config.ini', true));
    $print_main_field_list = $global_config_ini_file['section']['sell_order_field_config'];
    $print_detail_field_list = $global_config_ini_file['section']['sell_order_detail_field_config'];
}
addShortCutByDate("plandate", "订单签订日期");
$SYSTEM_ADD_SQL = getCustomerRoleByCustID($SYSTEM_ADD_SQL, "supplyid");
$SYSTEM_ADD_SQL = $SYSTEM_ADD_SQL . " and billtype=2 ";
$limitEditDelCust = 'supplyid';
$filetablename = 'sellplanmain';
$parse_filename = 'sellplanmain';
require_once 'include.inc.php';
systemhelpcontent("销售订单", "100%");
    }
    $return = FormPageAction("action", "init_default");
    print_infor("<b>审核通过</b>", 'trip', "location='?{$return}'", "?" . $return, 1);
    exit;
}
if ($_POST['action'] == "FouJue") {
    page_css();
    $billid = $_GET['id'];
    $sql = "update crm_shenqingbaobei set state='3',shenheman='" . $_SESSION['LOGIN_USER_ID'] . "',shenhetime=now(),piyu='" . $_POST['piyu'] . "' where id='{$billid}'";
    $rs = $db->Execute($sql);
    $return = FormPageAction("action", "init_default");
    print_infor("<b>审核否决</b>", 'trip', "location='?{$return}'", "?" . $return, 1);
    exit;
}
if ($_GET['action'] == "edit_FouJue") {
    page_css();
    $billid = $_GET['id'];
    $sql = "update crm_shenqingbaobei set state='1',shenheman='',shenhetime=null,piyu='' where id='{$billid}'";
    $rs = $db->Execute($sql);
    deleteMessage("项目报备", $billid);
    $return = FormPageAction("action", "init_default");
    print_infor("<b>撤销审核</b>", 'trip', "location='?{$return}'", "?" . $return, 1);
    exit;
}
addShortCutByDate("createtime", "申请时间");
$SYSTEM_ADD_SQL = getCustomerRoleByCustID($SYSTEM_ADD_SQL, "customerid");
//数据表模型文件,对应Model目录下面的crm_shenqingbaobei_newai.ini文件
//如果是需要复制此模块,则需要修改$parse_filename参数的值,然后对应到Model目录 新文件名_newai.ini文件
$filetablename = 'crm_shenqingbaobei';
$parse_filename = 'crm_shenqingbaobei';
require_once 'include.inc.php';
Пример #19
0
        $return = FormPageAction("action", "init_default");
        print_infor("新增资金注入抽取单成功", 'trip', "location='?{$return}'", "?{$return}", 0);
    }
    $db->CompleteTrans();
    exit;
}
if ($_GET['action'] == "delete_array") {
    $selectid = $_GET['selectid'];
    $selectid = explode(",", $selectid);
    global $db;
    $CaiWu = new CaiWu($db);
    for ($i = 0; $i < sizeof($selectid); $i++) {
        if ($selectid[$i] != "") {
            $CaiWu->deleteBankZhuruAccount($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;
}
addShortCutByDate("opertime", "操作时间");
$filetablename = 'bankzhuru';
$parse_filename = 'bankzhuru';
require_once 'include.inc.php';
<?php

require_once 'lib.inc.php';
$GLOBAL_SESSION = returnsession();
$SYSTEM_PRIV_STOP = "1";
require_once "systemprivateinc.php";
//CheckSystemPrivate("后勤管理-公物维修-报修受理");
addShortCutByDate("报修时间");
$filetablename = 'wygl_baoxiuxinxi';
$parse_filename = 'wygl_baoxiuxinxi2';
require_once 'include.inc.php';
Пример #21
0
        print_infor("客户资料已删除", 'trip', "location='?{$return}'", "?{$return}", 0);
        exit;
    }
    for ($i = 0; $i < count($selectid); $i++) {
        if ($selectid[$i] != '') {
            $billid = returntablefield("sellplanmain", "supplyid", $selectid[$i], "billid");
            if ($billid != '') {
                $customername = returntablefield("customer", "rowid", $selectid[$i], "supplyname");
                print "<script language='javascript'>alert('" . $customername . " 存在合同或销售单记录,请先删除相关单据');window.history.back(-1);</script>";
                exit;
            }
        }
    }
}
if ($_GET['action'] == "addlinkman") {
    print "<script>location.href='linkman_newai.php?action=add_default&customerid=" . $_GET['ROWID'] . "';</script>";
    exit;
}
if ($_GET['action'] == "addcrmvisit") {
    print "<script>location.href='crm_contact_newai.php?action=add_default&customerid=" . $_GET['ROWID'] . "';</script>";
    exit;
}
$SYSTEM_ADD_SQL = getCustomerRoleByUser($SYSTEM_ADD_SQL, "sysuser");
$limitEditDelUser = '******';
addShortCutByDate("createdate", "创建时间");
//print_r($_SESSION);
//$SYSTEM_ADD_SQL = " and ((sysuser='******'LOGIN_USER_ID']."' and datascope=0) or datascope=1)";
//$SYSTEM_PRINT_SQL=1;
$filetablename = "customer";
require_once "include.inc.php";
systemhelpcontent("客户管理", "100%");