"") {
$action_cd = $_GET["cd"];
} else {
$action_cd = $_POST["cd"];
}
$sql_action_cd = "action_cd = '".$action_cd."'";
//顧客種別
if($_GET["type"] <> "") {
$customer_type_id = $_GET["type"];
} else {
$customer_type_id = $_POST["type"];
}
$sql_customer_type_id = "customer_type_id ='".$customer_type_id."'";
//経過日数
if($_GET["day"] <> "") {
$customer_action_day = $_GET["day"];
} else {
$customer_action_day = $_POST["day"];
}
$sql_customer_action_day = "customer_action_day ='".$customer_action_day."'";
/*$okcount = 0;$errcount = 0;
if($_GET["allfix"] == "y" ) {
//全確定
$strsql = "UPDATE customer SET customer_action_flg = 9,updater = '".$userdata["tid"]."' WHERE customer_action_flg = 1 AND ".$sql_customer_type_id." AND ".$sql_customer_action_day;
$result=@mysql_query($strsql,$my_con);
mysql_sql_log($strsql,mysql_affected_rows(),$_SERVER['SCRIPT_NAME'].":".__LINE__);
$okcount += mysql_affected_rows();
} elseif($_POST["update"] == "1" ) {
//一部確定
For ($y=0; $y < (int)$_POST[maxrow]; $y++) {
if($_POST["chk"][$y] == 1) {
//チェック済み
$strsql = "UPDATE customer SET customer_action_flg = 9,updater = '".$userdata["tid"]."' WHERE customerid = '".$_POST["id"][$y]."' and customer_action_flg = 1";
$result=@mysql_query($strsql,$my_con);
mysql_sql_log($strsql,mysql_affected_rows(),$_SERVER['SCRIPT_NAME'].":".__LINE__);
$okcount += mysql_affected_rows();
} else {
//未チェック
}
}
} else {
}
*/
?>
ceil($maxrow / $pageset)) {
$page = 1;
} else {
}
}
//データ取得数
$limit = " LIMIT ".($pageset*($page - 1)).",$pageset";
//未確定が0の時はALLボタンをOFFにする
$strsql2="SELECT count(customerid) as cnt FROM customer WHERE customer_action_flg = 1 AND ".$strsqlwhere;
$result2=@mysql_query($strsql2,$my_con);
$data2 = mysql_fetch_array($result2);
//１ページ分
$strsql .= $limit;
$result=@mysql_query($strsql,$my_con);
$order=1;
//更新情報
if (($okcount + $errcount)>0) {
if ($okcount > 0 ){
PrintMsg("","$okcount 件 データを更新しました。",700);
}
if ($errcount > 0 ){
PrintMsg("登録エラーが $errcount 件有りました。","",700);
}
PrintMsg($errmsg,$worningmsg,700);
}
?>
顧客種別：
アクション：".$actiondata[0][0]."経過日数：".$customer_action_day."日";
?>