127) $over++;
return chop(substr($str,0,$size - $over%2));
}
// 2019-05-29 huibong
// LG U+ sms MySQL DB modifiy
function NewSMSserver($msg,$passwd,$dbConnPgSql, $strSqlpg, $group_seq, $sid)
{
$tmpSqlmy = "";
$tmpSqlpg = "";
$user_count =0;
$dbConnPgSql->query($strSqlpg);
if($dbConnPgSql->nf() == 0)
{
echo "fail to pgsql querty : $strSqlpg "; echo "
";
makelog(false, "fail to pgsql querty : $strSqlpg ");
return false;
}
// LG U+ CDN modify
$dbConnMySql = new dbconnect('smsdb.x-cdn.com', 'xcdnuser', $passwd, 'SMS', __FILE__, __LINE__);
if(!$dbConnMySql->bConnect){
echo "SMS Server 1 (smsdb.x-cdn.com) Connect Failed!"; echo "
";
makelog(false, "SMS Server 1 (smsdb.x-cdn.com) Connect Failed!");
return false;
}
echo "SMS Server 1 (smsdb.x-cdn.com) connecting!"; echo "
";
while($dbConnPgSql->next_record())
{
$cellphone = $dbConnPgSql->f("member_cellphone");
$tmpSqlmy = "INSERT INTO SC_TRAN( TR_SENDDATE, TR_SENDSTAT, TR_PHONE, TR_CALLBACK, TR_MSG, TR_MSGTYPE ) ";
$tmpSqlmy .= "VALUES ( now(), '0', '$cellphone', '0220862690', '$msg', '0'); ";
//echo "mysql query : " . $tmpSqlmy; echo"
";
$res=$dbConnMySql->query($tmpSqlmy, __FILE__, __LINE__);
if(!$res->result)
{
echo "fail to send SMS "; echo "
";
makelog(false, $tmpSqlmy);
continue;
}
$user_count ++;
$tmpSqlpg .= "INSERT INTO t_sms_log (group_seq, sms_id, sms_cellphone, sms_message, reg_datetime, update_datetime) ";
$tmpSqlpg .= "VALUES (".$group_seq.", '".$sid."', '".$cellphone."', '".$msg."', now(), now()); ";
}
$dbConnMySql->close();
if($user_count == $dbConnPgSql->nf())
{
echo "Server 1 (smsdb.x-cdn.com) : success to All send SMS " ; echo "
";
$dbConnPgSql->query($tmpSqlpg);
//makelog(true, $tmpSqlmy);
return true;
}
else
{
makelog(false, $tmpSqlmy);
return false;
}
}
function SMSserver($msg,$dbConnPgSql,$strSqlpg,$group_seq, $sid )
{
$tmpSqlmy = "";
$tmpSqlpg = "";
$user_count =0;
$dbConnPgSql->query($strSqlpg);
if($dbConnPgSql->nf() == 0)
{
echo "fail to pgsql querty : $strSqlpg "; echo "
";
return false;
}
$dbConnMySql = new dbconnect('211.39.134.240', 'sms', '', 'sms', __FILE__, __LINE__);
if(!$dbConnMySql->bConnect){
echo "SMS Server 2 (211.39.134.240) Connect Failed "; echo "
";
makelog(false, "SMS Server 2 (211.39.134.240) Connect Failed!");
return false;
}
echo " SMS SERVER 2 (211.39.134.240) Connectng..."; echo "
";
while($dbConnPgSql->next_record())
{
$cellphone = $dbConnPgSql->f("member_cellphone");
$cli_ip = $_SERVER['REMOTE_ADDR'];
$tmpSqlmy = "INSERT INTO sms_msg (phone, callback, reqdate, msg,etc1 ) ";
$tmpSqlmy .= "VALUES ( '$cellphone', '$cellphone', sysdate(), '$msg', '$cli_ip')";
$res=$dbConnMySql->query($tmpSqlmy,__FILE__, __LINE__);
if(!$res->result) {
makelog(false, $tmpSqlmy);
echo "fail to send SMS "; echo "
";
continue;
}
$user_count ++;
$tmpSqlpg .= "INSERT INTO t_sms_log (group_seq, sms_id, sms_cellphone, sms_message, reg_datetime, update_datetime) ";
$tmpSqlpg .= "VALUES (".$group_seq.", 'SH_".$sid."', '".$cellphone."', '".$msg."', now(), now()); ";
}
// echo "Server count; "; echo $user_count ; echo "
";
// echo "Server nf ; "; echo $dbConnPgSql->nf(); echo "
";
$dbConnMySql->close();
if($user_count == $dbConnPgSql->nf()){
echo " SERVER 2 (211.39.134.240): success to All send SMS " ; echo "
";
$dbConnPgSql->query($tmpSqlpg);
return true;
}
makelog(false, $tmpSqlmy);
return false;
}
function makelog($result,$log_str)
{
$filepath = "/user/service/logs/sms_result"; // 로그파일을 저장한 디렉토리
$filename = "log"; // 로그파일의 Prefix
$yyyymm = date("Ym", time());
$yyyymmdd = date("Ymd", time());
$log_dir_yyyymm = $filepath . "/";
if(!is_dir($log_dir_yyyymm)) {
mkdir($log_dir_yyyymm, 0707);
chmod($log_dir_yyyymm,0707);
}
$file_name_log = $log_dir_yyyymm . $filename . "-" . $yyyymmdd;
$filep = fopen("$file_name_log","a+");
if(!$filep)
{
echo " Error : Don't open a log file[$file_name_log]."; echo "
";
fclose($filep);
return;
}
$log_msg = "";
$log_msg .= date("Y-m-d H:i:s", time());
if($result == false) $log_msg .= " Fail : ";
else $log_msg .= " Success : ";
$log_msg .= $log_str;
fputs($filep, "$log_msg\n\n");
fclose($filep);
}
$id = $_GET['id'];
$msg = $_GET['msg'];
$passwd ="solbox123";
if ($id == "" ) {
$sid = "ADMIN";
} else {
$sid = $id;
}
//makelog(false, "id[$id], msg[$msg]");
if($sid != "" && $msg != "")
{
$dbConnPgSql = new DB_Sql;
$strSqlpg = "SELECT group_seq ";
$strSqlpg .= "FROM t_group ";
$strSqlpg .= "WHERE group_id = '".$sid."' AND deleted_yn = 'N'";
$sizelen=strlen($msg);
echo "Message : $msg Size :$sizelen \n"; echo "
";
$dbConnPgSql->query($strSqlpg);
// FIXME:errchk
if($dbConnPgSql->nf() == 1)
{
$dbConnPgSql->next_record();
$group_seq = $dbConnPgSql->f("group_seq");
if($group_seq != "")
{
$strSqlpg = "SELECT member_cellphone ";
$strSqlpg .= "FROM t_group_member ";
$strSqlpg .= "WHERE group_seq = ".$group_seq;
//$dbConnPgSql->query($strSqlpg);
if($sizelen > 80){
$strtmp = $msg;
$msg=cutstr($strtmp,80);
$sizelen=strlen($msg);
echo "CutSTR Message : $msg Size :$sizelen \n"; echo "
";
}
$SMS_send_Success = false;
for($i = 0; $i< 2; $i++)
{
$SMS_send_Success = NewSMSserver( $msg, $passwd, $dbConnPgSql, $strSqlpg, $group_seq, $sid );
if( $SMS_send_Success )
{
// send sms success !!
break;
}
}
if(!$SMS_send_Success )
{
echo "Unexpected error was occured "; echo "
";
makelog(false,"Unexpected error was occured1 " );
}
}
else
{
echo "PGSQL `group_seq` failed"; echo "
";
makelog(false,"PGSQL `group_seq` failed" );
}
$dbConnPgSql->close();
}
else
{
echo "sid or msg NULL!!!"; echo "
";
makelog(false,"PGSQL `group_seq` failed" );
}
}
else
{
echo "Unexpected error was occured. sid : \"$sid\" msg :\"$msg\"\n"; echo "
";
makelog(false,"Unexpected error was occured2. sid : \"$sid\" msg :\"$msg");
}
?>