function customerbelong_add($fields, $i)
{
$userid = returntablefield("customer", "ROWID", $fields['value']['ROWID'], "sysuser");
if (ifHasRoleUser($userid) || $userid == "") {
global $db;
print "<TR><TD class=TableData noWrap>查看权限:</TD><TD class=TableData noWrap>\n";
$sql = "select * from customerbelong";
if ($_SESSION['LOGIN_USER_PRIV'] == '3' || $fields['value']['datascope'] == '') {
$sql .= " where id>0";
}
$rs = $db->Execute($sql);
$rs_a = $rs->GetArray();
$check = '';
if ($fields['value']['datascope'] == '') {
$fields['value']['datascope'] = 2;
}
for ($j = 0; $j < sizeof($rs_a); $j++) {
if ($rs_a[$j]['id'] == $fields['value']['datascope']) {
$check = 'checked';
} else {
$check = '';
}
print "<input type='radio' name='datascope' id='datascope' value='" . $rs_a[$j]['id'] . "' " . $check . " " . $readonly . ">" . $rs_a[$j]['name'];
}
print "</td></tr>";
} else {
print "<input type='hidden' name='datascope' id='datascope' value='" . $fields['value']['datascope'] . "'>";
}
}
function read_sms()
{
global $html_etc;
global $common_html;
global $sessionkey;
global $GLOBAL_SESSION;
global $SUNSHINE_USER_NAME_VAR;
global $SUNSHINE_USER_NICK_NAME_VAR;
global $db;
global $_GET;
global $POST;
global $GLOBAL_SESSION;
$USER_ID = $GLOBAL_SESSION[$SUNSHINE_USER_NAME_VAR];
$USER_NAME = $GLOBAL_SESSION[$SUNSHINE_USER_NICK_NAME_VAR];
$sql = "select * from sms where REMIND_FLAG=1 and TO_ID='{$USER_ID}' and delete_receive!=1 order by SEND_TIME DESC";
$rs = $db->execute($sql);
if ($rs->recordcount() <= 0) {
echo "<META HTTP-EQUIV=REFRESH CONTENT='0;URL=javascript:window.close()'>\n";
}
$SMS_ID = $rs->fields['SMS_ID'];
$FROM_ID = $rs->fields['FROM_ID'];
$SEND_TIME = $rs->fields['SEND_TIME'];
$CONTENT = $rs->fields['CONTENT'];
$FROM_NAME = returntablefield("user", "USER_NAME", $FROM_ID, "NICK_NAME");
$FROM_ID = $rs->fields['FROM_ID'];
require_once "../Enginee/lib/html/readsms.html";
}
function fahuodanrefer_value($fieldvalue, $fields, $i)
{
$value = $fieldvalue;
$color = setColorByName($value);
$outtype = returntablefield("fahuodan", "billid", $fields['value'][$i]['billid'], "outtype");
if ($outtype == "销售出库") {
$billinfo = returntablefield("sellplanmain", "billid", $fieldvalue, "billtype,zhuti");
$billtype = $billinfo['billtype'];
$title = $billinfo['zhuti'];
if ($billtype == '1') {
$url = "sellcontract_newai.php";
} else {
if ($billtype == '2') {
$url = "sellplanmain_newai.php";
} else {
if ($billtype == '3') {
$url = "sellonemain_newai.php";
}
}
}
$fieldvalue = "<a style='color:{$color}' href='{$url}?" . base64_encode("action=view_default&billid=" . $fieldvalue) . "' target='_blank'>" . $title . "</a>";
} else {
if ($outtype == '返厂出库') {
$title = returntablefield("buyplanmain", "billid", $fieldvalue, "zhuti");
$fieldvalue = "<a style='color:{$color}' href='buyplanmain_newai.php?" . base64_encode("action=view_default&billid={$fieldvalue}") . "' target='_blank'>{$title}</a>";
}
}
return $fieldvalue;
}
function CustomerKaiPiao_add($fields, $i)
{
global $db, $_SESSION, $common_html;
$notnull = trim($fields['null'][$i]['inputtype']);
$notnull == 'notnull' ? $notnulltext = $common_html['common_html']['mustinput'] : ($notnulltext = '');
$fieldname1 = $fields['name'][$i];
$fieldname2 = $fields['input'][$i][0];
$j = array_search($fieldname2, $fields['name'], true);
$notnull = trim($fields['null'][$j]['inputtype']);
$notnull == 'notnull' ? $notnulltext1 = $common_html['common_html']['mustinput'] : ($notnulltext1 = '');
$class = "SmallSelect";
print "<script language=javascript>\nvar xmlHttp1; \nfunction createxmlHttp1_buysellbill() {\n if (window.xmlHttp1Request) {\n xmlHttp1 = new xmlHttpRequest(); \n } else {\n xmlHttp1 = new ActiveXObject(\"Microsoft.xmlHttp\");\n }\n}\nfunction sendRequest(action,params) {\n createxmlHttp1_buysellbill(); \n xmlHttp1.onreadystatechange =function() {showCartInfo(action)}; \n xmlHttp1.open(\"GET\", \"getLinkmanBycustomer.php?action=\"+action+\"&\" + params, false);\n xmlHttp1.send(null);\n}\nfunction showCartInfo(action) {\n if (xmlHttp1.readyState == 4) {\n \t\n if(xmlHttp1.responseText.indexOf(\"root\")==-1)\n \t{\n\t\t\t\talert(xmlHttp1.responseText);\n\t\t\t\treturn false;\n \t}\n \t\tvar doc = new ActiveXObject(\"MSxml2.DOMDocument\");\n \t\t \tdoc.loadXML(xmlHttp1.responseText);\n\t\t\t\n\t\t\tvar rootnode = doc.getElementsByTagName(\"root\")[0];\n \t\t \t\n \t\t \tif(action=='billinfo')\n \t\t \t{\n \t\t \t\t//alert(xmlHttp1.responseText);\n \t\t \t\tvar detailnode = doc.getElementsByTagName(\"billinfo\")[0];\n \t\t \t\tvar totalmoney=0;\n \t\t \t\tvar huikuanjine=0;\n \t\t \t\tvar kaipiaojine=0;\n \t\t \t\tvar quling=0;\n \t\t \t\t\n \t\t \t\tif(detailnode.childNodes[0].childNodes[0]!=null)\n\t\t\t\t \ttotalmoney=detailnode.childNodes[0].childNodes[0].nodeValue;\n\t\t\t\tif(detailnode.childNodes[1].childNodes[0]!=null) \n\t\t\t\t \thuikuanjine=detailnode.childNodes[1].childNodes[0].nodeValue;\n\t\t\t\tif(detailnode.childNodes[2].childNodes[0]!=null)\n\t\t\t\t \tkaipiaojine=detailnode.childNodes[2].childNodes[0].nodeValue;\n \t\t \t\tif(detailnode.childNodes[3].childNodes[0]!=null)\n\t\t\t\t \tquling=detailnode.childNodes[3].childNodes[0].nodeValue;\n\t\t\t\t \t \t\t \t\t\n \t\t \t\tdocument.getElementById('totalmoney').innerText=totalmoney;\n \t\t \t\tdocument.getElementById('quling').innerText=quling;\n \t\t \t\tdocument.getElementById('huikuanjine').innerText=huikuanjine;\n \t\t \t\tdocument.getElementById('kaipiaojine').innerText=kaipiaojine;\n \t\t \t\tform1.piaojujine.value=delFormat(totalmoney)-delFormat(kaipiaojine);\n \t\t \t}\n \t\t \tif(action=='kaipiao')\n \t\t \t{\n \t\t \t\t//alert(xmlHttp1.responseText);\n \t\t \t\tvar yuchuzhi=rootnode.childNodes[0].nodeValue;\n \t\t \t\tdocument.getElementById('yuchuzhi').innerText=yuchuzhi+' 元';\n \t\t \t\tvar detailnode = doc.getElementsByTagName(\"sellbuy\")[0];\n\t\t\t\tvar subcat = new Array();\n\t\t\t\tvar i=0;\n\t\t\t\n\t\t\t\t\n\t\t\t\twhile(detailnode!=null && detailnode.nodeName=='sellbuy')\n\t\t\t\t{\n\t\t\t\t\t\n\t\t\t\t\t\tsubcat[i]=new Array();\n\t\t\t\t\t\tvar rowid=detailnode.childNodes[0].childNodes[0].nodeValue;\n\t\t\t\t\t\tvar zhuti=detailnode.childNodes[1].childNodes[0].nodeValue;\n\t\t\t\t\t\tsubcat[i][0]=rowid;\n\t\t\t\t\t\tsubcat[i][1]=zhuti;\n\t\t\t\t\t\tdocument.form1.{$fieldname2}.options[document.form1.{$fieldname2}.length] = new Option(zhuti, rowid);\n\t\t\t\t\t\tif(rowid=='" . $fields['value'][$fieldname2] . "')\n\t\t\t\t\t\t\tdocument.form1.{$fieldname2}.options[document.form1.{$fieldname2}.length-1].selected=true;\n\t\t\t\t\t\ti++;\n\t\t\t\t\t\tdetailnode=detailnode.nextSibling;\n\t\t\t\t}\n\t\t\t}\n\t\t\t\n }\n};\nfunction changelocation(locationid)\n{\n\tdocument.form1.{$fieldname2}.length = 0;\n\tif(locationid!='')\n\t{\n \tsendRequest('kaipiao','customerid='+locationid);\n \tgetPayType(document.form1.{$fieldname2}.value);\n \t\n }\n\t\n}\nfunction getPayType(billid)\n{\n \tsendRequest('billinfo','billid='+billid);\n}\n\n";
if ($fields['value'][$fieldname1] != '') {
print "window.onload=function(){\n\tchangelocation(" . $fields['value'][$fieldname1] . ");\n\t}\n\t";
}
print "\n</SCRIPT>\n";
print "<TR><TD class=TableData noWrap>客户:</TD><TD class=TableData noWrap>\n";
$customername = returntablefield("customer", "rowid", $fields['value'][$fieldname1], "supplyname");
print "<input type='hidden' name='{$fieldname1}' value='" . $fields['value'][$fieldname1] . "' >";
print "<input type='text' name='" . $fieldname1 . "_ID' value='" . $customername . "' readonly class='SmallStatic' size='30'>";
print " <input type=\"button\" title='' value=\"选择\" class=\"SmallButton\" onClick=\"var oldid=" . $fieldname1 . "_ID.value; SelectAllInforSingle('../../Enginee/Module/kehu_select_single/index.php','','" . $fieldname1 . "_ID', '{$fieldname1}');if(oldid!=" . $fieldname1 . "_ID.value){changelocation(" . $fieldname1 . ".value)};\" > ";
print "</SELECT> {$notnulltext}</TD></TR>\n";
print "<TR><TD class=TableData noWrap>预储值:</TD><TD class=TableData noWrap><div id='yuchuzhi'></div></TD></TR>\n";
print "<TR><TD class=TableData noWrap>合同订单:</TD><TD class=TableData noWrap>\n";
print "<SELECT onkeydown=\"if(event.keyCode==13)event.keyCode=9\" class=\"{$class}\" \n";
print "size=1 name='" . $fieldname2 . "' onchange=\"getPayType(this.value);\"></SELECT> {$notnulltext1}</TD></TR>\n";
print "<TR><TD class=TableData noWrap>总金额:</TD><TD class=TableData noWrap><div id='totalmoney'></div></TD></TR>\n";
print "<TR><TD class=TableData noWrap>去零:</TD><TD class=TableData noWrap><div id='quling'></div></TD></TR>\n";
print "<TR><TD class=TableData noWrap>已回款金额:</TD><TD class=TableData noWrap><div id='huikuanjine'></div></TD></TR>\n";
print "<TR><TD class=TableData noWrap>已开票金额:</TD><TD class=TableData noWrap><div id='kaipiaojine'></div></TD></TR>\n";
}
function kucuninit_value_PRIV($fieldvalue, $fields, $i)
{
global $db;
global $tablename;
global $html_etc;
global $common_html;
$SYSTEM_STOP_ROW['shenhe_priv'] = 1;
$SYSTEM_STOP_ROW['flow_priv'] = 1;
$SYSTEM_STOP_ROW['delete_priv'] = 1;
$SYSTEM_STOP_ROW['edit_priv'] = 1;
$storeid = $fields['value'][$i]['ROWID'];
$sql = "select * from store_init where storeid={$storeid} and flag=1";
$rs = $db->Execute($sql);
$rs_a = $rs->GetArray();
$sql = "select * from store where storeid={$storeid}";
$rs = $db->Execute($sql);
$rs_b = $rs->GetArray();
$userid = returntablefield("stock", "rowid", $storeid, "user_id");
$useridArray = explode(",", $userid);
if (sizeof($rs_a) == 0 && sizeof($rs_b) == 0 && in_array($_SESSION['LOGIN_USER_ID'], $useridArray)) {
$SYSTEM_STOP_ROW['shenhe_priv'] = 0;
}
if (sizeof($rs_a) > 0) {
$SYSTEM_STOP_ROW['flow_priv'] = 0;
}
return $SYSTEM_STOP_ROW;
}
function banzuchengyuan_add($fields, $i)
{
$组员名称 = $fields['value']['组员名称'];
$组员名称Array = explode(',', $组员名称);
for ($i = 0; $i < sizeof($组员名称Array); $i++) {
$组员名称TEXT = $组员名称Array[$i];
if ($组员名称TEXT != "") {
$USER_NAME_TEXT .= returntablefield("user", "USER_ID", $组员名称TEXT, "USER_NAME") . ",";
$USER_ID_TEXT .= $组员名称TEXT . ",";
}
if ($USER_NAME_TEXT == "") {
$USER_ID_TEXT .= returntablefield("user", "USER_NAME", $组员名称TEXT, "USER_ID") . ",";
$USER_NAME_TEXT .= $组员名称TEXT . ",";
}
}
//print $USER_ID_TEXT;
//print $USER_NAME_TEXT;
if ($USER_ID_TEXT == ",") {
$USER_ID_TEXT = '';
}
if ($USER_NAME_TEXT == ",") {
$USER_NAME_TEXT = '';
}
print "<tr>\n\t\t <td nowrap class='TableData' align='center'>授权范围：<br>（人员）</td>\n\t\t <td class='TableData' colspan=2>\n\t\t\t<input type='hidden' name='COPY_TO_ID' value='{$USER_ID_TEXT}'>\n\t\t\t<textarea cols=40 name='COPY_TO_NAME' rows=6 class='BigStatic' wrap='yes' readonly>" . $USER_NAME_TEXT . "</textarea>\n\t\t\t <input type='button' value='添 加' class='SmallButton' onClick=\"SelectUser('','COPY_TO_ID','COPY_TO_NAME')\" title='选择人员' name='button'>\n\t\t\t <input type='button' value='清 空' class='SmallButton' onClick=\"ClearUser('COPY_TO_ID','COPY_TO_NAME')\" title='清空人员' name='button'>\n\t\t </td>\n\t </tr>";
}
function baoBeiShenHe_value_PRIV($fieldvalue, $fields, $i)
{
//print_R($fields['value'][$i]);
$userinfo = returntablefield("user", "user_id", $fields['value'][$i]['createman'], "user_id,dept_id,user_priv");
$userid = $userinfo['user_id'];
$deptid = $userinfo['dept_id'];
$userpriv = $userinfo['user_priv'];
$SYSTEM_STOP_ROW['edit_priv'] = 1;
$SYSTEM_STOP_ROW['delete_priv'] = 1;
$SYSTEM_STOP_ROW['shenhe_priv'] = 1;
$SYSTEM_STOP_ROW['flow_priv'] = 1;
if ($fields['value'][$i]['state'] == 1) {
if ($userid == $_SESSION['LOGIN_USER_ID']) {
$SYSTEM_STOP_ROW['edit_priv'] = 0;
$SYSTEM_STOP_ROW['delete_priv'] = 0;
}
}
if ($_SESSION['LOGIN_USER_PRIV'] == '1' || $deptid == $_SESSION['LOGIN_DEPT_ID'] && $_SESSION['LOGIN_USER_PRIV'] < $userpriv) {
if ($fields['value'][$i]['state'] == 1) {
$SYSTEM_STOP_ROW['shenhe_priv'] = 0;
} else {
$SYSTEM_STOP_ROW['flow_priv'] = 0;
}
}
return $SYSTEM_STOP_ROW;
}
function callchuli_view($fields, $i)
{
$uniturl = '';
$fieldvalue = $fields['value']['customer'];
if ($fields['value']['callertype'] == '客户') {
$uniturl = "<a href='customer_newai.php?" . base64_encode("action=view_default&ROWID=" . $fields['value']['customerid']) . "' target='_blank'>" . $fieldvalue . "</a>";
} else {
if ($fields['value']['callertype'] == '供应商') {
$uniturl = "<a href='supply_newai.php?" . base64_encode("action=view_default&ROWID=" . $fields['value']['customerid']) . "' target='_blank'>" . $fieldvalue . "</a>";
} else {
$customerid = returntablefield("customer", "supplyname", $fieldvalue, "rowid");
if ($customerid != '') {
$uniturl = "<a href='customer_newai.php?" . base64_encode("action=view_default&ROWID=" . $customerid) . "' target='_blank'>" . $fieldvalue . "</a>";
}
}
}
if ($uniturl != '') {
$fieldvalue = $uniturl;
} else {
$tel = returntablefield("callchuli", "id", $fields['value']['id'], "tel");
$fieldvalue .= " <a href='customer_newai.php?" . base64_encode("action=add_default&supplyname=" . $fieldvalue . "&phone=" . $tel) . "' target='_blank'><img src='../Framework/images/notify_new.gif' title='创建客户'></a>";
}
$Text = "<TR><TD class=TableContent noWrap>" . $fields['null'][$i]['inputtext'] . ":</TD><td class=TableData noWrap>{$fieldvalue}</td></tr>";
return $Text;
}
function productzuzhuangstate_value_PRIV($fieldvalue, $fields, $i)
{
global $db;
global $tablename;
global $html_etc;
global $common_html;
$SYSTEM_STOP_ROW['shenhe_priv'] = 1;
$SYSTEM_STOP_ROW['flow_priv'] = 1;
$SYSTEM_STOP_ROW['delete_priv'] = 1;
$SYSTEM_STOP_ROW['edit_priv'] = 1;
switch ($fieldvalue) {
case "1":
$storeid = returntablefield("productzuzhuang", "billid", $fields['value'][$i]['billid'], "outstoreid");
$userid = returntablefield("stock", "rowid", $storeid, "user_id");
$useridArray = explode(",", $userid);
if (in_array($_SESSION['LOGIN_USER_ID'], $useridArray)) {
$SYSTEM_STOP_ROW['flow_priv'] = 0;
$SYSTEM_STOP_ROW['delete_priv'] = 0;
$SYSTEM_STOP_ROW['edit_priv'] = 0;
}
break;
case "2":
$storeid = returntablefield("productzuzhuang", "billid", $fields['value'][$i]['billid'], "instoreid");
$userid = returntablefield("stock", "rowid", $storeid, "user_id");
$useridArray = explode(",", $userid);
if (in_array($_SESSION['LOGIN_USER_ID'], $useridArray)) {
$SYSTEM_STOP_ROW['shenhe_priv'] = 0;
}
break;
case "3":
break;
}
return $SYSTEM_STOP_ROW;
}
function feiyongclasstype_add($fields, $i)
{
global $db, $_SESSION, $common_html;
$notnull = trim($fields['null'][$i]['inputtype']);
$notnull == 'notnull' ? $notnulltext = $common_html['common_html']['mustinput'] : ($notnulltext = '');
$fieldname1 = $fields['name'][$i];
$kind = $fields['input'][$i][0];
$class = "SmallSelect";
$classid = returntablefield("feiyongtype", "id", $fields['value'][$fieldname1], "classid");
print "<script type=\"text/javascript\" language=\"javascript\" src=\"" . ROOT_DIR . "general/ERP/Enginee/jquery/jquery.js\"></script>";
print "<script language=javascript>\nvar \$\$ = jQuery.noConflict();\nfunction sendRequest(action,params) {\n\n \n \$\$.ajax({ \n\t\t type:'GET', \n\t\t url:'getLinkmanBycustomer.php?action='+action+'&' + params, \n\t\t dataType: 'xml', \n\t\t cache:false,\n\t\t success:function(data) \n\t\t { \n\t\t \n \t\t \t\t\n\t \t\t \t \$\$(data).find('feiyongtype').each(function() {\n \t\t\n\t\t\t\t\t\tvar rowid=\$\$(this).find('id').text();\n\t\t\t\t\t\tvar zhuti=\$\$(this).find('typename').text();\n\n\t\t\t\t\t\tdocument.form1.{$fieldname1}.options[document.form1.{$fieldname1}.length] = new Option(zhuti, rowid);\n\t\t\t\t\t\tif(rowid=='" . $fields['value'][$fieldname1] . "')\n\t\t\t\t\t\t\tdocument.form1.{$fieldname1}.options[document.form1.{$fieldname1}.length-1].selected=true;\n\t\t\t\t\t\n });\t\t\t\t\n\t\t },\n\t\t error:function(XmlHttpRequest,textStatus, errorThrown)\n\t {\n\t\t\t var errorPage = XmlHttpRequest.responseText; \n\t\t\t alert('获取子类出错：'+errorThrown);\n\t }\n\t});\n}\nfunction showCartInfo(action) {\n if (xmlHttp.readyState == 4) {\n \t\n if(xmlHttp.responseText.indexOf(\"root\")==-1)\n \t{\n\t\t\t\talert(xmlHttp.responseText);\n\t\t\t\treturn false;\n \t}\n \t\tvar doc = new ActiveXObject(\"MSxml2.DOMDocument\");\n \t\t \tdoc.loadXML(xmlHttp.responseText);\n \t\t \tvar rootnode = doc.getElementsByTagName(\"root\")[0];\n\t\t\t\n\t\t\tif(action!='')\n \t\t \t{\n\t \t\t \tvar detailnode = doc.getElementsByTagName(\"feiyongtype\")[0];\n\t\t\t\tvar subcat = new Array();\n\t\t\t\tvar i=0;\n\t\t\t\twhile(detailnode!=null)\n\t\t\t\t{\n\t\t\t\t\t\tsubcat[i]=new Array();\n\t\t\t\t\t\tvar id=detailnode.childNodes[0].childNodes[0].nodeValue;\n\t\t\t\t\t\tvar typename=detailnode.childNodes[1].childNodes[0].nodeValue;\n\t\t\t\t\t\t\n\t\t\t\t\t\tsubcat[i][0]=id;\n\t\t\t\t\t\tsubcat[i][1]=typename;\n\t\t\t\t\t\t\n\t\t\t\t\t\tdocument.form1.{$fieldname1}.options[document.form1.{$fieldname1}.length] = new Option(typename, id);\n\t\t\t\t\t\tif(id=='" . $fields['value'][$fieldname1] . "')\n\t\t\t\t\t\t\tdocument.form1.{$fieldname1}.options[document.form1.{$fieldname1}.length-1].selected=true;\n\t\t\t\t\t\ti++;\n\t\t\t\t\t\tdetailnode=detailnode.nextSibling;\n\t\t\t\t}\n\t\t\t}\n\t\t\t\n }\n}\n\nfunction changelocation(locationid)\n{\n\n\tdocument.form1.{$fieldname1}.length = 0;\t\n\tif(locationid!='')\n\t sendRequest('feiyongtype','classid='+locationid);\n}\nwindow.onload=function (){\n\tchangelocation(form1.classid.value);\n\t}\n";
print "\n</SCRIPT>\n";
print "<TR><TD class=TableData noWrap>大类:</TD><TD class=TableData noWrap>\n";
print "<select name='classid' onkeydown=\"if(event.keyCode==13)event.keyCode=9\" onchange=changelocation(this.value);>";
$sql = "select * from feiyongclass where kind={$kind}";
$rs = $db->Execute($sql);
$rs_a = $rs->GetArray();
$selected = '';
for ($i = 0; $i < count($rs_a); $i++) {
if ($rs_a[$i]['id'] == $classid) {
$selected = 'selected';
} else {
$selected = '';
}
print "<option {$selected} value='" . $rs_a[$i]['id'] . "'>" . $rs_a[$i]['classname'] . "</option>";
}
print "</select></TD></TR>\n";
print "<TR><TD class=TableData noWrap>子类:</TD><TD class=TableData noWrap>\n";
print "<SELECT name={$fieldname1} class=\"{$class}\" onkeydown=\"if(event.keyCode==13)event.keyCode=9\">\n";
print "</SELECT> {$notnulltext}</TD></TR>\n";
print "<input type='hidden' name='kind' value='{$kind}'>";
}
function storecheck_value_PRIV($fieldvalue, $fields, $i)
{
global $db;
$storeid = returntablefield("storecheck", "billid", $fields['value'][$i]['billid'], "storeid");
$userid = returntablefield("stock", "rowid", $storeid, "user_id");
$useridArray = explode(",", $userid);
$SYSTEM_STOP_ROW['flow_priv'] = 1;
$SYSTEM_STOP_ROW['delete_priv'] = 1;
$SYSTEM_STOP_ROW['edit_priv'] = 1;
switch ($fieldvalue) {
case "盘点中":
$color = "red";
if (in_array($_SESSION['LOGIN_USER_ID'], $useridArray)) {
$SYSTEM_STOP_ROW['flow_priv'] = 0;
$SYSTEM_STOP_ROW['edit_priv'] = 0;
$SYSTEM_STOP_ROW['delete_priv'] = 0;
}
break;
case "盘点结束":
$color = "green";
if (in_array($_SESSION['LOGIN_USER_ID'], $useridArray)) {
$SYSTEM_STOP_ROW['delete_priv'] = 0;
}
}
return $SYSTEM_STOP_ROW;
}
function deptment_value_PRIV($fieldvalue, $fields, $i)
{
global $db;
global $tablename;
global $html_etc;
global $common_html;
//print_R($fields['value'][$i]);
$FieldValue = $fields['value'][$i]['DEPT_ID'];
$tableNo = returntablefield("department", "DEPT_PARENT", $FieldValue, "DEPT_PARENT");
if ($tableNo != '') {
$flag = 1;
}
$tableNo = returntablefield("user", "DEPT_ID", $FieldValue, "DEPT_ID");
if ($tableNo != '') {
$flag = 1;
}
//$tablecode = $fields['value'][$i]['tablecode'];
//$tableNo = returntablefield( "stockoutmain", "tablecode", $tablecode, "tableNo" );
if ($flag == 1) {
$SYSTEM_STOP_ROW['delete_priv'] = 1;
} else {
$SYSTEM_STOP_ROW['delete_priv'] = 0;
}
$SYSTEM_STOP_ROW['edit_priv'] = 0;
return $SYSTEM_STOP_ROW;
}
function CustomerFuKuan_add($fields, $i)
{
global $db, $_SESSION, $common_html;
$notnull = trim($fields['null'][$i]['inputtype']);
$notnull == 'notnull' ? $notnulltext = $common_html['common_html']['mustinput'] : ($notnulltext = '');
$fieldname1 = $fields['name'][$i];
$fieldname2 = $fields['input'][$i][0];
$j = array_search($fieldname2, $fields['name'], true);
$notnull = trim($fields['null'][$j]['inputtype']);
$notnull == 'notnull' ? $notnulltext1 = $common_html['common_html']['mustinput'] : ($notnulltext1 = '');
$action = $fields['input'][$i][1];
$class = "SmallSelect";
print "<script type=\"text/javascript\" language=\"javascript\" src=\"" . ROOT_DIR . "general/ERP/Enginee/jquery/jquery.js\"></script>";
print "<script language=javascript>\n\n\$(document).ready(function (){\t\n\t\n\tif(document.form1.accountid)\n\t\tdocument.form1.accountid.options[document.form1.accountid.length] = new Option('预付款支付', '0');";
if ($fields['value'][$fieldname1] != '') {
print "changelocation(" . $fields['value'][$fieldname1] . ");\n\t\t getPayType(" . $fields['value'][$fieldname2] . ");";
}
print "});\nfunction changelocation(locationid)\n{\n\tdocument.form1.{$fieldname2}.length = 0;\n\tif(locationid!='')\n\t{\n \tsendRequest('{$action}','customerid='+locationid);\n \tgetPayType(document.form1.{$fieldname2}.value);\n \t\n }\n\t\n}\nfunction getPayType(billid)\n{\n \tsendRequest('caigouinfo','billid='+billid);\n}\nvar totalmoney=0;\nvar huikuanjine=0;\nvar kaipiaojine=0;\nvar quling=0; \nfunction sendRequest(action,params) {\n\$.ajax({ \n\t\t type:'GET', \n\t\t url:'getLinkmanBycustomer.php?action='+action+'&'+params, \n\t\t dataType: 'xml', \n\t\t cache:false,\n\t\t async: false,\n\t\t success:function(data) \n\t\t { \n\t\t \tif(action=='fukuan' || action=='shoupiao')\n \t\t \t{\n \t\t\n\t\t \t";
print "var yuchuzhi=\$(data).find('chuzhi').text();\n \t\t \t\t\t\$('#yuchuzhi').text(yuchuzhi+' 元');\n\n \t\t \t\t \$(data).find('sellbuy').each(function(i) {\n \t\n\t\t\t\t\t\tvar rowid=\$(this).children('rowid').text();\n\t\t\t\t\t\tvar zhuti=\$(this).children('zhuti').text();\n\t\t\t\t\t\t\n\t\t\t\t\t\t\n\t\t\t\t\t\t\n\t\t\t\t\t\tdocument.form1.{$fieldname2}.options[document.form1.{$fieldname2}.length] = new Option(zhuti, rowid);\n\t\t\t\t\t\tif(rowid=='" . $fields['value'][$fieldname2] . "')\n\t\t\t\t\t\t\tdocument.form1.{$fieldname2}.options[document.form1.{$fieldname2}.length-1].selected=true;\n\t\t\t\t\t\ti++;\n });\t\n \t\t \t}\n \t\t \tif(action=='caigouinfo')\n \t\t \t{\n \t\t\n\t\t\t\t\$(data).find('caigouinfo').each(function(i) {\n\t\t\t\t\tif(\$(this).children('totalmoney')!=null)\n\t\t\t\t\t \ttotalmoney=\$(this).children('totalmoney').text();\n\t\t\t\t\tif(\$(this).children('paymoney')!=null) \n\t\t\t\t\t \thuikuanjine=\$(this).children('paymoney').text();\n\t\t\t\t\tif(\$(this).children('shoupiaomoney')!=null)\n\t\t\t\t\t \tkaipiaojine=\$(this).children('shoupiaomoney').text();\n\t \t\t \t\tif(\$(this).children('oddment')!=null)\n\t\t\t\t\t \tquling=\$(this).children('oddment').text(); \t\n\t\t\t\t\t \t\t\n\t \t\t \t\t\$('#totalmoney').text(totalmoney);\n\t \t\t \t\t\$('#paymoney').text(huikuanjine);\n\t \t\t \t\t\$('#shoupiaomoney').text(kaipiaojine);\n\t \t\t \t\t\$('#oddment').text(quling);\n\t \t\t \t\tif(form1.jine!=null)\n\t \t\t \t\t\tform1.jine.value=delFormat(totalmoney)-delFormat(huikuanjine)-delFormat(quling);\n\t \t\t \t\tif(form1.piaojujine!=null)\n\t \t\t \t\t\tform1.piaojujine.value=delFormat(totalmoney)-delFormat(kaipiaojine);\n\t \t\t \t\tif(form1.oddment!=null)\n\t \t\t \t\t\tform1.oddment.value=0;\n \t\t \t\t});\t\n \t\t \t}\n\t \t\t \t\t\t\t\n\t\t },\n\t\t error:function(XmlHttpRequest,textStatus, errorThrown)\n\t {\n\t\t\t var errorPage = XmlHttpRequest.responseText; \n\t\t\t alert('获取采购单出错：'+errorThrown);\n\t }\n\t});\n\n}\n\n</SCRIPT>\n";
print "<TR><TD class=TableData noWrap>供应商:</TD><TD class=TableData noWrap>\n";
$supplyname = returntablefield("supply", "rowid", $fields['value'][$fieldname1], "supplyname");
$fieldnameID = $fieldname1 . "_ID";
print "<input type=\"hidden\" name=\"{$fieldname1}\" value=\"" . $fields['value'][$fieldname1] . "\" onchange='changelocation(this.value);'>";
print "<input name=\"" . $fieldnameID . "\" value=\"" . $supplyname . "\" class=\"SmallStatic\" readonly size=30> \n";
print "<input type=\"button\" title='' value=\"选择\" class=\"SmallButton\" onClick=\"SelectAllInforSingle('../../Enginee/Module/supply_select_single/index.php','','{$fieldnameID}', '{$fieldname1}');\" > {$notnulltext}";
print "<TR><TD class=TableData noWrap>预付款:</TD><TD class=TableData noWrap><div id='yuchuzhi'></div></TD></TR>\n";
print "<TR><TD class=TableData noWrap>采购单:</TD><TD class=TableData noWrap>\n";
print "<SELECT onkeydown=\"if(event.keyCode==13)event.keyCode=9\" class=\"{$class}\" \n";
print "size=1 name='" . $fieldname2 . "' onchange=\"getPayType(this.value);\"></SELECT> {$notnulltext1}</TD></TR>\n";
print "<TR><TD class=TableData noWrap>总金额:</TD><TD class=TableData noWrap><div id='totalmoney'></div></TD></TR>\n";
print "<TR><TD class=TableData noWrap>已去零:</TD><TD class=TableData noWrap><div id='oddment'></div></TD></TR>\n";
print "<TR><TD class=TableData noWrap>已付款金额:</TD><TD class=TableData noWrap><div id='paymoney'></div></TD></TR>\n";
print "<TR><TD class=TableData noWrap>已收票金额:</TD><TD class=TableData noWrap><div id='shoupiaomoney'></div></TD></TR>\n";
}
function JiaoFuPriv_value($fieldvalue, $fields, $i)
{
$zhuti = returntablefield("sellplanmain", "billid", $fieldvalue, "zhuti");
$user_flag = returntablefield("sellplanmain", "billid", $fieldvalue, "user_flag");
$img = "";
$title = '';
if ($user_flag == "1") {
$img = "proc.gif";
$title = '执行中';
} else {
if ($user_flag == "2") {
$img = "over.gif";
$title = '完成';
} else {
if ($user_flag == "0") {
$img = "time.gif";
$title = '临时单';
} else {
if ($user_flag == "-1") {
$img = "exit.gif";
$title = '临时单';
}
}
}
}
return "<a href='sellcontract_newai.php?" . base64_encode("action=view_default&billid=" . $fieldvalue) . "' target='_blank'>" . $zhuti . "</a><img src='../../Framework/images/" . $img . "' title='{$title}'>";
}
function workplanstate_value_PRIV($fieldvalue, $fields, $i)
{
$userinfo = returntablefield("user", "user_id", $fields['value2'][$i]['createman'], "user_id,dept_id,user_priv");
$userid = $userinfo['user_id'];
$deptid = $userinfo['dept_id'];
$userpriv = $userinfo['user_priv'];
$SYSTEM_STOP_ROW['edit_priv'] = 1;
$SYSTEM_STOP_ROW['delete_priv'] = 1;
$SYSTEM_STOP_ROW['shenhe_priv'] = 1;
$SYSTEM_STOP_ROW['flow_priv'] = 1;
if ($userid == $_SESSION['LOGIN_USER_ID']) {
$detailid = returntablefield("workplanmain_detail", "mainrowid", $fields['value'][$i]['id'], "id");
if ($detailid == '') {
$SYSTEM_STOP_ROW['edit_priv'] = 0;
}
$SYSTEM_STOP_ROW['delete_priv'] = 0;
if ($fields['value2'][$i]['state'] == 2) {
$SYSTEM_STOP_ROW['shenhe_priv'] = 0;
}
}
if ($fields['value2'][$i]['shenchastate'] != '') {
$SYSTEM_STOP_ROW['shenhe_priv'] = 1;
$SYSTEM_STOP_ROW['delete_priv'] = 1;
}
$zhixingrenArray = explode(",", $fields['value'][$i]['zhixingren']);
if (in_array($_SESSION['LOGIN_USER_ID'], $zhixingrenArray) && $fields['value2'][$i]['state'] < 2) {
$SYSTEM_STOP_ROW['flow_priv'] = 0;
}
return $SYSTEM_STOP_ROW;
}
function SupplyLinkmanPriv_add($fields, $i)
{
global $db, $_SESSION, $common_html;
$notnull = trim($fields['null'][$i]['inputtype']);
$notnull == 'notnull' ? $notnulltext = $common_html['common_html']['mustinput'] : ($notnulltext = '');
$fieldname1 = $fields['name'][$i];
$fieldname2 = $fields['input'][$i][0];
$j = array_search($fieldname2, $fields['name'], true);
$notnull = trim($fields['null'][$j]['inputtype']);
$notnull == 'notnull' ? $notnulltext1 = $common_html['common_html']['mustinput'] : ($notnulltext1 = '');
$class = "SmallSelect";
print "<script type=\"text/javascript\" language=\"javascript\" src=\"" . ROOT_DIR . "general/ERP/Enginee/jquery/jquery.js\"></script>";
print "<script language=javascript>\nfunction changelocation1(locationid)\n{\n\n\tdocument.form1.{$fieldname2}.length = 0;\n sendRequest_supplylinkman('customerid='+locationid);\n}\nvar \$\$ = jQuery.noConflict();\nfunction sendRequest_supplylinkman(params) \n{\n\n \$\$.ajax({ \n\t\t type:'GET', \n\t\t url:'getLinkmanBycustomer.php?action=supply&'+params, \n\t\t dataType: 'xml', \n\t\t cache:false,\n\t\t success:function(data) \n\t\t { \n\t\t \t\n\t\t \tvar yuchuzhi=\$\$(data).find('chuzhi').text();\n\t\t \t\$\$('#yuchuzhi').html(yuchuzhi+' 元');";
if ($notnulltext1 == '') {
print "document.form1.{$fieldname2}.options[document.form1.{$fieldname2}.length] = new Option('','');";
}
print "\n \t\t \t\t\n\t \t\t \t \$\$(data).find('supply').each(function() {\n \t\t\n\t\t\t\t\t\tvar rowid=\$\$(this).find('rowid').text();\n\t\t\t\t\t\tvar name=\$\$(this).find('supplyname').text();\n\n\t\t\t\t\t\tdocument.form1.{$fieldname2}.options[document.form1.{$fieldname2}.length] = new Option(name, rowid);\n\t\t\t\t\t\tif(rowid=='" . $fields['value'][$fieldname2] . "')\n\t\t\t\t\t\t\tdocument.form1.{$fieldname2}.options[document.form1.{$fieldname2}.length-1].selected=true;\n\t\t\t\t\t\n });\t\t\t\t\n\t\t },\n\t\t error:function(XmlHttpRequest,textStatus, errorThrown)\n\t {\n\t\t\t var errorPage = XmlHttpRequest.responseText; \n\t\t\t alert('获取联系人出错：'+errorThrown);\n\t }\n\t});\n \n}\n";
print "\n\tfunction initloadchange()\n\t{\n\n\t\tif(document.form1.accountid)\n\t\t\tdocument.form1.accountid.options[document.form1.accountid.length] = new Option('预付款支付', '0');";
if ($fields['value'][$fieldname1] != '') {
print "changelocation1(" . $fields['value'][$fieldname1] . ");";
}
print "\n\t}\n\tif (document.all){\n\n\t\twindow.attachEvent('onload',initloadchange)//IE中\n\n\t\t}\n\n\telse{\n\n\t\twindow.addEventListener('load',initloadchange,false);//firefox\n\n\t}\n\t\n\t";
print "\n</SCRIPT>\n";
$supplyname = returntablefield("supply", "rowid", $fields['value'][$fieldname1], "supplyname");
$fieldnameID = $fieldname1 . "_ID";
print "<TR><TD class=TableData noWrap>供应商:</TD><TD class=TableData noWrap>\n";
print "<input type=\"hidden\" name=\"{$fieldname1}\" value=\"" . $fields['value'][$fieldname1] . "\" onchange=\"changelocation1(this.value);\">";
print "<input name=\"" . $fieldnameID . "\" value=\"" . $supplyname . "\" class=\"SmallStatic\" readonly size=30> \n";
print "<input type=\"button\" title='' value=\"选择\" class=\"SmallButton\" onClick=\"SelectAllInforSingle('../../Enginee/Module/supply_select_single/index.php','','{$fieldnameID}', '{$fieldname1}');\" > {$notnulltext}";
print "</TD></TR>\n";
print "<TR><TD class=TableData noWrap>预储值:</TD><TD class=TableData noWrap><div id='yuchuzhi'></div></TD></TR>\n";
print "<TR><TD class=TableData noWrap>供应商联系人:</TD><TD class=TableData noWrap>\n";
print "<SELECT name={$fieldname2} class=\"{$class}\" onkeydown=\"if(event.keyCode==13)event.keyCode=9\">\n";
print "</SELECT> {$notnulltext1}</TD></TR>\n";
}
function budengworkflowtodetail_Value($fieldvalue, $fields, $i)
{
global $db;
global $tablename, $html_etc, $common_html;
$Text = "";
$工作流ID号 = $fieldvalue;
$编号 = $fields['value'][$i]['编号'];
$审核人 = $fields['value'][$i]['审核人'];
$审核状态 = $fields['value'][$i]['审核状态'];
$审核 = strip_tags($审核状态);
$是否 = trim($审核);
$RUN_ID = $工作流ID号;
if ($RUN_ID > 0) {
$FLOW_ID = returntablefield("flow_run", "RUN_ID", $RUN_ID, "FLOW_ID");
//http://localhost/general/
//http://localhost/general/workflow/list/flow_view/?RUN_ID=225&FLOW_ID=128
$工作流ID号 = "\n\t\t<a href=\"../../../workflow/list/print/?RUN_ID={$RUN_ID}&FLOW_ID=128\" target=_blank><font color=green>查阅详情</font></a>\n\t\t<a href=\"../../../workflow/list/flow_view/?RUN_ID={$RUN_ID}&FLOW_ID=128\" target=_blank><font color=green>流程图</font></a>";
} else {
if ($审核人 == "") {
//http://localhost/general/EDU/Interface/Teacher/edu_scheduletiaoke_newai.php?actiondele=TiaoKeDelete&编号=150
$工作流ID号 = "<a href=\"?action2=DataDeal&编号={$编号}\">删除此条记录</a>";
} else {
if ($审核人 != "") {
if ($是否 == "是") {
$工作流ID号 = "<a><font color = red>申请通过</font></a>";
} else {
$工作流ID号 = "<a><font color = gray>申请未通过</font></a>";
}
}
}
}
return $工作流ID号;
}
function CustomerDingDan_add($fields, $i)
{
global $db, $_SESSION, $common_html;
$notnull = trim($fields['null'][$i]['inputtype']);
$notnull == 'notnull' ? $notnulltext = $common_html['common_html']['mustinput'] : ($notnulltext = '');
$fieldname1 = $fields['name'][$i];
$fieldname2 = $fields['input'][$i][0];
$j = array_search($fieldname2, $fields['name'], true);
$notnull = trim($fields['null'][$j]['inputtype']);
$notnull == 'notnull' ? $notnulltext1 = $common_html['common_html']['mustinput'] : ($notnulltext1 = '');
$class = "SmallSelect";
print "<script type=\"text/javascript\" language=\"javascript\" src=\"" . ROOT_DIR . "general/ERP/Enginee/jquery/jquery.js\"></script>";
print "<script language=javascript>\nvar \$\$ = jQuery.noConflict();\nfunction sendRequest(action,params) {\t\n \$\$.ajax({ \n\t\t type:'GET', \n\t\t url:'getLinkmanBycustomer.php?action='+action+'&' + params, \n\t\t dataType: 'xml', \n\t\t cache:false,\n\t\t success:function(data) \n\t\t { \n\t\t \t\t";
if ($notnulltext1 == '') {
print "document.form1.{$fieldname2}.options[document.form1.{$fieldname2}.length] = new Option('','');";
}
print "\n \t\t \t\t\n\t \t\t \t \$\$(data).find('dingdan').each(function() {\n \t\t\n\t\t\t\t\t\tvar rowid=\$\$(this).find('rowid').text();\n\t\t\t\t\t\tvar zhuti=\$\$(this).find('zhuti').text();\n\n\t\t\t\t\t\tdocument.form1.{$fieldname2}.options[document.form1.{$fieldname2}.length] = new Option(zhuti, rowid);\n\t\t\t\t\t\tif(rowid=='" . $fields['value'][$fieldname2] . "')\n\t\t\t\t\t\t\tdocument.form1.{$fieldname2}.options[document.form1.{$fieldname2}.length-1].selected=true;\n\t\t\t\t\t\ti++;\n });\t\t\t\t\n\t\t },\n\t\t error:function(XmlHttpRequest,textStatus, errorThrown)\n\t {\n\t\t\t var errorPage = XmlHttpRequest.responseText; \n\t\t\t alert('获取联系人出错：'+errorThrown);\n\t }\n\t});\n}\n\nfunction changelocation(locationid)\n{\n\tdocument.form1.{$fieldname2}.length = 0;\n\tif(locationid!='')\n \tsendRequest('dingdan','customerid='+locationid);\n}";
if ($fields['value'][$fieldname1] != '') {
print "window.onload=function(){\n\tchangelocation(" . $fields['value'][$fieldname1] . ");\n\t}\n\t";
}
print "</SCRIPT>\n";
print "<TR><TD class=TableData noWrap>客户:</TD><TD class=TableData noWrap>\n";
$customername = returntablefield("customer", "rowid", $fields['value'][$fieldname1], "supplyname");
print "<input type='hidden' name='{$fieldname1}' value='" . $fields['value'][$fieldname1] . "' onchange=\"changelocation(this.value);\">";
print "<input type='text' name='" . $fieldname1 . "_ID' value='" . $customername . "' readonly class='SmallStatic' size='25'>";
print " <input type=\"button\" title='' value=\"选择\" class=\"SmallButton\" onClick=\"SelectAllInforSingle('../../Enginee/Module/kehu_select_single/index.php','','" . $fieldname1 . "_ID', '{$fieldname1}');\" > ";
print "</SELECT> {$notnulltext}</TD></TR>\n";
print "<TR><TD class=TableData noWrap>关联订单:</TD><TD class=TableData noWrap>\n";
print "<SELECT id={$fieldname2} onkeydown=\"if(event.keyCode==13)event.keyCode=9\" class=\"{$class}\" size=1 name={$fieldname2}> \n";
print "</SELECT> {$notnulltext}</TD></TR>\n";
}
function 消息处理引擎之生成消息($数据对象, $数据字段, $提醒周期, $提醒对象, $提醒内容模板, $规则编号)
{
global $db, $_SESSION, $SYSTEM_PRINT_SQL;
$LOGIN_USER_ID = $_SESSION['LOGIN_USER_ID'];
$提醒内容模板 = ereg_replace('{', '{$', $提醒内容模板);
$sql = "select * from {$数据对象} where 编号 not in (\n\t\t\t\tselect 记录编号 from crm_clendar\n\t\t\t\twhere 数据对象='{$数据对象}'\n\t\t\t\tand 数据字段='{$数据字段}'\n\t\t\t\tand 数据字段='{$数据字段}'\n\t\t\t\tand 提醒周期='{$提醒周期}'\n\t\t\t\tand 提醒对象='{$提醒对象}'\n\t\t\t\t)\n\t\t\t\tand {$数据字段}!=''";
//print $sql."<BR>";
$rs = $db->Execute($sql);
$rs_a = $rs->GetArray();
//print $提醒内容模板."<BR>";
for ($i = 0; $i < sizeof($rs_a); $i++) {
$Element = $rs_a[$i];
//print_R($Element);
$ElementKeys = array_keys($Element);
for ($ix = 0; $ix < sizeof($ElementKeys); $ix++) {
$ElementName = $ElementKeys[$ix];
${$ElementName} = $Element[$ElementName];
$提醒内容模板 = ereg_replace('\\$' . $ElementName, $Element[$ElementName], $提醒内容模板);
//print $ElementName.$$ElementName.$提醒内容模板."<BR>";
}
$提醒内容模板 = ereg_replace('{', '', $提醒内容模板);
$提醒内容模板 = ereg_replace('}', '', $提醒内容模板);
$用户名 = ${$提醒对象};
$用户信息 = returntablefield("user", "USER_ID", $用户名, "USER_NAME,DEPT_ID");
$用户姓名 = $用户信息['USER_NAME'];
$DEPT_NAME = returntablefield("department", "DEPT_ID", $用户信息['DEPT_ID'], "DEPT_NAME");
$数据字段_ARRAY = explode('-', ${$数据字段});
//print_R($数据字段_ARRAY);
$提醒时间 = date("Y-m-d", mktime(1, 1, 1, $数据字段_ARRAY[1], $数据字段_ARRAY[2] - $提醒周期, $数据字段_ARRAY[0]));
$INSERTINTO['用户名'] = $用户名;
$INSERTINTO['用户姓名'] = $用户姓名;
$INSERTINTO['部门'] = $DEPT_NAME;
$INSERTINTO['规则'] = $规则编号;
$INSERTINTO['类型'] = "时间提醒";
$INSERTINTO['提醒时间'] = $提醒时间;
$INSERTINTO['提醒内容'] = $提醒内容模板;
$INSERTINTO['处理情况'] = '';
$INSERTINTO['备注'] = '';
$INSERTINTO['创建人'] = $用户名;
$INSERTINTO['创建时间'] = date("Y-m-d H:i:s");
$INSERTINTO['数据对象'] = $数据对象;
$INSERTINTO['数据字段'] = $数据字段;
$INSERTINTO['提醒周期'] = $提醒周期;
$INSERTINTO['提醒对象'] = $提醒对象;
$INSERTINTO['记录编号'] = $编号;
$INSERTINTOKEYS = array_keys($INSERTINTO);
$INSERTINTOVALUES = array_values($INSERTINTO);
$INSERTINTOKEYSTEXT = join(',', $INSERTINTOKEYS);
$INSERTINTOVALUESTEXT = "'" . join("','", $INSERTINTOVALUES) . "'";
$sql = "insert into crm_clendar ({$INSERTINTOKEYSTEXT}) values({$INSERTINTOVALUESTEXT}) ";
$db->Execute($sql);
//print $sql."<BR>";
//print $提醒内容模板."<BR>";
//exit;
//$SYSTEM_PRINT_SQL = 1;
}
}
function returnCurXueQiIndex($NJ, $ѧ������ = '')
{
global $db;
//�滻ԭ��ѧ������������,�µķ�������ѧ�����Ƶķ�ʽ,ȥ��ԭ�л���ķ��� 2010-07-21
if ($ѧ������ == "") {
$ѧ������ = returntablefield("edu_xueqiexec", "��ǰѧ��", '1', "ѧ������");
}
return $ѧ������;
}
function returnCurXueQiIndex($NJ, $ѧÆÚÃû³Æ = '')
{
global $db;
//Ìæ»»ÔÓÐѧÆÚË÷ÒýµÄ×÷·¨,еķ½°¸²ÉÓÃѧÆÚÃû³ÆµÄ·½Ê½,È¥³ýÔÓл»ËãµÄ·½·¨ 2010-07-21
if ($ѧÆÚÃû³Æ == "") {
$ѧÆÚÃû³Æ = returntablefield("edu_xueqiexec", "µ±Ç°Ñ§ÆÚ", '1', "ѧÆÚÃû³Æ");
}
return $ѧÆÚÃû³Æ;
}
function accessprepay_value($fieldvalue, $fields, $i)
{
$id = $fields['value'][$i]['id'];
$opertype = returntablefield("accessprepay", "id", $id, "opertype");
if ($opertype == '货款支付') {
$billinfo = returntablefield("buyplanmain", "billid", $fieldvalue, "zhuti,billid");
$fieldvalue = "<a href='buyplanmain_newai.php?action=view_default&billid=" . $billinfo['billid'] . "' target='_blank'>" . $billinfo['zhuti'] . "</a>";
}
return $fieldvalue;
}
function 开始处理消息中心($类型, $数据对象, $数据字段, $操作记录编号)
{
global $db;
if ($类型 == "UPDATE") {
$sql = "select * from crm_clendar_rule where 类型='{$类型}' and 数据对象='{$数据对象}' and 数据字段='{$数据字段}'";
} elseif ($类型 == "INSERT") {
$sql = "select * from crm_clendar_rule where 类型='{$类型}' and 数据对象='{$数据对象}'";
} elseif ($类型 == "DELETE") {
$sql = "select * from crm_clendar_rule where 类型='{$类型}' and 数据对象='{$数据对象}'";
} else {
return '';
}
//得到表结构信息
$MetaColumnNames = $db->MetaColumnNames($表名);
$MetaColumnNames = array_keys($MetaColumnNames);
$主键 = $MetaColumnNames[0];
$rs = $db->CacheExecute(360, $sql);
$rs_a = $rs->GetArray();
for ($i = 0; $i < sizeof($rs_a); $i++) {
$数据字段 = $rs_a[0]['数据字段'];
$提醒周期 = $rs_a[0]['提醒周期'];
$提醒对象 = $rs_a[0]['提醒对象'];
$提醒人员 = $rs_a[0]['提醒人员'];
$提醒内容模板 = $rs_a[0]['提醒内容模板'];
$是否启用 = $rs_a[0]['是否启用'];
$判断条件 = $rs_a[0]['判断条件'];
$判断值 = $rs_a[0]['判断值'];
$跳转路径 = $rs_a[0]['跳转路径'];
//求得目标提醒人员
$sql = "select * from {$数据对象} where {$主键}='{$操作记录编号}'";
$rs2 = $db->CacheExecute(15, $sql);
$rs2_a = $rs2->GetArray();
//判断提醒对象是否是本表字段
if (in_array($提醒对象, $MetaColumnNames)) {
//判断提醒对象是否存在于用户表内
$USER_NAME = returntablefield("user", "USER_ID", $rs2_a[0][$提醒对象], "USER_NAME");
if ($USER_NAME != "") {
$求得目标提醒人员 = $rs2_a[0][$提醒对象];
}
}
//对模板进行替换操作
for ($ix = 0; $ix < sizeof($MetaColumnNames); $ix++) {
$FIELD_NAME = $MetaColumnNames[$ix];
$提醒内容模板 = ereg_replace("{$FIELD_NAME}", $rs_a[0][$FIELD_NAME], $提醒内容模板);
}
if ($提醒人员 != "") {
$求得目标提醒人员 = $提醒人员 . "," . $求得目标提醒人员;
}
发送消息_TDOASMS('admin', $求得目标提醒人员, $SMS_TYPE = 0, $提醒内容模板, $跳转路径);
}
}
function stockinrefer_value($fieldvalue, $fields, $i)
{
$color = setColorByName($fieldvalue);
if (stristr($fields['value'][$i]['intype'], "采购入库")) {
$title = returntablefield("buyplanmain", "billid", $fieldvalue, "zhuti");
$fieldvalue = "<a style='color:{$color}' href='buyplanmain_newai.php?" . base64_encode("action=view_default&billid=" . $fieldvalue) . "' target='_blank'>" . $title . "</a>";
} else {
if (stristr($fields['value'][$i]['intype'], "退货入库")) {
$title = returntablefield("sellplanmain", "billid", $fieldvalue, "zhuti");
$fieldvalue = "<a style='color:{$color}' href='sellonemain_newai.php?" . base64_encode("action=view_default&billid=" . $fieldvalue) . "' target='_blank'>" . $title . "</a>";
}
}
return $fieldvalue;
}
function buyplanstate_value_PRIV($fieldvalue, $fields, $i)
{
global $db;
global $tablename;
global $html_etc;
global $common_html;
$SYSTEM_STOP_ROW['shenhe_priv'] = 1;
$SYSTEM_STOP_ROW['flow_priv'] = 1;
$SYSTEM_STOP_ROW['delete_priv'] = 1;
$SYSTEM_STOP_ROW['edit_priv'] = 1;
$SYSTEM_STOP_ROW['next_priv'] = 1;
$operid = returntablefield("buyplanmain", "billid", $fields['value'][$i]['billid'], "createman");
$operRole = getSupplyRoleBySupplyID($operid);
switch ($fieldvalue) {
case "1":
if ($operRole) {
$SYSTEM_STOP_ROW['edit_priv'] = 0;
$SYSTEM_STOP_ROW['delete_priv'] = 0;
$SYSTEM_STOP_ROW['shenhe_priv'] = 0;
}
break;
case "2":
if ($operRole) {
$SYSTEM_STOP_ROW['edit_priv'] = 0;
$SYSTEM_STOP_ROW['flow_priv'] = 0;
$SYSTEM_STOP_ROW['delete_priv'] = 0;
//$SYSTEM_STOP_ROW['shenhe_priv'] = 0;
}
break;
case "3":
break;
case "4":
if ($operRole) {
$SYSTEM_STOP_ROW['flow_priv'] = 0;
$SYSTEM_STOP_ROW['next_priv'] = 0;
}
break;
case "5":
break;
}
if (stristr($fields['value'][$i]['user_flag'], '撤销')) {
$SYSTEM_STOP_ROW['edit_priv'] = 1;
$SYSTEM_STOP_ROW['flow_priv'] = 1;
$SYSTEM_STOP_ROW['delete_priv'] = 1;
$SYSTEM_STOP_ROW['shenhe_priv'] = 1;
$SYSTEM_STOP_ROW['next_priv'] = 1;
}
return $SYSTEM_STOP_ROW;
}
function emailkehulist_view($fields, $i)
{
$fieldvalue = $fields['value']['customers'];
$customeridArray = explode(",", $fieldvalue);
$customerName = '';
for ($i = 0; $i < count($customeridArray); $i++) {
if ($customeridArray[$i] != '') {
$customerName = $customerName . returntablefield("linkman", "rowid", $customeridArray[$i], "linkmanname") . ",";
}
}
if (strlen($customerName) > 20) {
$customerName = substr($customerName, 0, 20) . "...";
}
return "<tr><td class=TableContent noWrap>收件客户</td><td class=TableData noWrap colspan=5>{$customerName}</td></tr>";
}
function studentweiji_Value($fieldvalue, $fields, $i)
{
global $db;
global $tablename, $html_etc, $common_html;
$Text = "";
$学生姓名 = $fields['value'][$i]['学生姓名'];
$学生学号 = $fields['value'][$i]['学生学号'];
$学生基本信息 = returntablefield("edu_student", "学号", $学生学号, "父亲姓名,父亲电话,母亲姓名,母亲电话");
$父亲姓名 = $学生基本信息['父亲姓名'];
$父亲电话 = $学生基本信息['父亲电话'];
$母亲姓名 = $学生基本信息['母亲姓名'];
$母亲电话 = $学生基本信息['母亲电话'];
$TEXT = "{$学生姓名} 父亲:{$父亲姓名} {$父亲电话} 母亲:{$母亲姓名} {$母亲电话}";
return $工作流ID号;
}
function customerPriv_value_PRIV($fieldvalue, $fields, $i)
{
$SYSTEM_STOP_ROW['edit_priv'] = 1;
$SYSTEM_STOP_ROW['delete_priv'] = 1;
$SYSTEM_STOP_ROW['flow_priv'] = 1;
if (ifHasRoleCust($fields['value'][$i]['ROWID'])) {
$SYSTEM_STOP_ROW['edit_priv'] = 0;
$SYSTEM_STOP_ROW['delete_priv'] = 0;
$SYSTEM_STOP_ROW['flow_priv'] = 0;
}
$billid = returntablefield("sellplanmain", "supplyid", $fields['value'][$i]['ROWID'], "billid");
if ($billid != '') {
$SYSTEM_STOP_ROW['delete_priv'] = 1;
}
return $SYSTEM_STOP_ROW;
}
function shenheren_value_PRIV($fieldvalue, $fields, $i)
{
$SYSTEM_STOP_ROW['next_priv'] = 1;
$SYSTEM_STOP_ROW['flow_priv'] = 1;
$shenehren = $fields['value'][$i]['批准人'];
if ($shenehren == $_SESSION['LOGIN_USER_ID'] && $fields['value'][$i]['否是审核'] == 1) {
$SYSTEM_STOP_ROW['next_priv'] = 0;
}
$storeid = $fields['value'][$i]['出库仓库'];
$userid = returntablefield("officeproductcangku", "编号", $storeid, "仓库负责人");
$useridArray = explode(",", $userid);
if (in_array($_SESSION['LOGIN_USER_ID'], $useridArray) && $fields['value'][$i]['否是审核'] == 2 && $fields['value'][$i]['是否归还'] == 1) {
$SYSTEM_STOP_ROW['flow_priv'] = 0;
}
return $SYSTEM_STOP_ROW;
}
function baojiadan_value_PRIV($fieldvalue, $fields, $i)
{
global $db;
$SYSTEM_STOP_ROW['edit_priv'] = 1;
$SYSTEM_STOP_ROW['delete_priv'] = 1;
$SYSTEM_STOP_ROW['shenhe_priv'] = 1;
$SYSTEM_STOP_ROW['flow_priv'] = 1;
$SYSTEM_STOP_ROW['next_priv'] = 1;
$SYSTEM_STOP_ROW['view_priv'] = 1;
/*
if($fields['value'][$i]['金额']==0)
{
$SYSTEM_STOP_ROW['edit_priv'] = 0;
$SYSTEM_STOP_ROW['delete_priv'] =0;
}
else
{
$SYSTEM_STOP_ROW['shenhe_priv'] = 0;
$SYSTEM_STOP_ROW['edit_priv'] = 0;
$SYSTEM_STOP_ROW['delete_priv'] =0;
}
*/
$userinfo = returntablefield("user", "user_id", $fields['value'][$i]['创建人'], "user_id,dept_id,user_priv");
$userid = $userinfo['user_id'];
$deptid = $userinfo['dept_id'];
$userpriv = $userinfo['user_priv'];
if ($fields['value'][$i]['是否审核'] == 1) {
if ($userid == $_SESSION['LOGIN_USER_ID']) {
$SYSTEM_STOP_ROW['edit_priv'] = 0;
$SYSTEM_STOP_ROW['delete_priv'] = 0;
}
}
if ($_SESSION['LOGIN_USER_PRIV'] == '1' || $deptid == $_SESSION['LOGIN_DEPT_ID'] && $_SESSION['LOGIN_USER_PRIV'] < $userpriv) {
if ($fields['value'][$i]['是否审核'] == 1) {
$SYSTEM_STOP_ROW['flow_priv'] = 0;
$SYSTEM_STOP_ROW['edit_priv'] = 0;
} else {
if ($fields['value'][$i]['是否审核'] == 2) {
$SYSTEM_STOP_ROW['shenhe_priv'] = 0;
$SYSTEM_STOP_ROW['view_priv'] = 0;
}
}
}
return $SYSTEM_STOP_ROW;
return $SYSTEM_STOP_ROW;
}
