<?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;
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>";
echo $showcheck;
