if ($db->nf()) { $db->next_record(); $paycardid = $db->f(fd_stdetail_paycardid); $arr_paycardid1 = explode(",", $paycardid); foreach ($arr_paycardid1 as $va) { if ($strpaycardid) { $strpaycardid .= "," . "'{$va}'"; } else { $strpaycardid = "'{$va}'"; } } } if ($strpaycardid) { $query = "SELECT fd_paycard_batches , fd_paycard_key , fd_product_suppname FROM tb_paycard LEFT JOIN tb_product ON fd_paycard_product = fd_product_id WHERE fd_paycard_id IN ({$strpaycardid})"; $db->query($query); $rows2 = $db->num_rows(); $t->set_block("salebackview", "prolist", "prolists"); if ($db->nf()) { while ($db->next_record()) { $lprobatches = $db->f(fd_paycard_batches); //批次号 $lprokey = $db->f(fd_paycard_key); //刷卡器设备号 $lprosuppname = $db->f(fd_product_suppname); //供应商 $count++; $trid = "tr" . $count; $imgid = "img" . $count; if ($s == 1) { $bgcolo = "#F1F4F9"; $s = 0;
function getPassenger() { $authorid = trim($this->arr_channelinfo['authorid']); // 必填 $type = trim($this->arr_body['type']); // 必填 if($authorid != "") { if($type == "1") // 读取乘机人 { $sql = "SELECT id, name, card_type AS cardType, card_id AS cardId, phone AS phoneNumber, type AS passengerType, gender FROM ctrip_airticket_passenger WHERE is_active = 1 AND user_id = " . $authorid; } else if($type == "2") // 读取联系人 { $sql = "SELECT id, name, phone AS phoneNumber FROM ctrip_airticket_contacter WHERE is_active = 1 AND user_id = " . $authorid; } } if(isset($sql)) { $db = new DB_test(); $db->query($sql); $arr_msg = auto_charset($db->getData('', 'msgbody'), 'gbk', 'utf-8'); $retcode = "0"; $arr_message = array("result" => "success", "message" => ""); if($db->num_rows() == 0) { $retcode = "200"; $arr_message = array("result" => "fail", "message" => "没有保存过相关信息"); } } else { $arr_message = array("result" => "fail", "message" => "信息不完整"); } $arr_msg['msgbody']['result'] = $arr_message['result']; $arr_msg['msgbody']['message'] = $arr_message['message']; $returnvalue = array ("msgbody" => $arr_msg['msgbody']); $returnval = TfbxmlResponse :: ResponsetoApp($retcode, $returnvalue); return $returnval; }
Header("Location: {$gotourl}"); break; default: break; } if (!empty($sel_condit)) { $querywhere .= " and " . $sel_condit . " like '%" . $txtCondit . "%'"; } $t = new Template(".", "keep"); //调用一个模版 $t->set_file("selagentbkno", "selagentbkno.html"); //显示列表 $t->set_block("selagentbkno", "prolist", "prolists"); $query = "select \n case \n when fd_agpm_paytype ='coupon' then '购买抵用券'\n when fd_agpm_paytype ='creditcard' then '信用卡还款'\n when fd_agpm_paytype ='recharge' then '充值'\n when fd_agpm_paytype ='repay' then '还贷款'\n when fd_agpm_paytype ='order' then '订单付款'\n when fd_agpm_paytype ='tfmg' then '转账汇款'\n else '其他业务' END paytype,\n\n case\n when fd_agpm_payfeedirct ='f' then fd_agpm_paymoney\n when fd_agpm_payfeedirct ='s' then (fd_agpm_paymoney-fd_agpm_payfee)\n else fd_agpm_paymoney END money,\n\n fd_agpm_id as agpm_id,\n fd_agpm_bkordernumber as bkordernumber,\n fd_agpm_no as agpm_no,\n fd_agpm_bkntno as bkntno,\n fd_paycard_key as paycardkey,\n fd_author_truename as author,\n fd_agpm_paydate as paydate,\n fd_agpm_shoucardno as shoucardno,\n fd_agpm_shoucardbank as shoucardbank,\n fd_agpm_shoucardman as shoucardman,\n fd_agpm_shoucardmobile as shoucardmobile,\n fd_agpm_current as current,\n fd_agpm_paymoney as paymoney ,\n fd_agpm_payfee as payfee,\n fd_agpm_arrivemode as arrivemode,\n fd_agpm_arrivedate as arrivedate,\n fd_sdcr_name as sdcrname,\n fd_agpm_memo as memo\n from tb_agentpaymoneylist\n left join tb_paycard on fd_agpm_paycardid = fd_paycard_id\n left join tb_author on fd_author_id = fd_agpm_authorid\n left join tb_sendcenter on fd_sdcr_id = fd_agpm_sdcrid\n where fd_agpm_payrq = '00' and fd_agpm_state = 1 and (fd_agpm_paystate = 0 or fd_agpm_paystate is null ) and fd_agpm_paytype='{$paytype}' {$querywhere}\n order by fd_agpm_no"; $db->query($query); $total = $db->num_rows($result); pageft($total, 20, $url); if ($firstcount < 0) { $firstcount = 0; } $query = "{$query} limit {$firstcount},{$displaypg}"; $db->query($query); $rows = $db->num_rows(); $arr_result = $db->getFiledData(''); $count = 0; foreach ($arr_result as $value) { $count++; $value['count'] = $count; $value['arrivemode'] = "T+" . $value['arrivemode']; $all_paymoney += $value['paymoney']; $all_payfee += $value['payfee'];
} else { $where = 0; } $t->set_block("stockbackprint", "prolist", "prolists"); /*$query = "select fd_product_no as lprono, fd_product_name as lproname, fd_skdetail_price as lprice, fd_skdetail_id as lstdetailid, fd_skdetail_quantity as lquantity, fd_skdetail_memo as lpromemo from tb_paycardstockbackdetail left join tb_product on fd_product_id = fd_skdetail_productid where fd_skdetail_stockid = '$listid'"; */ $query = "select * from tb_paycard \n\t\tleft join tb_paycardstockbackdetail on fd_skdetail_productid=fd_paycard_product\n\t\tleft join tb_product on fd_product_id = fd_skdetail_productid\n\t\twhere {$where} group by fd_paycard_id"; $db->query($query); $rows = $db->num_rows(); $count = 0; //商品记录数 $prosumnum = 0; //商品总数量 $prosumprice = 0; //商品总价 if ($db->nf()) { while ($db->next_record()) { $lprono = $db->f(fd_product_no); //商品编号 $lproname = $db->f(fd_product_name); //商品名称 $lprice = $db->f(fd_paycard_stockprice); //商品单价 $lstdetailid = $db->f(fd_skdetail_id);