function AutogetFileimg_id($scatid, $id)
{
//global "";
global $g_propic;
$dbfile = new db_test();
$query = "select * from tb_upload_category_list where fd_cat_scatid='{$scatid}' and fd_cat_id = '{$id}'";
$dbfile->query($query);
if ($dbfile->nf()) {
$dbfile->next_record();
$catid = $dbfile->f(fd_cat_id);
$filename = $dbfile->f(fd_cat_name);
$picname = $dbfile->f(fd_cat_url);
$thumrul = $dbfile->f(fd_cat_thumurl);
$display = $dbfile->f(fd_cat_display);
$thumrul = str_replace("../", "", $thumrul);
$vpic = "" . $thumrul;
$returnarray = $vpic . "@@" . $catid;
} else {
$thisclass = new oldimgfile();
//��ʼ����ʵ��
$returnarray = $thisclass->readoldfiles($scatid, $dateid);
}
if ($returnarray == "" and ($scatid == 5 or $scatid == 35)) {
$returnarray = $g_propic . "images/null.jpg@@";
}
return $returnarray;
}
<?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
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;
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;
}
}
$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()) {
$db1->next_record();
$storagecost = $db1->f(fd_sect_cost) + 0;
if ($storagecost >= $saleprice) {
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 {
$query = "update tb_saler set fd_saler_idcard ='{$idcard}',\n\t fd_saler_truename ='{$truename}' , fd_saler_phone ='{$phone}' , \n\t\t\tfd_saler_sharesalerid = '{$sharesalerid}' ,\n\t\t\tfd_saler_username = '******' ,\n\t\t\t fd_saler_salertype ='{$type}' , fd_saler_state = '1' , \n\t\t\t where fd_saler_id = '{$id}'";
$db->query($query);
if (!empty($password)) {
function getallpaymoney()
{
$db = new db_test();
$query = "select sum(fd_agpm_paymoney) as paymoney\n\t\tfrom tb_agentpaymoneylist \n\t\twhere fd_agpm_payrq='00'";
$db->query($query);
if ($db->nf()) {
while ($db->next_record()) {
$allpaymoney = $db->f(paymoney);
}
}
return $allpaymoney;
}
function checkdeptid($fid)
{
$db1 = new db_test();
$query = "select * from tb_dept where fd_dept_id != '{$fid}'";
$db1->query($query);
if ($db1->nf()) {
$db1->next_record();
$check_id = $db1->f(fd_dept_fid);
checkdeptid($check_id);
}
return $check_id;
}
header('Content-Type:text/html;charset=GB2312');
$value = strtolower($value);
$arr_chars = preg_split('//', $value, -1, PREG_SPLIT_NO_EMPTY);
for ($i = 0; $i < count($arr_chars); $i++) {
if (ereg("[0-9]", $arr_chars[$i])) {
$str_int .= $arr_chars[$i];
}
}
for ($i = 0; $i < count($arr_chars); $i++) {
if (ereg("[a-z]", $arr_chars[$i])) {
$strchars .= $arr_chars[$i];
}
}
$query = "select * from tb_supplier where fd_supp_no like '%" . $str_int . "%' and fd_supp_no like '%" . $strchars . "%' ";
$db->query($query);
$count = $db->nf();
if ($count == 0) {
$returnflag = 0;
$suppid = "";
//供应商id号
$suppname = "";
//供应商名称
$suppno = "";
//供应商编号
$suppcode = "";
//供应商代号
} elseif ($count == 1) {
$query = "select * from tb_supplier where fd_supp_no like '%" . $str_int . "%' and fd_supp_no like '%" . $strchars . "%'";
$db->query($query);
if ($db->nf()) {
$db->next_record();
<?php
$thismenucode = "2k102";
require "../include/common.inc.php";
$db = new db_test();
$gourl = "tb_manufacturer_b.php";
$gotourl = $gourl . $tempurl;
require "../include/alledit.1.php";
switch ($action) {
case "new":
//新增记录
$query = "select * from tb_manufacturer where fd_manu_name='{$name}' or fd_manu_allname='{$allname}'";
$db->query($query);
if ($db->nf() > 0) {
$error = "此制造商已经存在，请重新输入！";
} else {
$query = "insert into tb_manufacturer (\n\t \t\t\t fd_manu_no, fd_manu_name , fd_manu_allname ,fd_manu_address,fd_manu_linkman,\n\t\t\t\t\t fd_manu_manphone ,fd_manu_xingfen,fd_manu_workstatus\n\t \t\t\t )values( \n\t \t\t '{$no}','{$name}' ,'{$allname}', '{$address}','{$linkman}','{$manphone}','{$xingfen}',\n\t\t\t\t\t '{$workstatus}'\n\t \t\t )";
$db->query($query);
require "../include/alledit.2.php";
Header("Location: {$gotourl}");
}
break;
case "delete":
//删除记录
$query = "delete from tb_manufacturer where fd_manu_id='{$listid}'";
$db->query($query);
require "../include/alledit.2.php";
Header("Location: {$gotourl}");
break;
case "edit":
//编辑记录
function getauthormeal($type)
{
$db = new db_test();
$query = 'select fd_author_' . $type . ',count(fd_author_' . $type . ') as authornum from tb_author group by fd_author_' . $type . '';
$db->query($query);
if ($db->nf()) {
while ($db->next_record()) {
$id = $db->f('fd_author_' . $type . '');
$returnvalue[$id] = $db->f(authornum);
}
}
return $returnvalue;
}
function getusemoney($authorid)
{
$db = new db_test();
$data = date("Y-m-d", time());
$query = "select * from tb_slotcardmoneyreq\n\t\t\tleft join tb_slotcardmoneyset on fd_scdmset_id = fd_pmreq_paymsetid \n\t\t\twhere fd_pmreq_authorid='{$authorid}' and fd_pmreq_state='9' and fd_pmreq_reqdatetime like '{$data}%'";
$db->query($query);
if ($db->nf()) {
//�жϲ�ѯ���ļ�¼�Ƿ�Ϊ��
while ($db->next_record()) {
//��ȡ��¼���
$allreqmoney += $db->f(fd_pmreq_reqmoney);
}
return $allreqmoney;
} else {
return "0.00";
}
}
