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