function changemoney($unittype, $clientid, $money, $type) { //$type =0表示应收 , 1表示应付 //$unittype = 2 表示供应商,1代表客户 //$clientid 往来单位id号 $db = new DB_test(); if ($type == 0) { $endmoney = $money; } else { $endmoney = -$money; } $query = "select * from tb_ysyfmoney where fd_ysyfm_type = '{$unittype}'\n\t and fd_ysyfm_companyid = '{$clientid}' "; $db->query($query); if ($db->nf()) { $db->next_record(); $oldmoney = $db->f(fd_ysyfm_money); $listid = $db->f(fd_ysyfm_id); $newmoney = $oldmoney + $endmoney; $query = "update tb_ysyfmoney set fd_ysyfm_money = '{$newmoney}'\n\t\t where fd_ysyfm_id = '{$listid}' "; $db->query($query); } else { $query = "insert into tb_ysyfmoney(\n\t fd_ysyfm_type , fd_ysyfm_companyid , fd_ysyfm_money \n\t )values(\n\t '{$unittype}' , '{$clientid}' , '{$endmoney}' \n\t )"; $db->query($query); } }
function checkstorage($batches, $commid, $endquantity, $cost, $listid, $listno, $listtype, $memo) { $db = new DB_test(); $query = "select fd_sect_cost from tb_storagecost where fd_sect_commid = '{$commid}' "; $db->query($query); //查出机构的平均价格 if ($db->nf()) { $db->next_record(); $oldcost = $db->f(fd_sect_cost); //平均价格 } $query = "select sum(fd_skqy_quantity) as allquantity from tb_paycardstockquantity \n\t where fd_skqy_commid = '{$commid}' "; $db->query($query); //计算该机构或者配送中心的库存数量。 if ($db->nf()) { $db->next_record(); $oldquantity = $db->f(allquantity); $newquantity = $oldquantity + $endquantity; if ($newquantity == 0) { $newmoney = $oldcost * $oldquantity + $cost * $endquantity; } else { $newmoney = 0; } } else { $newmoney = 0; } if ($newmoney != 0) { $formermoney = $oldcost * $oldquantity; $aftermoney = $cost * $endquantity; $query = "insert into tb_intocompensatory (\n \t fd_iocy_date , fd_iocy_listid , fd_iocy_listtype , \n \t fd_iocy_paycardid , fd_iocy_formermoney , fd_iocy_aftermoney , \n \t fd_iocy_memo , fd_iocy_formercost , fd_iocy_aftercost ,\n \t fd_iocy_listno , fd_iocy_formerquantity , fd_iocy_afterquantity \n \t )values(\n \t now() , '{$listid}' , '{$listtype}' ,\n \t '{$paycardid}' , '{$formermoney}' , '{$aftermoney}' ,\n \t '{$memo}' , '{$oldcost}' , '{$cost}' ,\n \t '{$listno}' , '{$oldquantity}' , '{$endquantity}' \n\t\t\t\n \t )"; $db->query($query); } return $newmoney; }
public function readHelpList() { $db = new DB_test(); $arr_header = $this->arr_header; $arr_body = $this->arr_body; $arr_channelinfo = $this->arr_channelinfo; $msgstart = $arr_body['msgstart'] + 0; $msgdisplay = $arr_body['msgdisplay'] + 0; if ($msgstart < 0) { $msgstart = 0; } $query = "select 1 from web_help order by fd_help_no "; $db->query($query); $msgallcount = $db->nf(); $query = "select fd_help_id as helpid ,fd_help_name as helpname,fd_help_contect as helpcontent,\n\t fd_help_date as helpdate from web_help order by fd_help_no limit {$msgstart}, {$msgdisplay} "; $db->query($query); $msgdiscount = $db->nf(); $arr_msg = auto_charset($db->getData('', 'msgbody'), 'gbk', 'utf-8'); $arr_message = array("result" => "success", "message" => "读取成功!"); $retcode = "0"; //反馈状态 0 成功 200 自定义错误 $arr_msg['msgbody']['msgallcount'] = $msgallcount; $arr_msg['msgbody']['msgdiscount'] = $msgdiscount + $msgstart; $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; }
function getmemkpFilepath($fcatid) { $db = new DB_test(); $query = "select * from tb_scategoty where fd_scat_fcatid='{$fcatid}'"; $db->query($query); if ($db->nf()) { while ($db->next_record()) { //没有上传显示空白 $arr_scatid[] = $db->f(fd_scat_id); $arr_fcatid[] = $db->f(fd_scat_fcatid); } } for ($i = 0; $i < count($arr_scatid); $i++) { $query = "select * from tb_category_list where fd_cat_scatid='{$arr_scatid[$i]}'"; $db->query($query); if ($db->nf()) { while ($db->next_record()) { $catid = $db->f(fd_cat_id); $filename = $db->f(fd_cat_name); $picname = $db->f(fd_cat_url); $thumrul = $db->f(fd_cat_thumurl); $display = $db->f(fd_cat_display); $arr_list[] = array("vid" => $catid, "scatid" => $arr_scatid[$i], "filename" => $filename, "picname" => $picname, "picurl" => $thumrul, "display" => $display); } } else { $arr_list[] = array("vid" => "", "scatid" => $arr_scatid[$i], "filename" => "", "picname" => "", "picurl" => "", "display" => ""); } } $returnarray = $arr_list; return $returnarray; }
function basicnumber_update($listtype) { $db = new DB_test(); $query = "select * from tb_basicnumber where fd_bcnr_typeid = '{$listtype}'"; $db->query($query); if ($db->nf()) { $db->next_record(); $tmp_basicnumber = $db->f(fd_bcnr_design); $ltctcount = $db->f(fd_bcnr_count) + 1; $query = "update tb_basicnumber set\n\t fd_bcnr_count = fd_bcnr_count+1\n\t where fd_bcnr_typeid = '{$listtype}' "; $db->query($query); if ($ltctcount < 10) { $endltctcount = "000" . $ltctcount; } elseif ($ltctcount < 10000 and $ltctcount >= 1000) { $endltctcount = $ltctcount; } elseif ($ltctcount < 1000 and $ltctcount >= 100) { $endltctcount = "0" . $ltctcount; } elseif ($ltctcount < 100 and $ltctcount >= 10) { $endltctcount = "00" . $ltctcount; } else { $endltctcount = $ltctcount; } $listno = str_replace("{list_number}", $endltctcount, $tmp_basicnumber); } return $listno; }
function order_creat_fplist($listid) { $db = new DB_test(); $db2 = new DB_test(); $dberp = new DB_erp2(); //读取发票申请 $query = "select * from web_invoicesq \n\t left join tb_organmem on fd_organmem_id = fd_ivcsq_memberid\n\t where fd_ivcsq_id = '{$listid}'"; $db->query($query); if ($db->nf()) { $db->next_record(); $iecrid = $db->f(fd_ivcsq_fpcusid); $iecrno = $db->f(fd_ivcsq_fpcusno); $iecrname = $db->f(fd_ivcsq_fpcusname); $orderid = $db->f(fd_ivcsq_orderid); $fptype = $db->f(fd_ivcsq_fptype); $money = $db->f(fd_ivcsq_money); $memo = $db->f(fd_ivcsq_memo); $fpusename = $db->f(fd_organmem_comnpany); $fpuseid = $db->f(fd_ivcsq_memberid); if ($invoicetype == "普通发票") { $invoicetype = 1; } else { $invoicetype = 0; } $s_orderid = implode(",", explode("@@@", $orderid)); $query = "select * from web_order \n where fd_order_id in ({$s_orderid}) "; $db->query($query); if ($db->nf()) { $db->next_record(); $sdcrid = $db->f(fd_order_sdcrid); if ($sdcrid == 1) { $mscompanyid = 1; //广州市明盛物流有限公司 } else { if ($sdcrid == 2) { $mscompanyid = 4; //上海粤琳珠物流有限公司 } else { if ($sdcrid == 3) { $mscompanyid = 13; //廊坊市明盛纸业有限公司 } else { if ($sdcrid == 4) { $mscompanyid = 9; } else { if ($sdcrid == 5) { $mscompanyid = 11; } } } } } } $issue = date("Y", mktime()) . date("m", mktime()); $listno = listnumber_update(); $query = "insert into tb_invoiceapply(\n\t fd_ieay_listno , fd_ieay_iecrid , fd_ieay_iecrno ,\n\t fd_ieay_iecrname , fd_ieay_sporganid , fd_ieay_date , \n\t fd_ieay_mscompanyid , fd_ieay_issue , fd_ieay_staname ,\n\t fd_ieay_invoicetype , fd_ieay_sdcrid , fd_ieay_cporganid , \n\t fd_ieay_xjmoney , fd_ieay_yhmoney , fd_ieay_spsdcrid ,\n\t fd_ieay_memo , fd_ieay_dziecrid , fd_ieay_sqinvoicetype ,\n\t fd_ieay_sqmscid , fd_ieay_sqyhmoney , fd_ieay_sqxjmoney ,\n\t fd_ieay_websqid , fd_ieay_fpuseid , fd_ieay_fpusename\n\t )values(\n\t '{$listno}' , '{$iecrid}' , '{$iecrno}' ,\n\t '{$iecrname}' , '1' , now() ,\n\t '{$mscompanyid}' , '{$issue}' , '网站' ,\n\t '{$invoicetype}' , '{$sdcrid}' , '1' , \n\t '0' , '{$money}' , '{$sdcrid}' ,\n\t '{$memo}' , '{$iecrid}' , '{$invoicetype}' ,\n\t '{$mscompanyid}' , '0' , '{$money}' ,\n\t '{$listid}' , '{$fpuseid}' , '{$fpusename}'\n\t )"; $dberp->query($query); } }
function listnumber_update($listtype) { //global $loginorganno ; $db = new DB_test(); $query = "select * from tb_listnumber where fd_ltnr_typeid = '{$listtype}'"; $db->query($query); if ($db->nf()) { $db->next_record(); $tmp_listnumber = $db->f(fd_ltnr_design); $isdateauto = $db->f(fd_ltnr_isdateauto); //是否自动生成 $datetype = $db->f(fd_ltnr_datetype); //日期格式 $year = date("Y", mktime()); $month = date("m", mktime()); $day = date("d", mktime()); if ($isdateauto == 1) { $sqlwhere = " and fd_ltct_date = '{$year}-{$month}-{$day}' "; } else { $sqlwhere = " "; } $ltctcount = 1; $query = "select * from tb_listcount where fd_ltct_ltnrtypeid = '{$listtype}' {$sqlwhere} "; $db->query($query); if ($db->nf()) { $db->next_record(); $ltctcount = $db->f(fd_ltct_count) + 1; $ltctid = $db->f(fd_ltct_id); $query = "update tb_listcount set\n\t fd_ltct_count = fd_ltct_count+1\n\t where fd_ltct_id = '{$ltctid}' "; $db->query($query); } else { $query = "insert into tb_listcount(\n\t fd_ltct_count , fd_ltct_date , fd_ltct_ltnrtypeid\n\t )values(\n\t 1 , now() , '{$listtype}'\n\t )"; $db->query($query); } if ($ltctcount < 10) { $endltctcount = "00" . $ltctcount; } elseif ($ltctcount < 100 and $ltctcount >= 10) { $endltctcount = "0" . $ltctcount; } else { $endltctcount = $ltctcount; } if ($datetype == 1) { //全年份得日期格式 $tmp_listnumber = str_replace("{listno_date}", $year . $month . $day, $tmp_listnumber); } else { $endyear = substr($year, 2, 2); $tmp_listnumber = str_replace("{listno_date}", $endyear . $month . $day, $tmp_listnumber); } $listno = str_replace("{list_number}", $endltctcount, $tmp_listnumber); } return $listno; }
function move($fd_cat_id) { $db = new DB_test(); $query = "select fd_cat_dateid,fd_cat_name,fd_cat_scatid,fd_cat_url,fd_cat_thumurl ,fd_cat_cancel from tb_upload_category_list where fd_cat_id='{$fd_cat_id}'"; $db->query($query); $db->next_record(); $fd_cat_dateid = $db->f(fd_cat_dateid); $fd_cat_scatid = $db->f(fd_cat_scatid); $fd_cat_name = $db->f(fd_cat_name); $fd_cat_url = $db->f(fd_cat_url); $fd_cat_thumurl = $db->f(fd_cat_thumurl); $fd_cat_cancel = $db->f(fd_cat_cancel); $query = "INSERT INTO tb_upload_old_image (\n\t\t\t\t\t\tfd_cat_dateid ,fd_cat_scatid , fd_cat_url,\n\t\t\t\t\t\tfd_cat_cancel ,fd_cat_time, fd_cat_thumurl,\n\t\t\t\t\t\tfd_cat_name\n\t\t\t\t\t )VALUES (\n\t\t\t\t\t '{$fd_cat_dateid}' ,'{$fd_cat_scatid}' , '{$fd_cat_url}',\n\t\t\t\t\t '{$fd_cat_cancel}' ,now() , '{$fd_cat_thumurl}',\n\t\t\t\t\t '{$fd_cat_name}'\n\t\t\t\t\t )"; $db->query($query); }
public function readKuaiDicmpList() { $db = new DB_test(); $arr_header = $this->arr_header; $arr_body = $this->arr_body; $arr_channelinfo = $this->arr_channelinfo; $apptype = trim($arr_body['apptype']); $appversion = trim($arr_body['appversion']); $query = "select fd_kdcompany_id as comid,fd_kdcompany_no as com,fd_kdcompany_name as comname\n\t\t ,fd_kdcompany_api as apitype,fd_kdcompany_pic as comlogo ,fd_kdcompany_phone as comphone from \n\t tb_kdcompany where fd_kdcompany_active = '1' order by fd_kdcompany_api desc"; //只显示激活的列表 $db->query($query); $arr_msg = auto_charset($db->getData('', 'msgbody'), 'gbk', 'utf-8'); if (!$arr_msg) { $arr_message = array("result" => "failure", "message" => "列表为空!"); $retcode = "200"; //反馈状态 0 成功 200 自定义错误 } else { $arr_message = array("result" => "success", "message" => "读取成功!"); $retcode = "0"; //反馈状态 0 成功 200 自定义错误 } $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; }
public function validateUser() { $retcode = "200"; $arr_message = array("result" => "fail", "message" => "操作出现异常,请稍后再试!"); $db = new DB_test(); $phonenumber = trim($this->arr_body['phonenumber']); $query = "SELECT fd_author_id FROM tb_author WHERE fd_author_username = '******'"; $authorid = $db->get_all($query); if ($authorid != 0 && count($authorid) > 0) { $authorid = $authorid[0]["fd_author_id"]; $query = "SELECT Q.fd_question_contect AS que, A.fd_answer AS answer \n\t\t\t\t\tFROM tb_safeguard_secque_useranswer AS A \n\t\t\t\t\tINNER JOIN tb_safeguard_secque AS Q ON A.fd_question_id = Q.fd_question_id \n\t\t\t\t\tWHERE A.fd_author_id = " . $authorid; $db->query($query); $retcode = "0"; if ($db->nf() > 0) { $arr_msg = auto_charset($db->getData('', 'msgbody'), 'gbk', 'utf-8'); $arr_msg['msgbody']['authorid'] = $authorid; $arr_message = array("result" => "success", "message" => "成功获取密保问题"); } else { $retcode = "200"; $arr_message = array("result" => "failure", "message" => "您还未设置过密保问题"); } } else { $retcode = "200"; $arr_message = array("result" => "failure", "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; }
function addelete($dateid, $scatid, $display) { $db = new DB_test(); if ($display == 1) { $query = "update tb_category_list set fd_cat_display='0' where fd_cat_scatid='{$scatid}' \n\t\t\t\t and fd_cat_dateid ='{$dateid}' "; $db->query($query); } }
function kickbackaccountcussent($accountid, $supaccountid, $allmoney, $listtype, $makename, $listid, $listno, $listdate, $memo, $kickbackid) { $db = new DB_test(); $ishaverecord = 0; $query = "select * from tb_accountcussent where fd_atct_accountid = '{$accountid}' and fd_atct_supaccountid = '{$supaccountid}'\n\t and fd_atct_listid = '{$kickbackid}' and fd_atct_listtype = '{$listtype}' "; $db->query($query); if ($db->nf()) { $ishaverecord = 1; } if ($allmoney != 0 && $ishaverecord == 0) { $query = "insert into tb_accountcussent(\n fd_atct_listid , fd_atct_listno , fd_atct_listtype , \n fd_atct_listdate , fd_atct_accountid , fd_atct_supaccountid ,\n fd_atct_date , fd_atct_money , fd_atct_makename ,\n fd_atct_memo , fd_atct_datetime , fd_atct_iskickback\n )values(\n '{$kickbackid}' , '{$listno}' , '{$listtype}' ,\n '{$listdate}' , '{$accountid}' , '{$supaccountid}' ,\n now() , '{$allmoney}' , '{$makename}' ,\n '{$memo}' , now() , '2'\n )"; $db->query($query); $query = "update tb_accountcussent set fd_atct_iskickback = 1 \n where fd_atct_listtype = '{$listtype}' and fd_atct_listid = '{$listid}' \n and fd_atct_accountid = '{$accountid}'"; $db->query($query); //修改该单据的反冲状态 } }
function clearFilepath($id) { $db = new DB_test(); $query = "update tb_ggwgl set fd_ggwgl_url='',fd_ggwgl_thumurl='' where fd_ggwgl_id='{$id}'"; $db->query($query); $returnvalue = "success"; return $returnvalue; }
function kickbackcashglide($accountid, $allmoney, $chgememo, $chgelisttype, $loginstaname, $listid, $listno, $cogetype, $kickbackid, $listdate) { $db = new DB_test(); $ishaverecord = 0; $query = "select * from tb_cashglide where fd_chge_accountid = '{$accountid}' \n\t and fd_chge_listid = '{$kickbackid}' and fd_chge_listtype = '{$chgelisttype}' "; $db->query($query); if ($db->nf()) { $ishaverecord = 1; } if ($allmoney != 0 && $ishaverecord == 0) { //----------帐户流水帐---------------- $query = "SELECT MAX(fd_chge_id) as chge_id FROM tb_cashglide where \n fd_chge_accountid = '{$accountid}' "; $db->query($query); if ($db->nf()) { $db->next_record(); $maxchgeid = $db->f(chge_id); $query = "select fd_chge_balance from tb_cashglide \n where fd_chge_id = '{$maxchgeid}' "; $db->query($query); if ($db->nf()) { $db->next_record(); $chgebalance = $db->f(fd_chge_balance); } else { $chgebalance = 0; } } else { $chgebalance = 0; } if ($allmoney != 0) { //金额不等于0 的才插进去。 if ($cogetype == 0) { $endchgebalance = $chgebalance + $allmoney; $query = "insert into tb_cashglide(\n fd_chge_date , fd_chge_accountid , fd_chge_listid , \n fd_chge_listno , fd_chge_listtype , fd_chge_addmoney ,\n fd_chge_lessen , fd_chge_balance , fd_chge_memo ,\n fd_chge_makename, fd_chge_datetime , fd_chge_iskickback ,\n fd_chge_listdate\n )values(\n now() , '{$accountid}' , '{$kickbackid}' ,\n '{$listno}' , '{$chgelisttype}' , '{$allmoney}' ,\n '0' , '{$endchgebalance}' , '{$chgememo}' ,\n '{$loginstaname}', now() , '2' ,\n '{$listdate}'\n )"; $db->query($query); } else { $endchgebalance = $chgebalance - $allmoney; $query = "insert into tb_cashglide(\n fd_chge_date , fd_chge_accountid , fd_chge_listid , \n fd_chge_listno , fd_chge_listtype , fd_chge_addmoney ,\n fd_chge_lessen , fd_chge_balance , fd_chge_memo ,\n fd_chge_makename, fd_chge_datetime , fd_chge_iskickback ,\n fd_chge_listdate\n )values(\n now() , '{$accountid}' , '{$kickbackid}' ,\n '{$listno}' , '{$chgelisttype}' , '0' ,\n '{$allmoney}' , '{$endchgebalance}' , '{$chgememo}' ,\n '{$loginstaname}', now() , '2' ,\n '{$listdate}'\n )"; $db->query($query); } $query = "update tb_cashglide set fd_chge_iskickback = 1 \n where fd_chge_listtype = '{$chgelisttype}' and fd_chge_listid = '{$listid}' \n and fd_chge_accountid = '{$accountid}'"; $db->query($query); //修改该单据的反冲状态 } } //------------------------------------ }
function kickbackcurrentaccount($ctatlinktype, $companyid, $addmoney, $lessenmoney, $ctatmemo, $cactlisttype, $loginstaname, $listid, $listno, $kickbackid, $listdate) { $db = new DB_test(); $ishaverecord = 0; $query = "select * from tb_currentaccount where fd_ctat_linkid = '{$companyid}' and fd_ctat_linktype = '{$ctatlinktype}'\n\t and fd_ctat_listid = '{$kickbackid}' and fd_ctat_listtype = '{$cactlisttype}' "; $db->query($query); if ($db->nf()) { $ishaverecord = 1; } if ($ishaverecord == 0) { $endctatbalance = 0; $query = "insert into tb_currentaccount(\n fd_ctat_date , fd_ctat_linktype , fd_ctat_linkid , \n fd_ctat_listno , fd_ctat_listtype , fd_ctat_addmoney ,\n fd_ctat_lessen , fd_ctat_balance , fd_ctat_memo ,\n fd_ctat_listid , fd_ctat_makename , fd_ctat_iskickback ,\n fd_ctat_datetime , fd_ctat_listdate\n )values(\n now() , '{$ctatlinktype}' , '{$companyid}' ,\n '{$listno}' , '{$cactlisttype}' , '{$addmoney}' ,\n '{$lessenmoney}' , '{$endctatbalance}' , '{$ctatmemo}' ,\n '{$kickbackid}' , '{$loginstaname}' , '2' ,\n now() , '{$listdate}'\n )"; $db->query($query); $query = "update tb_currentaccount set fd_ctat_iskickback = 1 \n where fd_ctat_listtype = '{$cactlisttype}' and fd_ctat_listid = '{$listid}' "; $db->query($query); //修改该单据的反冲状态 //------------------------------------ } }
function getimageid($picurl) { $db = new DB_test(); $query = "select fd_cat_id from tb_category_list where fd_cat_url ='{$picurl}'"; $db->query($query); if ($db->nf()) { $db->next_record(); $id = $db->f(fd_cat_id); } return $id; }
/** +---------------------------------------------------------- * 获取商品单价 * +---------------------------------------------------------- * @access public +---------------------------------------------------------- * @param string $agencyid 机构id * @param string $sdcrid 商家id * @param string $produreid 商品id * @param string $producetype 商品类型id * @param string $storageid 商品仓库id * @param string $pricetype 价格类型 (0=本位价格,20=令价,21=吨价) +---------------------------------------------------------- * @return string +---------------------------------------------------------- */ function getsdcrprice($agencyid, $sdcrid, $produreid, $producetype, $storageid, $pricetype = 0) { global $g_lprice_point; global $g_dprice_point; $db = new DB_test(); $query = "select fd_nbsepe_sdcrid,fd_nbsepe_produreid,fd_produre_catalog,fd_nbsepe_lingprice,fd_nbsepe_dunprice,fd_produre_unit\n\t\t\t from tb_websaleprice left join tb_produre on fd_produre_id = fd_nbsepe_produreid\n\t\t\t where fd_nbsepe_iskc = '1' and fd_nbsepe_sdcrid = '" . $sdcrid . "'\n\t\t\t and fd_nbsepe_produreid = '" . $produreid . "' and fd_nbsepe_producetype = '" . $producetype . "' \n\t\t\t and fd_nbsepe_isshow='1'"; // echo $query; $db->query($query); if ($db->nf()) { while ($db->next_record()) { $areaid = $db->f(fd_nbsepe_sdcrid); $produreid = $db->f(fd_nbsepe_produreid); $boxprocaid = $db->f(fd_produre_catalog); $unitid = $db->f(fd_produre_unit); if ($unitid == 20) { $returnvalue = round($db->f(fd_nbsepe_lingprice) * 1.04, 3); } if ($unitid == 21) { $returnvalue = round($db->f(fd_nbsepe_dunprice) * 1.04, 0); } if ($pricetype == 20) { $returnvalue = round($db->f(fd_nbsepe_lingprice) * 1.04, 3); } if ($pricetype == 21) { $returnvalue = round($db->f(fd_nbsepe_dunprice) * 1.04, 0); } } } $dbshop = new DB_shop(); $query = "select fd_skqy_lingprice ,fd_skqy_dunprice,fd_skqy_unitid,\n\t\t\tfd_skqy_shopid,fd_skqy_commid ,fd_skqy_rate \n\t\t\tfrom tb_shopkcquantity where fd_skqy_shopid = '{$sdcrid}' and fd_skqy_commid= '{$produreid}'\n\t\t\tand fd_skqy_producetype = '{$producetype}' and fd_skqy_storageid= '{$storageid}'\n\t\t\t"; $dbshop->query($query); if ($dbshop->nf()) { while ($dbshop->next_record()) { $unitid = $dbshop->f(fd_skqy_unitid); $vlingprice = $dbshop->f(fd_skqy_lingprice); $vdunprice = $dbshop->f(fd_skqy_dunprice); $rate = $dbshop->f(fd_skqy_rate); if ($unitid == 20) { $returnvalue = formatprice($vlingprice * $rate, $g_lprice_point); } if ($unitid == 21) { $returnvalue = formatprice($vdunprice * $rate, $g_dprice_point); } if ($pricetype == 20) { $returnvalue = formatprice($vlingprice * $rate, $g_lprice_point); } if ($pricetype == 21) { $returnvalue = formatprice($vdunprice * $rate, $g_dprice_point); } } } return $returnvalue + 0; }
function dodelete() { // 删除过程 $db = new DB_test(); for ($i = 0; $i < count($this->browse_check); $i++) { $query = "update tb_paycard set fd_paycard_authorid='' where fd_paycard_authorid=" . $this->browse_check[$i] . ""; $db->query($query); $query = sprintf($this->browse_delsql, $this->browse_check[$i]); $this->db->query($query); //删除点击的记录 } }
public static function checkagpmbkntno($bkntno) { $db = new DB_test(); $query = "select fd_agpm_bkntno as bkntno from tb_agentpaymoneylist where fd_agpm_bkntno = '{$bkntno}'"; //$query="select fd_agpm_bkntno as bkntno from tb_agentpaymoneylist where fd_agpm_bkntno = '201308212125170033372'"; $db->query($query); if ($db->nf()) { return "1"; } else { return "0"; } //return $db->execute($query); // 0 1 }
function getggimg($scatid, $dateid) { $db = new DB_test(); $arr_img = explode("@@", $this->AutogetFileimg($scatid, $dateid)); //��ѯ��� $query = "select fd_ggwgl_link from tb_upload_ggwgl where fd_ggwgl_id = '{$dateid}'"; $db->query($query); if ($db->nf()) { $db->next_record(); $ggurl = $db->f(fd_ggwgl_link); } return $arr_img[0] . "@@" . $ggurl; }
public function YiBaoPayFeedback($payResult, $orderId) { if ($payResult["r1_Code"] == "1") { $db = new DB_test(); $query = "update tb_transfermoneyglist set fd_tfmglist_payrq ='00' ,fd_tfmglist_paydate = NOW(), fd_tfmglist_bkntno = '" . $payResult['r2_TrxId'] . "' where fd_tfmglist_bkordernumber = '{$orderId}'"; $db->query($query); $query = "update tb_agentpaymoneylist set fd_agpm_payrq = '00', fd_agpm_bkntno = '" . $payResult['r2_TrxId'] . "' where fd_agpm_bkordernumber = '{$orderId}'"; $db->query($query); $query = "select 1 from tb_cus_fenrunglist where 1 and fd_frlist_bkordernumber = '" . $orderId . "' limit 1"; if ($db->execute($query)) { } else { $query = "SELECT fd_tfmglist_authorid AS authorid, fd_author_cusid AS cusid, fd_tfmglist_paycardid AS paycardid, fd_tfmglist_paydate AS paydate, fd_tfmglist_paymoney AS paymoney, fd_tfmglist_payfee AS payfee, fd_tfmglist_sdcrpayfeemoney AS sdcrpayfeemoney, fd_tfmglist_paytype AS paytype, fd_tfmglist_sdcrpayfeemoney FROM tb_transfermoneyglist WHERE fd_tfmglist_bkordernumber = '{$orderId}'"; if ($db->execute($query)) { $arr_info = $db->get_one($query); $cusfee = 0; $tfbfenrun = 0; $cusfeeResult = getcusfenrun::get_cusfenrun($arr_info['cusid'], $arr_info['paytype'], $arr_info['payMoney'], $arr_info['fd_tfmglist_sdcrpayfeemoney'], $arr_info['fd_tfmglist_payfee'], 0, date("Y-m-d"), null, null); $cusfee = $cusfeeResult["cusfee"]; $tfbfenrun = $arr_cusfee['tfbfenrun']; unset($dateArray); $dateArray['fd_frlist_authorid'] = $arr_info['authorid']; $dateArray['fd_frlist_cusid'] = $arr_info['cusid']; $dateArray['fd_frlist_paycardid'] = $arr_info['paycardid']; $dateArray['fd_frlist_paydate'] = $arr_info['paydate']; $dateArray['fd_frlist_paymoney'] = $arr_info['paymoney']; $dateArray['fd_frlist_payfee'] = $arr_info['payfee']; $dateArray['fd_frlist_cusfee'] = $cusfee; $dateArray['fd_frlist_bkordernumber'] = $orderId; $dateArray['fd_frlist_payrq'] = '00'; $dateArray['fd_frlist_paytype'] = $arr_info['paytype']; $dateArray['fd_frlist_sdcrid'] = 3; $dateArray['fd_frlist_sdcrpayfeemoney'] = $arr_info['sdcrpayfeemoney']; $dateArray['fd_frlist_tfbfenrun'] = $tfbfenrun; $dateArray['fd_frlist_datetime'] = date("Y-m-d H:i:s"); $db->insert("tb_cus_fenrunglist", $dateArray); } } } }
function changenbmoney($qkorganid, $money, $type, $organid, $sdcrid) { //$type =0表示应收 , 1表示应付 $tmpflag = 0; $db = new DB_test(); if ($type == 0) { $endmoney = $money; } else { $endmoney = -$money; } $query = "select * from tb_nbysyfmoney where fd_nbysyfm_qkorganid = '{$qkorganid}'\n\t and fd_nbysyfm_organid = '{$organid}' and fd_nbysyfm_sdcrid = '{$sdcrid}' "; $db->query($query); if ($db->nf()) { $db->next_record(); $oldmoney = $db->f(fd_nbysyfm_money); $listid = $db->f(fd_nbysyfm_id); $newmoney = $oldmoney + $endmoney; $query = "update tb_nbysyfmoney set fd_nbysyfm_money = '{$newmoney}'\n\t\t where fd_nbysyfm_id = '{$listid}' "; $db->query($query); $tmpflag = 1; } $query = "select * from tb_nbysyfmoney where fd_nbysyfm_organid = '{$qkorganid}'\n\t and fd_nbysyfm_qkorganid = '{$organid}' and fd_nbysyfm_sdcrid = '{$sdcrid}'"; $db->query($query); if ($db->nf()) { $db->next_record(); $oldmoney = $db->f(fd_nbysyfm_money); $listid = $db->f(fd_nbysyfm_id); $newmoney = $oldmoney - $endmoney; $query = "update tb_nbysyfmoney set fd_nbysyfm_money = '{$newmoney}'\n\t\t where fd_nbysyfm_id = '{$listid}' "; $db->query($query); $tmpflag = 1; } if ($tmpflag == 0) { $query = "insert into tb_nbysyfmoney(\n\t fd_nbysyfm_qkorganid , fd_nbysyfm_money ,\n\t fd_nbysyfm_organid , fd_nbysyfm_sdcrid\n\t )values(\n\t '{$qkorganid}' , '{$endmoney}' ,\n\t '{$organid}' , '{$sdcrid}'\n\t )"; $db->query($query); //应收款 } }
public static function Feedback($result, $orderId) { $logger = Logger::getLogger("ofpay"); $logger->info("开始分析手机充值返回的结果,订单号({$orderId})"); // if(isset($result->retcode) && $result->retcode == 1 && isset($result->game_state) && $result->game_state == 1) if (isset($result->retcode) && $result->retcode == 1) { $logger->info("正在分析手机充值返回的结果 : 通付宝订单号({$orderId}) 充值成功"); $db = new DB_test(); $query = "UPDATE tb_mobilerechargelist SET fd_mrclist_payrq = '00', fd_mrclist_ofstate = 1 \n\t\t\t\t\tWHERE fd_mrclist_bkordernumber = '" . $orderId . "'"; $logger->debug("完成手机充值 : 回写状态进通付宝数据库({$query})"); $db->query($query); } else { $logger->error("完成手机充值 : 充值失败"); } }
function getappname($appmnuid) { $db = new DB_test(); if (!$appmnuid) { $appmnuid = 0; } $query = "select fd_appmnu_name from tb_appmenu where fd_appmnu_id in({$appmnuid})"; $db->query($query); if ($db->nf()) { while ($db->next_record()) { $appname .= $db->f('fd_appmnu_name') . " "; } } return $appname; }
function getauqrzname($auqid) { $db = new DB_test(); if (!$auqid) { $auqid = 0; } $query = "select fd_auq_name from tb_authorquali where fd_auq_id in({$auqid})"; $db->query($query); if ($db->nf()) { while ($db->next_record()) { $auqname .= $db->f('fd_auq_name') . " "; } } return $auqname; }
public function modifyAuBkCardInfo() { $db = new DB_test(); $arr_header = $this->arr_header; $arr_body = $this->arr_body; $arr_channelinfo = $this->arr_channelinfo; $authorid = trim($arr_channelinfo['authorid']); $shoucardman = u2g(trim($arr_body['aushoucardman'])); $shoucardphone = trim($arr_body['aushoucardphone']); $shoucardno = trim($arr_body['aushoucardno']); $shoucardbank = u2g(trim($arr_body['aushoucardbank'])); $query = "select * from tb_author where fd_author_id = '{$authorid}' and fd_author_couponstate='1'"; $db->query($query); if ($db->nf()) { $arr_message = array("result" => "failure", "message" => "银行卡资料已经审批,如需修改请联系客服!"); $retcode = "200"; //反馈状态 0 成功 200 自定义错误 $Error = array('result' => 'failure', 'retcode' => '200', 'retmsg' => $arr_message['message']); $arr_msg['msgbody'] = array("result" => "failure", "message" => "银行卡资料已经审批,如需修改请联系客服!"); $retcode = "200"; //反馈状态 0 成功 200 自定义错误 $returnvalue = array("msgbody" => $arr_msg['msgbody']); $returnval = TfbxmlResponse::ResponsetoApp($retcode, $returnvalue); return $returnval; //$ErrorReponse->reponError($Error); //出错反馈 //return false; } $query = "update tb_author set fd_author_shoucardman = '{$shoucardman}',\n\t\t\t fd_author_shoucardphone = '{$shoucardphone}',\n\t\t\t fd_author_shoucardno='{$shoucardno}',\n\t\t\t fd_author_shoucardbank='{$shoucardbank}',fd_author_couponstate = '0' where fd_author_id = '{$authorid}' "; $db->query($query); $arr_msg['msgbody'] = array("error_id" => "0", "result" => "success", "message" => "恭喜您,我的银行卡修改成功!"); $retcode = "0"; //反馈状态 0 成功 200 自定义错误 $returnvalue = array("msgbody" => $arr_msg['msgbody']); $returnval = TfbxmlResponse::ResponsetoApp($retcode, $returnvalue); return $returnval; }
function readsalebackdunshu($year, $month, $memid) { $db = new DB_test(); $dberp = new DB_erp2(); $query = "select * from tb_organmem where fd_organmem_id = '{$memid}'"; $db->query($query); $db->next_record(); $cusid = $db->f(fd_organmem_cusid); $month = $month + 0; $year = $year + 0; $query = "select \n sum(fd_sebk_alldunshu) as allquantity,\n fd_sebk_cusid\n from tb_saleback \n left join tb_salelist on fd_sebk_salelistid = fd_selt_id\n where year(fd_selt_date) = '{$year}' and month(fd_sebk_date) = '{$month}' and fd_sebk_state = 1\n and fd_sebk_iskickback = 0 and fd_sebk_organid = 1 and fd_sebk_cusid = '{$cusid}'\n group by fd_sebk_cusid\n "; $dberp->query($query); $dberp->next_record(); $dunshu = $dberp->f(allquantity); return $dunshu; }
function getsalepaycardbackstate() { $db = new DB_test(); $query = "select fd_selt_state as state,fd_stdetail_paycardid as paycardid,fd_selt_date as date,fd_stdetail_memo as memo from tb_salelistbackdetail\n\tleft join tb_salelistback on fd_selt_id=fd_stdetail_seltid"; $db->query($query); $arr_data = $db->getFiledData(); foreach ($arr_data as $value) { $arr_pacardid = explode(",", $value['paycardid']); foreach ($arr_pacardid as $v1) { $arr_state[$v1]['state'] = $value['state']; $arr_state[$v1]['date'] = $value['date']; $arr_state[$v1]['memo'] = $value['memo']; } } return $arr_state; }
function makeorderno($tablename, $fieldname, $preno = "pay") { $db = new DB_test(); $db2 = new DB_test(); $year = trim(date("Y", mktime())); $month = trim(date("m", mktime())); $day = trim(date("d", mktime())); $strlenght = strlen($preno); $nowdate = $year . $month . $day; $query = "select fd_" . $fieldname . "_no as no from " . $tablename . " order by fd_" . $fieldname . "_no desc"; $db2->query($query); if ($db2->nf()) { $db2->next_record(); $orderno = $db2->f(no); $orderdate = substr($orderno, $strlenght, 8); //截取前8位判断是否当前日期 if ($nowdate == $orderdate) { $newlenght = $strlenght + 11; $orderno = substr($orderno, $newlenght, 14) + 1; //是当前日期流水帐加1 if ($orderno < 10) { $orderno = "00000" . $orderno; } else { if ($orderno < 100) { $orderno = "0000" . $orderno; } else { if ($orderno < 1000) { $orderno = "000" . $orderno; } else { if ($orderno < 10000) { $orderno = "00" . $orderno; } else { $orderno = $orderno; } } } } $orderno = $preno . $nowdate . $orderno; } else { $orderno = $preno . $nowdate . "000001"; //不是当前日期,为5位流水帐,开始值为1。 } } else { $orderno = $preno . $nowdate . "000001"; } return $orderno; }
function authorReg() { $db = new DB_test(); $arr_header = $this->arr_header; $arr_body = $this->arr_body; $arr_channelinfo = $this->arr_channelinfo; $aumobile = trim($arr_body['aumobile']); $aupassword = trim(md5($arr_body['aupassword'])); $autruename = u2g(trim($arr_body['autruename'])); $auidcard = trim($arr_body['auidcard']); $auemail = trim($arr_body['auemail']); $query = "select 1 from tb_author where fd_author_username = '******'"; $db->query($query); if ($db->nf()) { $arr_message = array("result" => "failure", "message" => "该手机号码已注册"); $retcode = "200"; //反馈状态 0 成功 200 自定义错误 $havemobile = 1; } else { $havemobile = 0; } if ($havemobile != 1) { $query = "insert into tb_author (fd_author_password ,fd_author_mobile ,fd_author_truename,\n\t\t\t\t\t\t\t fd_author_idcard,fd_author_email ,fd_author_username,fd_author_regtime,fd_author_datetime \n\t\t\t\t\t\t\t )values( '{$aupassword}' ,'{$aumobile}','{$autruename}','{$auidcard}','{$auemail}','{$aumobile}',now(),now())"; $db->query($query); $listid = $db->insert_id(); $sdcrid = 3; $auindustryid = 4; $slotpayfsetid = 8; $slotscdmsetid = 14; $bkcardpayfsetid = 25; $bkcardscdmsetid = 9; $memid = 3554; $shopid = 102; $authortypeid = 5; $query = "update tb_author set \n\t\t\t\t\t fd_author_isstop='0'," . "fd_author_state = '9'," . "fd_author_sdcrid = '{$sdcrid}'," . "fd_author_auindustryid = '{$auindustryid}',\n\t\t fd_author_slotpayfsetid = '{$slotpayfsetid}',\n\t\t fd_author_slotscdmsetid = '{$slotscdmsetid}',\n\t\t\t\t\t fd_author_bkcardpayfsetid='{$bkcardpayfsetid}',\n\t\t\t\t\t fd_author_bkcardscdmsetid='{$bkcardscdmsetid}' ,\n\t\t\t\t\t fd_author_couponstate = 0 ," . "fd_author_memid = '{$memid}'," . "fd_author_shopid = '{$shopid}'," . "fd_author_authortypeid = '{$authortypeid}' \n\t\t\t\t\t \t\t\t\t\t\t\n\t\t\t\t\t where fd_author_id='{$listid}'"; $db->query($query); $arr_message = array("result" => "success", "message" => "恭喜您,注册成功!"); $retcode = "0"; //反馈状态 0 成功 200 自定义错误 } $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; }