<?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
require "../include/common.inc.php";
header('Content-Type:text/html;charset=GB2312');
$dbshop = new db_shop();
$arr_shopid = explode(",", $shopid);
foreach ($arr_shopid as $value) {
$query = "update tb_shop set fd_shop_phsid ='' where fd_shop_id = '{$value}' ";
$dbshop->query($query);
//修改单据资料
}
<?php
require "../include/common.inc.php";
header('Content-Type:text/html;charset=GB2312');
$db = new db_shop();
$provincescode = explode(",", $provincescode);
$arr_ihotshop = explode(",", $ihotshop);
foreach ($provincescode as $value) {
if ($value) {
$arr_provincescode[] = $value;
}
}
// left join tb_shopkcquantity on fd_skqy_shopid=fd_shop_id and fd_skqy_procatalogid='$procaid'
$provincescode = implode(",", $arr_provincescode);
$query = "select fd_shop_id,fd_shop_name from tb_shop \n\t\t\n\t\twhere fd_shop_isstop='0' and fd_shop_state='5' and fd_shop_iswebhidden = 0 and fd_shop_province in({$provincescode}) group by fd_shop_id order by fd_shop_province";
$db->query($query);
if ($db->nf()) {
while ($db->next_record()) {
$checked = "";
$shopid = $db->f(fd_shop_id);
$shopname = $db->f(fd_shop_name);
foreach ($arr_ihotshop as $value) {
if ($value == $shopid) {
$checked = "checked='true'";
}
}
$showcheck .= '<div style="width:200px;float:left;"><input type="checkbox" ' . $checked . ' title="' . $shopid . '" name="arr_content[]" onclick="addPreItem()"
value="' . $shopname . '">' . $shopname . '</div>';
}
}
$showcheck .= "<div style='clear:both;'></div>";
<?php
header('Content-Type: application/x-www-form-urlencoded');
header('Content-Type: text/html;charset=gbk');
require "../include/common.inc.php";
require "../include/json.php";
$dbshop = new db_shop();
$db = new db_test();
$shopnavname = u2g(unescape($shopnavname));
switch ($act) {
case "trad":
$query = "select * from tb_shop where fd_shop_navname='{$shopnavname}' and fd_shop_id<> '{$shopid}'";
$dbshop->query($query);
if ($dbshop->nf()) {
echo "仓库名已存在！" . "@@" . "n";
} else {
$query1 = "select * from tb_sendcenter where fd_sdcr_name='{$shopnavname}'";
$db->query($query1);
if ($db->nf()) {
echo "仓库名已存在！" . "@@" . "n";
} else {
echo "正常" . "@@" . "y";
}
}
break;
case "sp":
$query = "select * from tb_shop where fd_shop_navname='{$shopnavname}' and fd_shop_id<> '{$shopid}'";
$dbshop->query($query);
if ($dbshop->nf()) {
echo "仓库名已存在！" . "@@" . "n";
} else {
