public function getareaauthornum($cusid, $month)
{
$db = new db_test();
$query = "select count(*) as activecardnum from tb_author\n where fd_author_bdagentid = '{$cusid}'\n and (fd_author_bdagenttime) like '%{$month}%'\n group by fd_author_bdagentid";
// echo $query;
if ($db->execute($query)) {
$arr_money = $db->get_one($query);
}
return $arr_money['activecardnum'];
}
function saveFileid($dateid, $catid)
{
$dbfile = new db_test();
if ($catid) {
$query = "update tb_upload_category_list set fd_cat_dateid='{$dateid}'\n\t\t\twhere fd_cat_dateid='0' and fd_cat_id in({$catid})";
$dbfile->query($query);
//echo $query;
}
//return $query;
}
function setUp()
{
$this->image =& db_table_factory::instance('test_image');
$this->image_variation =& db_table_factory::instance('test_image_variation');
$this->media =& db_table_factory::instance('test_media');
parent::setUp();
}
function tearDown()
{
parent :: tearDown();
$user =& user :: instance();
$user->logout();
}
function tearDown()
{
parent::tearDown();
$user =& user::instance();
$user->logout();
$this->ac->tally();
}
function tearDown()
{
parent::tearDown();
$this->object->tally();
$this->parent_object->tally();
$this->parent_object_controller->tally();
}
function setUp()
{
parent :: setUp();
$this->search_query = new search_query();
$this->search = new full_text_search();
}
function tearDown()
{
parent::tearDown();
$user =& user::instance();
$user->logout();
$this->metadata_component->tally();
$this->controller->tally();
}
function changecoupon($listid, $no, $type, $money, $couponno, $authorid, $paycardid = null, $memo)
{
$db = new db_test();
switch ($type) {
case "sale":
$query = "insert into tb_couponglide (\n\t\t fd_couponglide_no , fd_couponglide_type , fd_couponglide_addmoney ,\n\t\t fd_couponglide_lessmoney , fd_couponglide_datetime , fd_couponglide_memo ,\n\t\t fd_couponglide_man , fd_couponglide_couponno , fd_couponglide_authorid ,\n\t\t fd_couponglide_paycardid ,fd_couponglide_listid\n\t\t )values(\n\t\t '{$no}' , '{$type}' , '0' , \n\t\t '{$money}' , now() , '{$memo}' , \n\t\t '{$loginstaname}' , '{$couponno}' , '{$authorid}' ,\n\t\t '{$paycardid}' , '{$listid}'\n\t\t )\n\t\t ";
$db->query($query);
break;
case "rebuy":
$query = "insert into tb_couponglide (\n\t\t fd_couponglide_no , fd_couponglide_type , fd_couponglide_addmoney ,\n\t\t fd_couponglide_lessmoney , fd_couponglide_datetime , fd_couponglide_memo ,\n\t\t fd_couponglide_man , fd_couponglide_couponno , fd_couponglide_authorid ,\n\t\t fd_couponglide_paycardid ,fd_couponglide_listid\n\t\t )values(\n\t\t '{$no}' , '{$type}' , '{$money}' , \n\t\t '0' , now() , '{$memo}' , \n\t\t '{$loginstaname}' , '{$couponno}' , '{$authorid}' ,\n\t\t '{$paycardid}' , '{$listid}'\n\t\t )\n\t\t ";
$db->query($query);
break;
case "use":
$query = "insert into tb_couponglide (\n\t\t fd_couponglide_no , fd_couponglide_type , fd_couponglide_addmoney ,\n\t\t fd_couponglide_lessmoney , fd_couponglide_datetime , fd_couponglide_memo ,\n\t\t fd_couponglide_man , fd_couponglide_couponno , fd_couponglide_authorid ,\n\t\t fd_couponglide_paycardid ,fd_couponglide_listid\n\t\t )values(\n\t\t '{$no}' , '{$type}' , '0' , \n\t\t '0' , now() , '{$memo}' , \n\t\t '{$loginstaname}' , '{$couponno}' , '{$authorid}' ,\n\t\t '{$paycardid}' , '{$listid}'\n\t\t )\n\t\t ";
$db->query($query);
break;
}
}
<?php
require "../include/common.inc.php";
$db = new db_test();
$gotourl = "app_interface_b.php?listid={$listid}";
switch ($type) {
case "save":
//echo $intfid."aaaaa</br>";
$query = "select * from web_test_interface where fd_interface_appmenuid = 0 and fd_interface_id =" . $intfid;
$db->query($query);
if ($db->nf()) {
$query = "update web_test_interface set fd_interface_appmenuid = {$listid} where fd_interface_id =" . $intfid;
//echo $query;exit;
$db->query($query);
require "../include/alledit.2.php";
Header("Location: {$gotourl}");
} else {
echo "<script>alert('该接口已经被绑定，请查证！');location.href='{$gotourl}'</script>";
}
break;
case "jb":
$query = "update web_test_interface set fd_interface_appmenuid = 0 where fd_interface_id = " . $intfid;
$db->query($query);
require "../include/alledit.2.php";
Header("Location: {$gotourl}");
break;
case "delete":
$query = "delete from web_test_interface where fd_interface_id='{$intfid}'";
$db->query($query);
require "../include/alledit.2.php";
Header("Location: {$gotourl}");
<?php
$thismenucode = "2k508";
require "../include/common.inc.php";
$db = new db_test();
$db2 = new db_test();
$db3 = new db_test();
$gotourl = "yewupayset.php";
$t = new Template(".", "keep");
$t->set_file("template", "yewupayset.html");
$t->set_block("template", "BXBK", "BXBKs");
$arr_text = array("编号", "业务类型", "交易规则", "操作");
for ($i = 0; $i < count($arr_text); $i++) {
$theadth .= ' <th>' . $arr_text[$i] . '</th>';
}
$query = "select * from tb_creditcardset";
$arr_creditcset = $db->get_one($query);
if ($arr_creditcset['fd_creditcset_whenpayfee'] = 'post') {
$showname = '通付宝刷卡时';
} else {
$showname = '支金代付款时';
}
$arr_cinput['creditcardset'] = "\n\t还信用卡刷卡金额 <u><font color='#00CC00'>" . $arr_creditcset['fd_creditcset_slotcardmoney'] . "</font></u> 元/笔，\n\t商户刷卡 <u><font color='#00CC00'>" . $arr_creditcset['fd_creditcset_dayslotcard'] . "</font></u> 次/月，\n\t月还款总限额 <u><font color='#00CC00'>" . $arr_creditcset['fd_creditcset_maxmoney'] . "</font></u> 元,\n\t单卡还款次数 <u><font color='#00CC00'>" . $arr_creditcset['fd_creditcset_monthslotcard'] . "</font></u> 次/月，";
if ($arr_creditcset['fd_creditcset_mode'] == 'fix') {
$arr_cinput['creditcardset'] .= "固定手续费 <u><font color='#00CC00'>" . $arr_creditcset['fd_creditcset_fee'] . "</font></u> 元/笔。";
} else {
$arr_cinput['creditcardset'] .= "\n\t最低费率额 <u><font color='#00CC00'>" . $arr_creditcset['fd_creditcset_minfee'] . "</font></u> ,\n\t最高费率额 <u><font color='#00CC00'>" . $arr_creditcset['fd_creditcset_maxfee'] . "</font></u> ，\n\t收取费率 <u><font color='#00CC00'>" . $arr_creditcset['fd_creditcset_sqfee'] . "</font></u> 。";
}
$query = "select * from tb_transfermoneyset where fd_transfermoneyset_tfmgtype = 'tfmg'";
$arr_transfermoneyset = $db->get_one($query);
$arr_cinput['transfermoneyset'] = "\n\t转账刷卡金额 <u><font color='#00CC00'>" . $arr_transfermoneyset['fd_transfermoneyset_slotcardmoney'] . "</font></u> 元/笔，\n\t转账刷卡次数 <u><font color='#00CC00'>" . $arr_transfermoneyset['fd_transfermoneyset_dayslotcardcount'] . "</font></u> 次/日 ， \n\t转账月限额 <u><font color='#00CC00'>" . $arr_transfermoneyset['fd_transfermoneyset_datemaxcount'] . "</font></u> 元,\n\t\n\t";
<?php
$thismenucode = "6n003";
require "../include/common.inc.php";
$db = new db_test();
$db2 = new db_test();
$db3 = new db_test();
$gourl = "salerreward.php";
if ($money) {
$arr_money = explode("/", $money);
}
switch ($act) {
case "new":
$query = "insert into tb_salerrewards(fd_rewards_selfmoney,fd_rewards_tcsendtime,fd_rewards_allmoney,\n\t\t\t\t\t\t\t\t\t\t fd_rewards_bmonth,fd_rewards_emonth,fd_rewards_sendphonemsg)\n\t values('{$arr_money['0']}','{$tcsendtime}','{$arr_money['1']}','{$bmonth}','{$emonth}','{$sendphonemsg}')";
$db->query($query);
echo "<script>alert('保存成功!');location.href='{$gourl}'</script>";
break;
case "edit":
$query = "update tb_salerrewards set \n\t fd_rewards_selfmoney ='{$arr_money['0']}', fd_rewards_tcsendtime ='{$tcsendtime}',fd_rewards_allmoney ='{$arr_money['1']}',\n\t\t\t fd_rewards_bmonth='{$bmonth}' , fd_rewards_emonth='{$emonth}' ,fd_rewards_sendphonemsg='{$sendphonemsg}'\n\t\t\t where fd_rewards_id = '{$rewardsid}'";
$db->query($query);
echo "<script>alert('修改成功!');location.href='{$gourl}'</script>";
break;
}
$t = new Template(".", "keep");
$t->set_file("template", "salerreward.html");
$query = "select * from tb_salerrewards ";
$db->query($query);
if ($db->nf()) {
$db->next_record();
$rewardsid = $db->f(fd_rewards_id);
$selfmoney = $db->f(fd_rewards_selfmoney);
<?php
require "../include/common.inc.php";
header('Content-Type:text/html;charset=GB2312');
$db = new db_test();
$dbshop = new db_shop();
//left join tb_shopkcquantity on fd_skqy_shopid=fd_shop_id and fd_skqy_procatalogid='$procaid'
$query = "select fd_shop_province from tb_shop \n\t\t\n\t\twhere fd_shop_isstop='0' and fd_shop_state='5' and fd_shop_iswebhidden = 0 ";
$dbshop->query($query);
if ($dbshop->nf()) {
while ($dbshop->next_record()) {
$arr_provincescode[] = $dbshop->f(fd_shop_province);
}
}
$provincescode = implode(",", $arr_provincescode);
$query = "select fd_provinces_code,fd_provinces_name from tb_provinces where fd_provinces_code in({$provincescode})";
$db->query($query);
$i = 1;
if ($db->nf()) {
while ($db->next_record()) {
$provincescode = $db->f(fd_provinces_code);
$provincesname = $db->f(fd_provinces_name);
$showcheck .= '<font style="width:30px;"><input type="checkbox" title="' . $provincesname . '" name="arr_provinces[]" onclick="readmarketingparam(\'' . $procaid . '\')"
value="' . $provincescode . '">' . $provincesname . '</font>';
if ($i % 12 == 0) {
$showcheck .= "<br/>";
}
$i++;
}
}
echo $showcheck;
<?php
header('Content-Type: application/x-www-form-urlencoded');
header('Content-Type: text/html;charset=gb2312');
require "../include/common.inc.php";
require_once '../include/json.php';
$db = new db_test();
$count = 0;
if ($type != 'checkdetail') {
$idwhere = "fd_authorbkcard_authorid='{$listid}'";
} else {
$idwhere = "fd_authorbkcard_paycardid='{$listid}'";
}
$aColumns = array("", "fd_bank_name", "fd_authorbkcard_no", "fd_authorbkcard_cardname", "fd_authorbkcard_ckr", "fd_paycard_key");
$sSearch = u2g($sSearch);
$sWhere = "";
if ($sSearch != "") {
$sWhere = "and (";
for ($i = 1; $i < count($aColumns); $i++) {
$sWhere .= $aColumns[$i] . " LIKE '%" . trim($sSearch) . "%' OR ";
}
$sWhere = substr_replace($sWhere, "", -3);
$sWhere .= ')';
}
/* Individual column filtering */
for ($i = 1; $i < count($aColumns); $i++) {
$b_s = "bSearchable_" . $i;
$s_s = "sSearch_" . $i;
if (${$b_s} == "true" && ${$s_s} != '') {
if ($sWhere == "") {
$sWhere = "AND ";
<?php
$thismenucode = "10n004";
require "../include/common.inc.php";
$db = new db_test();
$t = new Template(".", "keep");
$t->set_file("template", "payfeelist.html");
$query = "select sum(fd_payfee_addmoney) as alladdmoney,sum(fd_payfee_lessmoney) as alllessmoney from tb_payfeelist";
$db->query($query);
if ($db->nf()) {
while ($db->next_record()) {
$alladdmoney = $db->f(alladdmoney);
$alllessmoney = $db->f(alllessmoney);
$allmoney = $alladdmoney + $alllessmoney;
}
}
$checkall = '<INPUT onclick=CheckAll() type=checkbox class=checkbox value=on name=chkall>';
$arr_text = array("流水编号", "刷卡器设备号", "手续费", "交易方式", "时间");
for ($i = 0; $i < count($arr_text); $i++) {
$theadth .= ' <th>' . $arr_text[$i] . '</th>';
}
$arr_titlename = array("tb_repaymoneyglist" => "贷款还款支付手续费", "tb_creditcardglist" => "信用卡还款支付手续费", "tb_transfermoneyglist" => "转账汇款支付手续费");
$query = "select fd_payfee_tabname from tb_payfeelist group by fd_payfee_tabname";
$db->query($query);
if ($db->nf()) {
while ($db->next_record()) {
$arr_tabname[] = $db->f(fd_payfee_tabname);
}
}
for ($i = 0; $i < count($arr_tabname); $i++) {
$key = $arr_tabname[$i];
<?php
header('Content-Type: application/x-www-form-urlencoded');
header('Content-Type: text/html;charset=gb2312');
require "../include/common.inc.php";
require_once '../include/json.php';
require "../function/changekg.php";
$db = new db_test();
$query = "select * from web_orderdetail \n left join web_order on fd_order_id = fd_orderdetail_orderid\n where fd_orderdetail_id='{$id}'";
$db->query($query);
if ($db->nf()) {
$db->next_record();
$state = $db->f(fd_order_state);
}
if ($state > 1) {
echo "0@@" . $query;
exit;
}
$query = "update web_orderdetail set fd_orderdetail_quantity = '{$value}' where fd_orderdetail_id = '{$id}'";
$db->query($query);
echo "1@@" . $value . $query;
<?php
$thismenucode = "2n501";
require "../include/common.inc.php";
require "../function/changecouponglide.php";
$db = new db_test();
if ($type == "check") {
$gourl = "tb_creditcard_h_b.php";
$titlename = "信用卡还款支付历史";
} elseif ($type == "error") {
$gourl = "tb_creditcard_error_b.php";
$titlename = "信用卡还款支付异常";
} else {
$gourl = "tb_creditcard_sp_b.php";
$titlename = "信用卡还款支付复核";
$note = "<div style='margin-top:10px; font-size:12px; color:#060'>注意：银联代付还没有完成前，不能提交审核，请先通过代付款申请付款这笔单据！</div>";
}
if ($gotype == "sp") {
$gourl = "tb_creditcard_sp_b.php";
$titlename = "信用卡还款支付异常";
}
$gotourl = $gourl . $tempurl;
require "../include/alledit.1.php";
//,fd_ccglist_sendsms='$sendsms',fd_ccglist_shoucardmemo='$shoucardmemo'
switch ($action) {
case "pass":
//编辑记录
$query = "update tb_creditcardglist set\n\t\tfd_ccglist_state='{$isok}',fd_ccglist_qrdatetime=now(), fd_ccglist_qrman='{$loginstaname}' \n\t\twhere fd_ccglist_id={$listid}";
$db->query($query);
$query1 = "select * from tb_creditcardglist \n\t\t left join tb_paycard on fd_ccglist_paycardid = fd_paycard_id\n\t\t where fd_ccglist_id={$listid} ";
$db->query($query1);
<?php
$thismenucode = "2002";
require "../include/common.inc.php";
$t = new Template(".", "keep");
$t->set_file("dept_framework", "dept_framework.ihtml");
$db = new db_test();
//$menufile = "menuarryfile.php" ;
//$menuarry = file($menufile);
$num = 0;
$query = "select * from tb_dept order by fd_dept_id asc ";
$db->query($query);
if ($db->nf()) {
while ($db->next_record()) {
$deptid = $db->f(fd_dept_id);
$fid = $db->f(fd_dept_fid);
$name = $db->f(fd_dept_name);
$arr_deptid[$num] = $deptid;
$arr_fid[$num] = $fid;
$arr_name[$num] = $name;
//if($fid!=0){
$arr_isunder[$fid] = 1;
//}
$num++;
}
}
for ($i = 0; $i < count($arr_deptid); $i++) {
$a = $arr_deptid[$i];
$arrall[$a][code] = $a;
if (empty($arr_fid[$i])) {
$arrall[$a][fcode] = 0;
<?php
require "../include/common.inc.php";
require "../include/json.php";
header('Content-Type:text/html;charset=utf-8');
$db = new db_test();
$prov = u2g(unescape($prov));
$query = "select fd_china_city as city from tb_china where fd_china_prov = '{$prov}'\n group by fd_china_city order by fd_china_areacode asc";
$db->query($query);
if ($db->nf()) {
while ($db->next_record()) {
$arr_city_code = g2u($db->f(city));
$arr_city_name = g2u($db->f(city));
$select[] = array("id" => $arr_city_code, "title" => $arr_city_name);
}
}
if (empty($select)) {
$select[] = array("id" => "", "title" => "");
}
echo json_encode($select);
<?php
require "../include/common.inc.php";
$db = new db_test();
if (!empty($listid)) {
$query = "UPDATE tb_paymoneylist SET fd_pymylt_times = " . ($times + 1) . " WHERE fd_pymylt_id = " . $listid;
$db->query($query);
echo 'success';
} else {
echo 'failure';
}
<?php
$thismenucode = "6n006";
require "../include/common.inc.php";
$db = new db_test();
$db2 = new db_test();
$db3 = new db_test();
if (!empty($password)) {
$password = md5($password);
}
switch ($action) {
case "save":
if (!empty($id)) {
$query = "select * from tb_saler where fd_saler_id = '{$id}'";
$db->query($query);
if ($db->nf()) {
$query = "select * from tb_saler where fd_saler_username = '******' and fd_saler_id <> '{$id}'";
$db2->query($query);
if ($db2->nf() > 0) {
$error = "你输入用户名已被注册，请查证！";
} else {
$query = "select * from tb_saler where fd_saler_phone = '{$phone}' and fd_saler_id <> '{$id}'";
$db2->query($query);
if ($db2->nf() > 0) {
$error = "你输入手机已被注册，请查证！";
} else {
$query = "select * from tb_saler where fd_saler_idcard = '{$idcard}' and fd_saler_id <> '{$id}'";
$db2->query($query);
if ($db2->nf() > 0) {
$error = "你输入身份证已被注册，请查证！";
} else {
function getnewssaler($value)
{
$db = new db_test();
$query = "select fd_saler_truename from web_saler where fd_saler_id='{$value}'";
$db->query($query);
if ($db->nf()) {
$db->next_record();
$salername = $db->f(fd_saler_truename);
return $salername;
}
}
<?php
header('Content-Type: application/x-www-form-urlencoded');
header('Content-Type: text/html;charset=utf-8');
require "../include/common.inc.php";
require_once '../include/json.php';
$db = new db_test();
$query = "select fd_paycard_salerid,count(*) as counts from tb_paycard group by fd_paycard_salerid ";
$db->query($query);
if ($db->nf()) {
while ($db->next_record()) {
$id = $db->f(fd_paycard_salerid);
//id号
$arr_membercounts[$id] = g2u($db->f(counts));
}
}
$aColumns = array("", "a.fd_saler_truename", "a.fd_saler_username", "a.fd_saler_phone", "b.fd_saler_truename", 'a.fd_saler_zjl');
$sSearch = u2g($sSearch);
$sWhere = "";
if ($sSearch != "") {
$sWhere = "and (";
for ($i = 1; $i < count($aColumns); $i++) {
$sWhere .= $aColumns[$i] . " LIKE '%" . trim($sSearch) . "%' OR ";
}
$sWhere = substr_replace($sWhere, "", -3);
$sWhere .= ')';
}
/* Individual column filtering */
for ($i = 1; $i < count($aColumns); $i++) {
$b_s = "bSearchable_" . $i;
$s_s = "sSearch_" . $i;
<?php
$thismenucode = "7n003";
require "../include/common.inc.php";
require "../FCKeditor/fckeditor.php";
$db = new db_test();
$gourl = "tb_apprules_b.php";
$gotourl = $gourl . $tempurl;
require "../include/alledit.1.php";
switch ($action) {
case "new":
//新增记录
$allcontent = $_POST[FCKeditor1];
$query = "insert into tb_apprules (\n\t\t\t\t\t\t\tfd_apprules_no , fd_apprules_title ,\t\tfd_apprules_content,\n\t\t\t\t\t\t\tfd_apprules_type)values(\n\t\t\t\t\t\t\t'{$no}' , '{$title}' \t, '{$allcontent}' ,'{$type}'\n\t\t\t\t\t\t\t)";
$db->query($query);
Header("Location: {$gotourl}");
break;
case "delete":
//删除记录
$query = "delete from tb_apprules where fd_apprules_id='{$id}'";
$db->query($query);
require "../include/alledit.2.php";
Header("Location: {$gotourl}");
break;
case "edit":
//编辑记录
$allcontent = $_POST[FCKeditor1];
$query = "update tb_apprules set \n\t\t\t\t\t\t fd_apprules_no='{$no}' , fd_apprules_content='{$allcontent}'\t\t, fd_apprules_title='{$title}'\t,fd_apprules_type='{$type}'\n\t\t\t\t\t\t where fd_apprules_id ='{$id}'\t";
$db->query($query);
require "../include/alledit.2.php";
Header("Location: {$gotourl}");
<?php
$thismenucode = "2k103";
require "../include/common.inc.php";
$db = new db_test();
$gotourl = "../jxcbasic/tb_customer_b.php";
$actionurl = 'teller.php';
$t = new Template(".", "keep");
$t->set_file("template", "tellerlist.html");
$query = "select fd_cus_name from tb_customer where fd_cus_id='{$listid}'";
$db->query($query);
if ($db->nf()) {
$db->next_record();
$cusname = $db->f(fd_cus_name);
}
$arr_text = array("<INPUT onclick=CheckAll(this.form) type=checkbox value=on name=chkall>\t", "用户名", "用户状态", "操作");
for ($i = 0; $i < count($arr_text); $i++) {
$theadth .= ' <th>' . $arr_text[$i] . '</th>';
}
//显示列表
$t->set_block("template", "prolist", "prolists");
$query = "select * from tb_cus_teller where fd_tel_cusid='{$listid}'";
$count = 0;
//记录数
$db->query($query);
if ($db->nf()) {
while ($db->next_record()) {
$telid = $db->f(fd_tel_id);
$telname = $db->f(fd_tel_name);
$recsts = $db->f(fd_tel_recsts);
if ($recsts == 1) {
<?php
require "../include/common.inc.php";
header('Content-Type:text/html;charset=GB2312');
$db = new db_test();
$arr_toptradmarkid = explode(",", $toptradmarkid);
$query = "select fd_trademark_name,fd_procatrad_id,fd_trademark_id,fd_proca_catname,fd_procatrad_id,fd_proca_id,fd_procatrad_commjs,\n \t\t\t\t\t\t\t fd_procatrad_tradjs,fd_procatrad_commcs from web_conf_procatrademark\n\t left join tb_trademark on fd_trademark_id = fd_procatrad_trademarkid\n\t left join tb_procatalog on fd_proca_id = fd_procatrad_procaid\n where fd_procatrad_procaid in({$procaid}) group by fd_trademark_id";
$db->query($query);
if ($db->nf()) {
while ($db->next_record()) {
$trademarkid = $db->f(fd_trademark_id);
$trademarkname = $db->f(fd_trademark_name);
for ($i = 0; $i < count($arr_toptradmarkid); $i++) {
if ($arr_toptradmarkid[$i] == $trademarkid) {
$check = 'checked="true"';
} else {
$check = "";
}
}
$showcheck .= '<div style="width:120px;float:left;"><input type="checkbox" ' . $check . ' title="' . $trademarkid . '" name="arr_count[]" onclick="addPreItem()"
value="' . $trademarkname . '">' . $trademarkname . '</div>';
}
}
echo $showcheck;
<?php
require "../include/common.inc.php";
$db = new db_test();
$db1 = new db_test();
header('Content-Type:text/html;charset=GB2312');
$query = "select fd_ysyfm_money from tb_ysyfmoney \n where fd_ysyfm_type ='{$companytype}' and fd_ysyfm_companyid = '{$companyid}'";
$db->query($query);
if ($db->nf()) {
$db->next_record();
$yfk_show = $db->f(fd_ysyfm_money) + 0;
} else {
$yfk_show = "";
}
echo $yfk_show;
<?php
require "../include/common.inc.php";
header('Content-Type:text/html;charset=GB2312');
$db = new db_test();
//$showcheck ='<onclick="selectall();" id="selitmes">ȫѡ</a><br>';
if ($param == "fd_provinces_id") {
$query = "select * from tb_provinces order by fd_provinces_name ";
$db->query($query);
if ($db->nf()) {
while ($db->next_record()) {
$provincesid = $db->f(fd_provinces_id);
$provincesname = $db->f(fd_provinces_name);
$showcheck .= '<font style="width:120px;"><input type="checkbox" title="' . $provincesid . '" name="arr_content[]" onclick="addPreItem()"
value="' . $provincesname . '">' . $provincesname . '</font>';
}
}
} else {
if ($param == "fd_city_id") {
$query = "select * from tb_city order by fd_city_name ";
$db->query($query);
if ($db->nf()) {
while ($db->next_record()) {
$cityid = $db->f(fd_city_id);
$cityname = $db->f(fd_city_name);
$showcheck .= '<font style="width:120px;"><input type="checkbox" title="' . $cityid . '" name="arr_content[]" onclick="addPreItem()"
value="' . $cityname . '">' . $cityname . '</font>';
}
}
} else {
if ($param == "fd_county_id") {
function setUp()
{
parent::setUp();
$this->ac =& access_policy::instance();
}
<?php
require "../include/common.inc.php";
$db = new db_test();
$db1 = new db_test();
header('Content-Type:text/html;charset=GB2312');
$flagcomm = 0;
$query = "select * from tb_salelistdetail where fd_stdetail_seltid = '{$listid}'";
$db->query($query);
if ($db->nf()) {
while ($db->next_record()) {
$paycardid = $db->f(fd_stdetail_paycardid);
$productid = $db->f(fd_stdetail_productid);
$saleprice = $db->f(fd_stdetail_price);
$salequantity = $db->f(fd_stdetail_quantity);
$query = "select * from tb_paycardstockquantity \n\t\t where fd_skqy_commid = '{$productid}'";
$db1->query($query);
//查询仓库数量
if ($db1->nf()) {
$db1->next_record();
$storagequantity = $db1->f(fd_skqy_quantity) + 0;
if ($storagequantity < $salequantity) {
//$tmpquantity = $salequantity - $storagequantity;
$returnquantitypaycardid = $returnquantitypaycardid . "“" . $productid . "”当库存数量为：" . $storagequantity . "\n";
$flagcomm = 1;
}
}
$query = "select * from tb_storagecost \n\t\t where fd_sect_commid = '{$productid}'";
$db1->query($query);
//查询平均价格
if ($db1->nf()) {
