<?php header("Content-type: text/html; charset=gbk"); require "../include/common.inc.php"; require "../function/changekg.php"; $db = new DB_erptest(); $db2 = new DB_erptest(); $db3 = new DB_erptest(); if ($loginuserqx[4009][4] == 1) { $contect .= "<table width='90%'class=InputFrameMain cellspacing='0'cellpadding='0' border='0'>"; $contect .= "<tr class=InputFrameLine>"; $contect .= "<td height='100' width='20%' align=right class=form_label><span class='span_label'> 回访结果记录:</span></td>"; $contect .= "<td height='100' width='80%' class=span_label ><textarea id='contect' style='width:80%;height:60'></textarea></td>"; $contect .= "</tr>"; $contect .= "<tr class=InputFrameLine>"; $contect .= "<td height='30' width='20%' align=right class=form_label></td>"; $contect .= "<td height='30' width='80%' class=span_label ><input type='button' value='提交结果' onclick='tj()'/></td>"; $contect .= "</tr>"; $contect .= "</table>"; } $beginpage = ($page - 1) * 10; $contect .= "<table width='100%' border='0' cellspacing='0' cellpadding='0'>"; $k = 0; $query = "select * from tb_memberhf where fd_memberhf_memid = '{$memid}' order by fd_memberhf_datetime desc limit {$beginpage},10\n"; $db->query($query); if ($db->nf()) { while ($db->next_record()) { $staname = $db->f(fd_memberhf_loginstaname); $hfdate = $db->f(fd_memberhf_datetime); $hfcontect = $db->f(fd_memberhf_contect); $contect .= "<tr height='50'>";
<?php header("Content-type: text/html; charset=gbk"); require "../include/common.inc.php"; $db = new DB_erptest(); $db2 = new DB_erptest(); $db3 = new DB_erptest(); if ($sorttype == "desc") { ${$sort} = "▼"; } else { ${$sort} = "▲"; } $contect = "<table width='100%' border='1' cellspacing='0' cellpadding='0' bordercolor='#d1d1d1' style='border-collapse:collapse;'>"; $contect .= "<tr align='center' height='30' bgcolor='#8caae7' style='color:#fff;font-weight:bold;position:relative;'>"; $contect .= "<td nowrap width='40' >序号</td>"; $contect .= "<td nowrap width='270'>企业名称</td>"; $contect .= "<td nowrap >联系人</td>"; $contect .= "<td nowrap >联系电话</td>"; $contect .= "<td nowrap >城市</td>"; $contect .= "<td nowrap style='cursor:hand' onclick=loadmemberbuy('resort','joindate',document.getElementById('nowpage').value,document.getElementById('pagecount').value)>加入日期<span id=joindate>{$joindate}</span></td>"; $contect .= "<td nowrap style='cursor:hand' onclick=loadmemberbuy('resort','lasthf',document.getElementById('nowpage').value,document.getElementById('pagecount').value)>最后回访日期<span id=lasthf>{$lasthf}</span></td>"; $contect .= "<td nowrap >最近回访摘要</td>"; $contect .= "<td nowrap>操作区</td>"; $contect .= "</tr>"; if (!empty($atcompany)) { $atcompany = iconv('utf-8', 'gbk', unescape($atcompany)); $querywhere .= " and fd_webcus_name like '%{$atcompany}%'"; } if (!empty($atcity)) { $atcity = iconv('utf-8', 'gbk', unescape($atcity)); $querywhere .= " and (fd_provinces_name like '%{$atcity}%' or fd_city_name like '%{$atcity}%')";
<?php require "../include/common.inc.php"; $db = new DB_test(); $db1 = new DB_test(); $db2 = new DB_test(); $dberp = new DB_erptest(); $query = "select * from web_order where fd_order_seltdate='2012-12-04' and fd_order_zf=0"; $db->query($query); if ($db->nf()) { while ($db->next_record()) { $orderid = $db->f(fd_order_id); $arr_web[$orderid] = $db->f(fd_order_allcost); $sumweb += number_format($db->f(fd_order_allcost), 2, ".", ""); } } $query = "select * from tb_salelist where fd_selt_date='2012-12-04' and fd_selt_organid = 1 "; $dberp->query($query); if ($dberp->nf()) { while ($dberp->next_record()) { $orderid = $dberp->f(fd_selt_weborderid); $arr_erp[$orderid] = number_format($dberp->f(fd_selt_allcost), 2, ".", ""); $sumerp += number_format($dberp->f(fd_selt_allcost), 2, ".", ""); } } echo $sumweb . "##" . $sumerp . "<br>"; while (list($orderid, $val) = @each($arr_web)) { if ($arr_web[$orderid] != $arr_erp[$orderid]) { echo $orderid . "&&" . $arr_web[$orderid] . "!=" . $arr_erp[$orderid] . "<br>"; } }