function clientCalc($cid, $month, &$yen, &$date)
{
//全ての金額を出すためUpdate、Deleteはしない
//過去のデータを削除
//DELETE
require 'SQLConnect.php';
//全ての金額を出すためUpdate、Deleteはしない
//$sql = "DELETE From `rank_calc_month` WHERE (`rcm_month` ='" . $month . "' and rcm_rclid = '" . $cid . "');";
//print $sql . "<BR><BR>";
//$c_hit = mysql_db_query($dbName,$sql) or die('UPDATE error: '.mysql_errno().', '.mysql_error());
mysql_close($dbHandle);
require 'SQLConnect_jas.php';
//対象料金テーブルを取得
if ($cid == 0) {
$sql = "SELECT * FROM `rank_keyword`;";
} else {
$sql = "SELECT * FROM `rank_keyword` Where(rkw_rclid = '" . $cid . "');";
}
//print $sql;
//print $sql;
//SQL文を実行する
$rs = mysql_db_query($dbName, $sql);
$rsCount = mysql_num_rows($rs);
//レコード数
$yenAll = 0;
for ($i = 0; $i <= $rsCount - 1; $i++) {
$row = @mysql_fetch_array($rs);
//print $row[rkw_client] . "<br>";
//print "開始日：" . $row[rkw_contract_startdate] . "<br>";
//print "終了日：" . $row[rkw_contract_enddate] . "<br><br>";
$yenAll += keywordCalc($month, $row[rkw_id], $row[rkw_contract_startdate], $row[rkw_contract_enddate]);
}
require 'SQLClose.php';
//print "合計：" . $yenAll . "<br>";
$_POST[rcm_month] = $month;
$_POST[rcm_rclid] = $cid;
$_POST[rcm_makedatetime] = DateNow(0);
$_POST[rcm_yen] = $yenAll;
//全ての金額を出すためUpdate、Deleteはしない
//DataInsert("rank_calc_month");
$yen = $yenAll;
$date = $_POST[rcm_makedatetime];
}
function insertClientData($arrClientData)
{
foreach ($arrClientData as $field_rank_client => $value_rank_client) {
unset($_POST[$field_rank_client]);
$_POST[$field_rank_client] = $value_rank_client;
}
//End foreach
$_POST['rcl_status'] = 1;
$_POST['rcl_resisted'] = 1;
unset($_POST[rcl_id]);
print DataJasInsertString('rank_client') . "<br /><br />";
$intClientId = DataJasInsert('rank_client');
//seo-rankingのユーザー名とパスワードの登録(update)
//ユーザー名
$prefix = "";
if ($_POST[rcl_agencyflag] == "0") {
$prefix = "A";
}
if ($_POST[rcl_agencyflag] == "1") {
$prefix = "E";
}
if ($_POST[rcl_agencyflag] == "2") {
$prefix = "A";
}
$username = $prefix . "-" . substr(DateNow(0), 2, 2) . substr(0, 5, 2) . "-" . substr("00000" . $intClientId, -5);
//パスワード
$pass = randPass(6);
require 'cin/SQLConnect_jas.php';
# require('cin/SQLConnect.php');
$sql = "UPDATE `rank_client` SET `rcl_username` = '" . $username . "', `rcl_password` = '" . $pass . "' WHERE (`rcl_id` = '" . $intClientId . "');";
#15-02-13変更
print $sql . "<BR><BR>";
$c_hit = mysql_db_query($dbName, $sql) or die('UPDATE error: ' . mysql_errno() . ', ' . mysql_error());
mysql_close($GLOBALS[dbHandle]);
require 'cin/SQLClose.php';
return $intClientId;
}
function DataUpdate($tableName, $flagNoEscape = false)
{
$Names = array();
foreach ($_POST as $key => $value) {
array_push($Names, $key);
}
//接続文読み込み
require 'SQLConnect.php';
$sql = "UPDATE `" . $tableName . "` SET ";
$rs = mysql_list_fields("_seotool", $tableName, $GLOBALS[dbHandle]);
$idName = mysql_fieldname($rs, 0);
for ($i = 1; $i < mysql_num_fields($rs); $i++) {
//print mysql_fieldname($rs, $i);
$fldname = mysql_fieldname($rs, $i);
if (in_array($fldname, $Names)) {
//予めエスケープ処理されたものを扱うか否かで処理分け（DEFAULTは"$flagNoEscape = false"）
if ($flagNoEscape) {
$sql .= " `" . $fldname . "` = '" . $_POST[$fldname] . "', ";
} else {
$sql .= " `" . $fldname . "` = '" . addslashes($_POST[$fldname]) . "', ";
}
}
}
//切断文読み込み
require 'SQLClose.php';
$sql = substr($sql, 0, -2);
$sql .= " WHERE " . $idName . " = '" . $_POST[$idName] . "'";
require 'SQLConnect.php';
//sql文を実行する
//print $sql . "<BR><BR>";
$c_hit = mysql_db_query("_seotool", $sql) or die('error: ' . mysql_errno() . ', ' . mysql_error());
$sql_bk = $sql;
mysql_close($GLOBALS[dbHandle]);
require 'SQLConnect.php';
//データバックアップ
$sql = "insert into `jas_sql_backup` (`jsb_id`,`jsb_datetime`,`jsb_name`,`jsb_kind`,`jsb_sql`)" . " VALUES ('','" . DateNow(0) . "','" . $_SESSION[jm_name] . "','Update','" . mysql_real_escape_string($sql_bk) . "')";
//print $sql . "<BR><BR>";
// $c_hit = mysql_db_query("_seotool",$sql)
// or die('error: '.mysql_errno().', '.mysql_error());
//まあ要らないか
//mysql_close($GLOBALS[dbHandle]);
}
$row = mysql_fetch_array($rs);
//既にseo-rankingのユーザーID、パスがある場合登録しない
# if(!(($row[rcl_username]) && ($row[rcl_password]))) { #15-02-13変更
//クライアントIDの発行
//====================================================================
$prefix = "";
if ($_POST[rcl_agencyflag] == "0") {
$prefix = "A";
}
if ($_POST[rcl_agencyflag] == "1") {
$prefix = "E";
}
if ($_POST[rcl_agencyflag] == "2") {
$prefix = "A";
}
$username = $prefix . "-" . substr(DateNow(0), 2, 2) . substr(0, 5, 2) . "-" . substr("00000" . $row[rcl_id], -5);
$pass = randPass(6);
require 'cin/SQLConnect_jas.php';
#$sql = "UPDATE `rank_client` SET `rcl_username` = '" . $username . "', `rcl_password` = '" . $pass . "' WHERE (`rcl_name` = '" . $_POST[rcl_name] ."');";
$sql = "UPDATE `rank_client` SET `rcl_username` = '" . $username . "', `rcl_password` = '" . $pass . "' WHERE (`rcl_id` = '" . $_POST[rcl_id] . "');";
#15-02-13変更
print $sql . "<BR><BR>";
$c_hit = mysql_db_query($dbName, $sql) or die('UPDATE error: ' . mysql_errno() . ', ' . mysql_error());
mysql_close($GLOBALS[dbHandle]);
//====================================================================
# }//End if
} else {
#$_POST[record]があるときUPDATEする
require 'cin/SQLConnect_jas.php';
$sql = " SELECT rcl_id FROM `rank_client` ";
$sql .= " WHERE TRUE ";
