<?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'>&nbsp;回访结果记录:</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}%')";
예제 #3
0
<?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>";
    }
}