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; }