<?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 {