/**
* Constructor for vacancy
*
* @param array $vacancy_row
*/
public function __construct(array $vacancy_row)
{
$this->vacancy = array_intersect_key($vacancy_row, array_flip(self::$DB_fields));
if (!empty($this->vacancy['company_id'])) {
$this->vacancy['company'] = new Company($vacancy_row);
} else {
$this->vacancy['company'] = null;
}
if (!empty(self::$job->tpl)) {
$this->vacancy['vacancy_url'] = self::$job->tpl->GetUrl(array('action' => 'vacancy', 'id' => $this->vacancy['id']));
}
$this->vacancy['rss_add_date'] = date("r", $this->vacancy['add_date']);
$this->vacancy['description'] = nl2br($this->vacancy['description']);
if (!empty($this->vacancy['add_date'])) {
$this->vacancy['add_date'] = ConvertDate($this->vacancy['add_date'], self::$job);
}
if (!empty($this->vacancy['date_exp'])) {
$this->vacancy['date_exp'] = $this->vacancy['exp_date'] = ConvertDate($this->vacancy['date_exp'], self::$job);
} else {
$this->vacancy['date_exp'] = self::$job->lang['no_limit'];
}
if ($this->vacancy['salary_min'] && $this->vacancy['salary_max'] && $this->vacancy['salary_min'] != $this->vacancy['salary_max']) {
$this->vacancy['salary'] = $this->vacancy['salary_min'] . " - " . $this->vacancy['salary_max'] . " " . self::$job->lang[$this->vacancy['currency']];
} elseif ($this->vacancy['salary_min'] == $this->vacancy['salary_max'] && $this->vacancy['salary_min']) {
$this->vacancy['salary'] = $this->vacancy['salary_min'] . " " . self::$job->lang[$this->vacancy['currency']];
} elseif ($this->vacancy['salary_min']) {
$this->vacancy['salary'] = self::$job->lang['from'] . $this->vacancy['salary_min'] . " " . self::$job->lang[$this->vacancy['currency']];
} elseif ($this->vacancy['salary_max']) {
$this->vacancy['salary'] = self::$job->lang['to'] . $this->vacancy['salary_max'] . " " . self::$job->lang[$this->vacancy['currency']];
} else {
$this->vacancy['salary'] = self::$job->lang['contract_salary'];
}
if ($this->vacancy['age_min'] && $this->vacancy['age_max'] && $this->vacancy['age_min'] != $this->vacancy['age_max']) {
$this->vacancy['age'] = $this->vacancy['age_min'] . " - " . $this->vacancy['age_max'];
} elseif ($this->vacancy['age_min'] == $this->vacancy['age_max']) {
$this->vacancy['age'] = $this->vacancy['age_min'];
} elseif ($this->vacancy['age_min']) {
$this->vacancy['age'] = self::$job->lang['from'] . $this->vacancy['age_min'];
} elseif ($this->vacancy['age_max']) {
$this->vacancy['age'] = self::$job->lang['to'] . $this->vacancy['age_max'];
} else {
$this->vacancy['age'] = self::$job->lang['no_show'];
}
foreach (self::$fields as $field_name => $values_array) {
if ($values_array[$this->vacancy[$field_name]]) {
$this->vacancy[$field_name] = $values_array[$this->vacancy[$field_name]];
}
}
}
/**
* Constructor for resume class
*
* @param array $resume_row
*/
public function __construct(array $resume_row)
{
$this->resume = array_intersect_key($resume_row, array_flip(self::$DB_fields));
if (!empty($this->resume['add_date'])) {
$this->resume['add_date'] = ConvertDate($this->resume['add_date'], self::$job);
}
if (!empty(self::$job->tpl)) {
$this->resume['resume_url'] = self::$job->tpl->GetUrl(array('action' => 'resume', 'id' => $this->resume['id']));
}
$this->resume['rss_add_date'] = date("r", $this->resume['add_date']);
$this->resume['description'] = nl2br($this->resume['description']);
if (!empty($this->resume['date_exp'])) {
$this->resume['date_exp'] = $this->resume['exp_date'] = ConvertDate($this->resume['date_exp'], self::$job);
} else {
$this->resume['date_exp'] = self::$job->lang['no_limit'];
}
if ($this->resume['salary_min'] && $this->resume['salary_max'] && $this->resume['salary_min'] != $this->resume['salary_max']) {
$this->resume['salary'] = $this->resume['salary_min'] . " - " . $this->resume['salary_max'] . " " . self::$job->lang[$this->resume['currency']];
} elseif ($this->resume['salary_min'] && $this->resume['salary_min'] == $this->resume['salary_max']) {
$this->resume['salary'] = $this->resume['salary_min'] . " " . self::$job->lang[$this->resume['currency']];
} elseif ($this->resume['salary_min']) {
$this->resume['salary'] = self::$job->lang['from'] . $this->resume['salary_min'] . " " . self::$job->lang[$this->resume['currency']];
} elseif ($this->resume['salary_max']) {
$this->resume['salary'] = self::$job->lang['to'] . $this->resume['salary_max'] . " " . self::$job->lang[$this->resume['currency']];
} else {
$this->resume['salary'] = 0;
}
foreach (self::$fields as $field_name => $values_array) {
if ($values_array[$this->resume[$field_name]]) {
$this->resume[$field_name] = $values_array[$this->resume[$field_name]];
}
}
if ($this->resume['photo']) {
$this->resume['photo_url'] = PHOTO_URL_PATCH . $this->resume['photo'];
} else {
$this->resume['photo_url'] = PHOTO_URL_PATCH . 'no_photo.jpg';
}
}
/**
* Costrusctor compan class
*
* Create new object of company with company information
*
* @param array $company Array from DataBase
*/
public function __construct(array $company = array())
{
$this->company = array_intersect_key($company, array_flip(self::$DB_fields));
if ($this->company['add_date']) {
$this->company['add_date'] = ConvertDate($this->company['add_date'], self::$job);
}
if (!empty($this->company['OPF'])) {
$this->company['OPF'] = self::$OPF_array[$this->company['OPF']];
}
if (!empty($this->company['company_type'])) {
if ($this->company['company_type'] == "PA") {
$this->company['company_type'] = self::$job->lang['PA'];
} else {
$this->company['company_type'] = self::$job->lang['EM'];
}
}
if ($this->company['logo']) {
$this->company['logo_url'] = LOGO_URL_PATCH . $this->company['logo'];
} else {
$this->company['logo_url'] = LOGO_URL_PATCH . "no_logo.jpg";
}
$this->company['site'] = "<a href=\"" . $this->company['site'] . "\" >" . $this->company['site'] . "</a>";
$this->company['description'] = nl2br($this->company['description']);
}
echo $dateStartCap; ?> </div> <div class="floatL form_input"><input type="text" name="txtStartDate" id="txtStartDate" value="<?php echo ConvertDate($row['EVENT_START_DATE']); ?> " class="DatePicker" /></div> <div class="clear"></div> </div> <div <?php echo $hideEndDate; ?> > <div class="floatL form_name">วันที่สิ้นสุด</div> <div class="floatL form_input"><input type="text" name="txtEndDate" id = "txtEndDate" value="<?php echo ConvertDate($row['EVENT_END_DATE']); ?> " class="DatePicker" /></div> <div class="clear"></div> </div> <div <?php echo $hideEndDate; ?> > <div class="floatL form_name">เวลาเริ่ม</div> <div class="floatL form_input"> <select name="cmbHourStart"> <?php
echo $MID; ?> &CID=<?php echo $row_Category['CONTENT_CAT_ID']; ?> &CONID=<?php echo $row_Category['CONTENT_ID']; ?> &link=perm"> <p class="text-title"><?php echo $row_Category['CONTENT_DESC']; ?> </p> </a> <p class="text-date"><?php echo ConvertDate($row_Category['LAST_DATE']); ?> </p> <p class="text-des"><?php echo $row_Category['BRIEF_LOC']; ?> </p> <div class="box-btn cf"> <a href="ve-detail.php?MID=<?php echo $MID; ?> &CID=<?php echo $row_Category['CONTENT_CAT_ID']; ?> &CONID=<?php echo $row_Category['CONTENT_ID'];
<p class="text-detail">
<span><?=$typeCap?>: .<?=$ext ?></span>
<span><?=$sizeCap?>: <?=$size ?></span>
</p>
</div>
<div class="box-btn cf">
<a href="<?=$link ?>" target="_blank" class="btn red"><?=$downloadCap ?></a>
</div>
</div>
<?php } } ?>
</div>
</div>
<?php } ?>
<div class="box-footer-content cf">
<div class="box-date-modified">
<?=$lastEditCap ?> : <?= ConvertDate($lastDate) ?>
</div>
<div class="box-plugin-social">
<div class="fb-share-button" data-href="<?=$path ?>" data-layout="button_count"></div>
<a href="https://twitter.com/share" class="twitter-share-button" data-url="<?=$fullpath ?>">Tweet</a>
<div class="g-plus" data-action="share" data-annotation="bubble" data-href="<?=$fullpath ?>"></div>
<span>
<script type="text/javascript" src="//media.line.me/js/line-button.js?v=20140411" ></script>
<script type="text/javascript">
new media_line_me.LineButton({"pc":false,"lang":"en","type":"a","text":"<?=$path ?>
","withUrl":true});
</script>
</span>
</div>
</div>
</div>
LEFT JOIN sys_app_user u ON u.USER_ID = prod.CUSTOMER_ID
LEFT JOIN trn_product p ON p.PRODUCT_ID = pic.PRODUCT_ID
LEFT JOIN trn_order_status s ON s.STATUS_ID = prod.FLAG
WHERE prod.CUSTOMER_ID = '".$_SESSION['UID']."' AND (prod.TYPE = 'ticket' OR prod.TYPE = 'booking') ";
$sql .= "order by prod.ORDER_ID desc";
$query = mysql_query($sql,$conn);
while($row = mysql_fetch_array($query)) {
?>
<div class="table-row list cf">
<div class="column order">158686047</div>
<div class="column date"><? echo ConvertDate($row['CREATE_DATE']); ?></div>
<div class="column name"><? echo $row['PRODUCT_DESC_LOC']; ?></div>
<div class="column num"><? echo $row['QUANTITY']; ?></div>
<div class="column price"><? echo $row['PRICE']; ?></div>
<div class="column total"><? echo $row['SUMPRICE']; ?></div>
<div class="column status"><? echo $row['STATUS_NAME_LOC']; ?></div>
</div>
<? }
/*
?>
<div class="box-pagination-main cf">
<ul class="pagination">
<li class="deactive"><a href="" class="btn-arrow-left"></a></li>
<li class="active"><a href="">1</a></li>
echo $row['MUSEUM_DESC'];
echo '</div>';
echo '<div class="box-date-tumb type2">';
echo '<p class="date">' . $date[0] . '-' . $dateEnd[0] . '</p>';
echo '<p class="month">' . $date[1] . '-' . $dateEnd[1] . '</p>';
echo '</div>';
echo '</div>';
echo '</a>';
echo '<div class="box-text">';
echo '<a href="event-detail.php?MID=' . $MID . '&CID=' . $categoryID . '&SID=' . $row['SUB_CAT_ID'] . '&CONID=' . $row['CONTENT_ID'] . '&date=event_week">';
echo '<p class="text-title TcolorRed">';
echo $title;
echo '</p>';
echo '</a>';
echo '<p class="text-date TcolorGray">';
echo ConvertDate($row['CREATE_DATE']);
echo '</p>';
echo '<p class="text-des TcolorBlack">';
echo $detail;
echo '</p>';
echo '<div class="box-btn cf">';
echo '<a href="event-detail.php?MID=' . $MID . '&CID=' . $categoryID . '&SID=' . $row['SUB_CAT_ID'] . '&CONID=' . $row['CONTENT_ID'] . '&date=event_week" class="btn red">อ่านเพิ่มเติม</a>';
echo '<div class="box-btn-social cf">';
echo '<a href="' . $fb_link . '" onclick="shareFB(\'' . $title . '\',$(this).attr(\'href\')); return false;" class="btn-socila fb"></a>';
echo '<a href="' . $fullpath . '" onclick="shareTW(\'' . $row_row1['CONTENT_ID'] . '\',\'' . $title . '\',$(this).attr(\'href\')); return false;" class="btn-socila tw"></a>';
echo '</div>';
echo '</div>';
echo '</div>';
echo '</div>';
$index++;
}
$oldemail = $_POST['oldemail'];
$phone = $modx->db->escape($_POST['phone']);
$mobilephone = $modx->db->escape($_POST['mobilephone']);
$fax = $modx->db->escape($_POST['fax']);
$dob = !empty($_POST['dob']) ? ConvertDate($_POST['dob']) : 0;
$country = $_POST['country'];
$state = $modx->db->escape($_POST['state']);
$zip = $modx->db->escape($_POST['zip']);
$gender = !empty($_POST['gender']) ? $_POST['gender'] : 0;
$photo = $modx->db->escape($_POST['photo']);
$comment = $modx->db->escape($_POST['comment']);
$roleid = !empty($_POST['role']) ? $_POST['role'] : 0;
$failedlogincount = !empty($_POST['failedlogincount']) ? $_POST['failedlogincount'] : 0;
$blocked = !empty($_POST['blocked']) ? $_POST['blocked'] : 0;
$blockeduntil = !empty($_POST['blockeduntil']) ? ConvertDate($_POST['blockeduntil']) : 0;
$blockedafter = !empty($_POST['blockedafter']) ? ConvertDate($_POST['blockedafter']) : 0;
$user_groups = $_POST['user_groups'];
// verify password
if ($passwordgenmethod == "spec" && $_POST['specifiedpassword'] != $_POST['confirmpassword']) {
webAlert("Password typed is mismatched");
exit;
}
// verify email
if ($email == '' || !preg_match("/^[A-Z0-9._%+-]+@[A-Z0-9.-]+\\.[A-Z]{2,6}\$/i", $email)) {
webAlert("E-mail address doesn't seem to be valid!");
exit;
}
switch ($_POST['mode']) {
case '87':
// new user
// check if this user name already exist
?>
">
<span class="box-pic Search_image_thumb"></span>
</a>
<div class="box-text">
<a href="<?php
echo $path;
?>
">
<p class="text-title TcolorRed"><?php
echo $title;
?>
</p>
</a>
<p class="text-date TcolorGray"><?php
echo ConvertDate($row_row1['CONTENT_DATE']);
?>
</p>
<p class="text-des TcolorBlack"><?php
echo $detail;
?>
</p>
<div class="box-btn cf">
<a href="<?php
echo $path;
?>
" class="btn red"><?php
echo $txt_more;
?>
</a>
<div class="box-btn-social cf">
}
$usernamedata = mysql_fetch_assoc($rs);
$_SESSION['itemname'] = $usernamedata['username'];
} else {
$userdata = array();
$usersettings = array();
$usernamedata = array();
$_SESSION['itemname'] = "New web user";
}
// restore saved form
$formRestored = false;
if ($modx->manager->hasFormValues()) {
$modx->manager->loadFormValues();
// restore post values
$userdata = array_merge($userdata, $_POST);
$userdata['dob'] = ConvertDate($userdata['dob']);
$usernamedata['username'] = $userdata['newusername'];
$usernamedata['oldusername'] = $_POST['oldusername'];
$usersettings = array_merge($usersettings, $userdata);
$usersettings['allowed_days'] = is_array($_POST['allowed_days']) ? implode(",", $_POST['allowed_days']) : "";
extract($usersettings, EXTR_OVERWRITE);
}
// converts date format dd-mm-yyyy to php date
function ConvertDate($date)
{
global $modx;
if ($date == "") {
return "0";
} else {
}
return $modx->toTimeStamp($date);
<div class="label_right"> <div class="input-group date form-w250"> <input type="text" class="form-control" name="CompleteWorkDate" id="CompleteWorkDate" value="<?php echo ConvertDate($dataDoc['CompleteWorkDate'], 'd/m/Y'); ?> "> <span class="input-group-addon"><i class="glyphicon glyphicon-th"></i></span> </div> </div> </div> <div class="info_left"> <div class="label_left">วดป. ที่ยกเลิกงาน :</div> <div class="label_right"> <div class="input-group date form-w250"> <input type="text" class="form-control" name="CancelWorkDate" id="CancelWorkDate" value="<?php echo ConvertDate($dataDoc['CancelWorkDate'], 'd/m/Y'); ?> "> <span class="input-group-addon"><i class="glyphicon glyphicon-th"></i></span> </div> </div> </div> </div> <div class="clean"></div> </div> </div> <!--*************************************Sheet 3 End ****************--> <!--*************************************Sheet 4 ****************--> <div role="tabpanel" id="machine" class="tab-pane fade" aria-labelledby="machine-tab"> <div class="incontent">
/**
* Initiates pre-processing according to directives given.
* Checks presence of all necessary fields.
* Empties Stage table and inserts new lines - with formatted fields
*
* pre-processing can be:
* <UL>
* <LI> utf16_to_utf8
* <LI> utf8_decode
* <LI> CSVSetSemicolonDelimiter
* <LI> CSVCutThousandDelimiter
* <LI> CSVCutDecimals
* </UL>
* Last version of pre-processed file can be found in _ADJUSTED.. for debugging
*
* @param string $FPath File with complete path
* @param array $fieldMap Array with directives and field mapping for the given file type
* @return boolean true if finished successully - else false
*/
function FileRead($FPath,$fieldMap)
{
$specialElementName=array("TEMP_STAGE_TABLE","NOTAUTOID","FILTERFIELD_NAME","FILTERFIELD_VALUE"
,"UTF16DECODE","SETSEMICOLONDELIMITER","CUTTHOUSANDDELIMITER","1000SCALE"
,"APPEND_DATA_TO_TABLE","CHECKSUMFIELD","AUTOFILL");
$extra=0;
foreach($specialElementName as $v)
if (isset($fieldMap[$v])) $extra++;
$requiredColumnNum= count($fieldMap) - $extra ; //(- other elements (E.g. TEMP_STAGE_TABLE element)
//-------------------------------------------------------------------------------------------------------------
//////////////////// SPECIAL DIRECTIVES ////////////////////////////////////////////////////////////
$handle = fopen($FPath, "rb");
$contents = fread($handle, filesize($FPath));
if (isset($fieldMap['UTF16DECODE']))
{
//$contents = mb_convert_encoding($contents, "ISO-8859-1","UTF-16LE"); //need PHP5
//$contents = iconv("UTF-16LE","ISO-8859-1",$contents); //need PHP5??! //DON'T WORK !!!
$contents=utf16_to_utf8($contents);
$contents=utf8_decode($contents); //now data is stored with ISO-8859-1 charset
}
//this would change the actual delimiter to semicolon
//Values inside quotes (like ,) will not be replaced by CSVSetSemicolonDelimiter()
if (isset($fieldMap['SETSEMICOLONDELIMITER']) || isset($_GET['SETSEMICOLONDELIMITER']) )
{
if (isset($fieldMap['SETSEMICOLONDELIMITER']))
$delimiter=$fieldMap['SETSEMICOLONDELIMITER'];
else
$delimiter=$_GET['SETSEMICOLONDELIMITER']; //this allow to use this option manually....
$contents=CSVSetSemicolonDelimiter($contents,$delimiter);
}
if (isset($fieldMap['CUTTHOUSANDDELIMITER']))
{
$contents=CSVCutThousandDelimiter($contents);
}
if ( ! isset($fieldMap['1000SCALE'])) //<< otherwise leave the decimal cutting to cutrevenue() function!
{
///////////////////////////////////////////////////////cutRevenue() do again a similar work//////
$contents=CSVCutDecimals($contents); //cut all decimals with . separator
////////////////////////////////////////////////
}
//never delete this files => the version of last import operation remain for debug issues!
$hw = fopen($FPath."_ADJUSTED", 'w');
fwrite($hw, $contents);
//////////////////////////////////////////////////////////////////////////////////////////////////////////////
//fwrite($hw, substr($contents,0,40000));
//return true;
$handle = fopen($FPath."_ADJUSTED", "rb");
$num_inserts=0;
$length=4024;
$field_delimiter=";";
////////////////////////////////////////all CSV files must have semicolon(;) delimiter at this point!////////////
$test_data=fgetcsv($handle, $length, $field_delimiter);
if (count($test_data)<$requiredColumnNum)
{
echo "Something is wrong with the number of field of adjusted file(".count($test_data)." instead of ".$requiredColumnNum.")
see file with _ADJUSTED extension on /Msgs/pto/";
return false;
}
rewind($handle);
////////////////////////////////////////////////////////////////
$idxMap=array();
$idxFilter=-1;
$numFiltered=0;
//########################### SpreadSheet FIELD POSITION recognition ##########################
$spreadsheet_field_name=fgetcsv($handle, $length, $field_delimiter); // these are 1st lines
for ($i=0;$i<count($spreadsheet_field_name);$i++)
{
$spreadsheet_field_name[$i]=trim(str_replace("?","",$spreadsheet_field_name[$i])); //there could be ?? before the column name string..
//echo $spreadsheet_field_name[$i]."---";
if ( array_key_exists( $spreadsheet_field_name[$i] , $fieldMap ))
{
$idxMap[$spreadsheet_field_name[$i]]=$i; //add a new element to $idxMap that associate the field position inside the spreadsheet
//echo $spreadsheet_field_name[$i]."---".$i."<BR>";
}
//detect the idx of the spreadsheet filter (that filter column values could not be inserted into the db)
if (isset($fieldMap['FILTERFIELD_NAME']) && $spreadsheet_field_name[$i]==$fieldMap['FILTERFIELD_NAME'])
$idxFilter=$i;
//echo "<br />";
}
if (count($idxMap)!= $requiredColumnNum )
{
//print_r($idxMap);
//print_r($fieldMap);
echo ("Error: not all required field founded inside the spreadsheet
<br />only ".count($idxMap)."/".( $requiredColumnNum )." founded
<br />Missing are:<br /> ");
foreach ($fieldMap as $k=>$v)
{
if (in_array($k,$specialElementName)) continue;
if (!isset($idxMap[$k])) echo "<b>".$k."</b><br />";
}
return false;
}
//////////////////////////////////////////////////////////////////####################à
if (!isset($fieldMap['APPEND_DATA_TO_TABLE'])) //empty the table only when needed
{
$SQL0="DELETE FROM ".$fieldMap['TEMP_STAGE_TABLE']." WHERE 1=1";
//echo "DEBUG: ".$SQL0."<BR>\n";
if (!mysql_query($SQL0))
{
echo "Error in ".$SQL0."<BR>".mysql_error();
return false;
}
}
$checksumTotal=false;
while ( ($data = fgetcsv($handle, $length, $field_delimiter)) !==false )
{
if ($data[0]==null) continue; //empty lines - where Task Field is empty
if ($data[0]=="Total" && $data[1]==null && $data[2]==null && $data[3]==null && $data[4]==null) //total - drop
{
//$checksumTotal=str_replace(",","",$data[3]); //drop thousand commas
continue;
}
//echo $data [ $idxFilter ]."==".$fieldMap['FILTERFIELD_VALUE']."?";
if (isset($fieldMap['FILTERFIELD_NAME']) && $data[ $idxFilter ]!= $fieldMap['FILTERFIELD_VALUE'])
{
$numFiltered++;
continue;
}
$num_inserts++;
//echo "Processing#".$num_inserts."........ at time ".time()."<BR>".var_dump($data)."<BR>\n";
$SQLFieldValues="";
$SQLFieldNames="";
foreach ($idxMap as $spreadsheetFieldName => $spreadsheetFieldIdx)
{
$fieldValue=$data [ $spreadsheetFieldIdx ]; //spreadsheet value
$fieldName =$fieldMap[ $spreadsheetFieldName ]; //mysql table field name
//echo "---".$fieldName."-------------------".$fieldValue."<br />";
if (( strpos(strtolower($spreadsheetFieldName),'revenue')!==false ||
strpos(strtolower($spreadsheetFieldName),'amount')!==false ) &&
strpos(strtolower($spreadsheetFieldName),'date') ===false)
{
//echo "----".$fieldName."-------------------".$fieldValue."<br />";
//if ($spreadsheetFieldName=="Bookings Amount - CD")
//echo $spreadsheetFieldName.":::::::".$fieldValue.">>>>".CutRevenue($fieldValue);
$fieldValue=CutRevenue($fieldValue,$fieldMap['1000SCALE']); // remove number fractions
}
if ( strpos(strtolower($spreadsheetFieldName),'date') !==false || strpos($spreadsheetFieldName,'FORECAST_DT') !==false )
{
//echo "-----".$fieldName."-------------------".$fieldValue."<br />";
$fieldValue=ConvertDate($fieldValue,$spreadsheetFieldName,$num_inserts); // dates - format conversion
}
if ( trim($spreadsheetFieldName)=="Fiscal Quarter" )
{
//ES: "2012 FY Q 1"
$fieldValue=str_replace(" ","",$fieldValue);
$exp=explode("FY",$fieldValue);
$fieldValue=$exp[1]."FY".substr($exp[0],2);
//echo $fieldValue."<br />";
}
if (isset($fieldMap['AUTOFILL']) && $fieldMap['AUTOFILL']!=='false' && $fieldName!="ChildName") {
if ($fieldValue!='') {
$LastVal[$fieldName]=$fieldValue;
} else {
$fieldValue=$LastVal[$fieldName];
}
}
$SQLFieldNames .=", `".$fieldName."`" ;
$SQLFieldValues.=",'".addslashes(trim(str_replace("'","`",$fieldValue)))."'";
}
if (!isset($fieldMap['NOTAUTOID']))
{
$SQLFieldNames="id".$SQLFieldNames;
$SQLFieldValues="''".$SQLFieldValues;
}
else
{
//remove comma
$SQLFieldNames=substr($SQLFieldNames,1);
$SQLFieldValues=substr($SQLFieldValues,1);
}
$SQL1="INSERT INTO ".$fieldMap['TEMP_STAGE_TABLE']." (".$SQLFieldNames.") VALUES (".$SQLFieldValues.")";
mysql_query($SQL1) or die("Error in ".$SQL1."<BR>".mysql_error());
//echo "DEBUG: ".$num_inserts.":".$SQL1."<BR>\n";
}
if (isset($fieldMap['CHECKSUMFIELD']) && $checksumTotal!==false) //go on with checksum
{
$SQL1="SELECT SUM(".$fieldMap['CHECKSUMFIELD'].") FROM ".$fieldMap['TEMP_STAGE_TABLE'];
$result=mysql_query($SQL1) or die("Error in ".$SQL1."<BR>".mysql_error());
$row=mysql_fetch_array($result);
echo "<br /><br />JITENDER CHECKSUM: <b>".$checksumTotal."</b><br />IMPORT CHECKSUM: <b>".$row[0]."</b><br /><br />";
if ($checksumTotal!=$row[0])
die ("CHECKSUM ERROR");
}
if (isset($fieldMap['FILTERFIELD_NAME']))
{
echo "Filtered ".$numFiltered." rows. Inserted ".$num_inserts." rows";
}
else
echo "Inserted ".$num_inserts." rows";
echo "FileRead Done<BR>\n";
return true;
}
</div> <div class="box-right"> <p> <?=$DayOfWeek?> <br> <span><?=$shortMonth?> <?=ShowYear($row['EVENT_START_DATE'])?></span> </p> </div> </div> <div class="box-text"> <a href=""> <p class="text-title TcolorRed"> <?=$title?> </p> </a> <p class="text-date TcolorGray"> <?=ConvertDate($row['LAST_DATE'])?> </p> <p class="text-des TcolorBlack"> <?=$detail?> </p> <div class="box-btn cf"> <a href="event-detail.php?MID=<?=$MID?>&CID=<?=$row['CAT_ID']?>&SID=<?=$row['SUB_CAT_ID']?>&CONID=<?=$row['CONTENT_ID']?>" class="btn red"><?=$seeAllCap?></a> <div class="box-btn-social cf"> <?php echo ' <a href="'.$fb_link.'" onclick="shareFB(\''.$rowContent['CONTENT_DESC'].'\',$(this).attr(\'href\')); return false;" class="btn-socila fb"></a>'; echo ' <a href="'.$fullpath.'" onclick="shareTW(\''.$rowContent['CONTENT_ID'].'\',\''.$rowContent['CONTENT_DESC'].'\',$(this).attr(\'href\')); return false;" class="btn-socila tw"></a>'; ?> </div> </div> </div> </div>
while($row = mysql_fetch_array($query)) {
?>
<div class="box-carrer-main">
<div class="box-row">
<div class="box-top cf">
<h3><? echo $row['CONTENT_DESC'] ?></h3>
<div class="number"><span><? echo $row['PRICE_RATE_LOC'] ?></span> อัตรา</div>
</div>
<div class="box-bottom cf">
<div class="box-footer-content cf">
<div class="box-date-modified">
<?=$lastEditCap?> : <? echo ConvertDate($row['CREATE_DATE']) ?>
</div>
</div>
</div>
</div>
</div>
<div class="box-detail-main">
<? echo $row['CONTENT_DETAIL_LOC'] ?>
<div class="box-btn cf">
<a href="contact-eapp-register.php" class="btn red">Apply job</a>
</div>
</div>
WHERE REF_WEBBOARD_ID = ".$row['WEBBOARD_ID']." AND FLAG = 0 "; $query_ans = mysql_query($sq_ans, $conn); $row_ans = mysql_fetch_array($query_ans); $detail = str_replace($goodword, $badword, $detail); ?> <div class="table-row list cf"> <div class="column list"><?=str_pad($row['WEBBOARD_ID'], 5, 0, STR_PAD_LEFT) ?></div> <div class="column topic"><a href="km-webboard-topic.php?web_id=<?=$row['WEBBOARD_ID'] ?>"><?=$content ?></a></div> <div class="column name"><span><? echo $row['USER_CREATE'] ?></span></div> <div class="column reply"><? echo $row_ans['ans'] ?></div> <div class="column view"><? echo $row['VISIT_COUNT'] ?></div> <div class="column date"><? echo ConvertDate($row['LAST_UPDATE_DATE']) ?></div> </div> <? } ?> </div> </div> </div> </div> </div> </div> <div class="box-freespace"></div>
<div class="orderDetailBox floatL orderDetailBox1"> <div class="floatL orderDetailBoxTitle">ถึง</div> <div class="floatL orderDetailBoxText"><? echo $row['name']; ?></div> <div class="floatL orderDetailBoxTitle">เบอร์โทรศัพท์</div> <div class="floatL orderDetailBoxText"><? echo $row['TELEPHONE']; ?></div> <div class="floatL orderDetailBoxTitle">เบอร์มือถือ</div> <div class="floatL orderDetailBoxText"><? echo $row['MOBILE_PHONE']; ?></div> <div class="floatL orderDetailBoxTitle">สถานที่ส่ง</div> <div class="floatL orderDetailBoxText"><? echo $row['addr']; ?></div> <span class="clear"></span> </div> <div class="orderDetailBox floatL orderDetailBox2"> <div class="floatL orderDetailBoxTitle">เลขที่ใบสั่งซื้อ</div> <div class="floatL orderDetailBoxText"><? echo $row['ORDER_ID']; ?></div> <div class="floatL orderDetailBoxTitle">วันที่</div> <div class="floatL orderDetailBoxText"><? echo ConvertDate($row['CREATE_DATE']); ?></div> <div class="floatL orderDetailBoxTitle">ส่งสินค้า</div> <div class="floatL orderDetailBoxText"><? echo $row['STATUS_NAME_LOC']; ?></div> <div class="clear"></div> </div> <? } ?> <div class="clear"></div> </div> <?php $order_id = intval($_GET['order_id']); $sql_order = " select prod.PRODUCT_ID, prod.PRODUCT_DESC_LOC, prod.PRICE, orderd.QUANTITY, (prod.PRICE * orderd.QUANTITY ) total, od.ORDER_ID from trn_product prod inner join trn_order_detail orderd on prod.PRODUCT_ID = orderd.PRODUCT_ID
cd.CAT_ID = " . $all_event_cat_id . " AND cd.SUB_CAT_ID = " . $museumDataNetworkNewsSubCat . " AND cd.MUSUEM_ID = " . $MDNID;
$newsRs = mysql_query($newsSql) or die(mysql_error());
while ($newsRow = mysql_fetch_array($newsRs)) {
$linkTo = "mdn-news-detail.php?CID=" . $newsRow["CAT_ID"] . "&SCID=" . $newsRow["SUB_CAT_ID"] . "&CONID=" . $newsRow["CONTENT_ID"] . "&MDNID=" . $MDNID;
echo '<div class="museum-news cf">';
echo '<div class="box-pic">';
echo '<a href="' . $linkTo . '"><img src="' . callThumbListFrontEnd($newsRow['CONTENT_ID'], $newsRow['CAT_ID'], true) . '"></a>';
echo '</div>';
echo '<div class="box-text">';
echo '<a href="' . $linkTo . '">';
echo '<p class="text-title TcolorRed">';
echo $newsRow['CONTENT_DESC'];
echo '</p></a>';
echo '<p class="text-date TcolorGray">';
echo ConvertDate($newsRow['LAST_DATE']);
echo '</p>';
echo '</div>';
echo '</div>';
}
?>
</div>
</div>
</div>
</div>
<div class="part-btn-back">
<div class="box-btn cf">
<a href="" class="btn red">ย้อนกลับ</a>
<span>ประเภท: .<?=$ext ?></span>
<span>ขนาด: <?=$size ?></span>
</p>
</div>
<div class="box-btn cf">
<a href="<?=$link ?>" target="_blank" class="btn red">ดาวน์โหลด</a>
</div>
</div>
<?php } } ?>
</div>
</div>
<?php } ?>
<div class="box-footer-content cf">
<div class="box-date-modified">
วันที่แก้ไขล่าสุด : <?= ConvertDate($rowContent['LAST_DATE']) ?>
</div>
<div class="box-plugin-social">
<div class="fb-share-button" data-href="<?=$path ?>" data-layout="button_count"></div>
<a href="https://twitter.com/share" class="twitter-share-button" data-url="<?=$fullpath ?>">Tweet</a>
<div class="g-plus" data-action="share" data-annotation="bubble" data-href="<?=$fullpath ?>"></div>
<span>
<script type="text/javascript" src="//media.line.me/js/line-button.js?v=20140411" ></script>
<script type="text/javascript">
new media_line_me.LineButton({"pc":false,"lang":"en","type":"a","text":"<?=$path ?>
","withUrl":true});
</script>
</span>
</div>
</div>
</div>
if (empty($_REQUEST['d_FSScheduledDateAll'])) {
$Phase = intval($_REQUEST['d_Phase']);
$Phase2 = max(2, $Phase * 2);
$SQL = "select" . " FSScheduledDate," . " date_format(FSScheduledDate, '" . get_text('DateFmtDB') . "') DateFormatted," . " UNIX_TIMESTAMP(concat(FSScheduledDate, ' ', FSScheduledTime)) UnixTime " . "FROM FinSchedule " . " INNER JOIN Grids on FsMatchNo=GrMatchNo " . "WHERE" . " FSEvent=" . StrSafe_DB($_REQUEST['d_Event']) . " " . " AND FSTeamEvent = 0" . " AND FSTournament = " . StrSafe_DB($_SESSION['TourId']) . " " . " AND GrPhase = {$Phase2} " . "ORDER BY" . " FSScheduledDate desc," . " FSScheduledTime desc " . "LIMIT 1";
$q = safe_r_sql($SQL);
if ($r = safe_fetch($q)) {
$date = $r->FSScheduledDate;
$_REQUEST['d_FSScheduledDateAll'] = $r->DateFormatted;
}
if (substr($_REQUEST['d_FSScheduledTimeAll'], 0, 1) == '+') {
$time = date('H:i:s', strtotime($_REQUEST['d_FSScheduledTimeAll'] . ' minutes', $r->UnixTime));
$_REQUEST['d_FSScheduledTimeAll'] = substr($time, 0, 5);
}
}
$time = empty($time) ? Convert24Time($_REQUEST['d_FSScheduledTimeAll']) : $time;
$date = empty($date) ? ConvertDate($_REQUEST['d_FSScheduledDateAll']) : $date;
$matchLen = isset($_REQUEST['d_FSScheduledLenAll']) && strlen(trim($_REQUEST['d_FSScheduledLenAll'])) > 0 && intval($_REQUEST['d_FSScheduledLenAll']) >= 0 ? $_REQUEST['d_FSScheduledLenAll'] : 0;
if (!(($time || strlen(trim($_REQUEST['d_FSScheduledTimeAll'])) == 0) && ($date || strlen(trim($_REQUEST['d_FSScheduledDateAll'])) == 0) && $date >= $_SESSION['TourRealWhenFrom'] && $date <= $_SESSION['TourRealWhenTo'])) {
$Errore = 1;
}
if (IsBlocked(BIT_BLOCK_TOURDATA)) {
$Errore == 1;
}
if ($Errore == 0) {
$PhaseFilter = '';
if ($_REQUEST['d_Phase'] != 1) {
$PhaseFilter = "GrPhase=" . StrSafe_DB($_REQUEST['d_Phase']) . " ";
} else {
$PhaseFilter = "(GrPhase='0' OR GrPhase='1') ";
}
$Insert = "INSERT INTO FinSchedule (FSEvent,FSTeamEvent,FSMatchNo,FSTournament,FSScheduledDate,FSScheduledTime,FSScheduledLen) " . "(SELECT " . StrSafe_DB($_REQUEST['d_Event']) . ", '0', GrMatchNo," . StrSafe_DB($_SESSION['TourId']) . "," . StrSafe_DB($date) . "," . ($time ? StrSafe_DB($time) : 'null') . ", " . $matchLen . " " . "FROM Grids " . "WHERE " . $PhaseFilter . ") " . "ON DUPLICATE KEY UPDATE " . "FSTarget=FSTarget,FSGroup=FSGroup, " . "FSScheduledDate=" . StrSafe_DB($date) . "," . "FSScheduledTime=" . ($time ? StrSafe_DB($time) : 'null') . "," . "FSScheduledLen=" . $matchLen;
<div class="box-bottom"> <div class="box-topic-detail"> <?php echo $detail; ?> </div> <hr/> <div class="box-footer-topic cf"> <div class="box-left"> <p><?php echo $create_by; ?> : <? echo $row['USER_CREATE'] ?></p> </div> <div class="box-right"> <p><? echo ConvertDate($row['LAST_UPDATE_DATE']) ?></p> </div> </div> </div> </div> <?php ////ส่วนคำตอบ $sq_ans = " SELECT CONTENT, USER_CREATE, LAST_UPDATE_DATE , ORDER_DATA FROM trn_webboard\r\n\t\t\t\t\t\t\tWHERE REF_WEBBOARD_ID = " . $id . " AND FLAG <> 2 ORDER BY ORDER_DATA ASC "; $query_ans = mysql_query($sq_ans, $conn); ?> <div class="box-replay-main"> <?
<span>ประเภท: .<?=$ext ?></span>
<span>ขนาด: <?=$size ?></span>
</p>
</div>
<div class="box-btn cf">
<a href="<?=$link ?>" target="_blank" class="btn red">ดาวน์โหลด</a>
</div>
</div>
<?php } } ?>
</div>
</div>
<?php } ?>
<div class="box-footer-content cf">
<div class="box-date-modified">
วันที่แก้ไขล่าสุด : <? echo ConvertDate($row['LAST_UPDATE_DATE']) ?>
</div>
<div class="box-plugin-social">
<div class="fb-share-button" data-href="<?=$path ?>" data-layout="button_count"></div>
<a href="https://twitter.com/share" class="twitter-share-button" data-url="<?=$fullpath ?>">Tweet</a>
<div class="g-plus" data-action="share" data-annotation="bubble" data-href="<?=$fullpath ?>"></div>
<span>
<script type="text/javascript" src="//media.line.me/js/line-button.js?v=20140411" ></script>
<script type="text/javascript">
new media_line_me.LineButton({"pc":false,"lang":"en","type":"a","text":"<?=$path ?>","withUrl":true});
</script>
</span>
</div>
</div>
</div>
} else {
echo '<div class="box-date-tumb">';
echo '<p class="date">' . $date[0] . '</p>';
echo '<p class="month">' . $date[1] . '</p>';
echo '</div>';
}
echo '</div>';
echo '</a>';
echo '<div class="box-text">';
echo '<a href="' . $detailPage . '?MID=' . $MID . '&CID=' . $row['CAT_ID'] . '&SID=' . $row['SUB_CAT_ID'] . '&CONID=' . $row['CONTENT_ID'] . '&date=day">';
echo '<p class="text-title TcolorRed">';
echo $title;
echo '</p>';
echo '</a>';
echo '<p class="text-date TcolorGray">';
echo ConvertDate($row['LAST_DATE']);
echo '</p>';
echo '<p class="text-des TcolorBlack">';
echo $detail;
echo '</p>';
echo '<div class="box-btn cf">';
echo '<a href="' . $detailPage . '?MID=' . $MID . '&CID=' . $row['CAT_ID'] . '&SID=' . $row['SUB_CAT_ID'] . '&CONID=' . $row['CONTENT_ID'] . '&date=day" class="btn red">' . $txt_more . '</a>';
echo '<div class="box-btn-social cf">';
echo '<a href="' . $fb_link . '" onclick="shareFB(\'' . $title . '\',$(this).attr(\'href\')); return false;" class="btn-socila fb"></a>';
echo '<a href="' . $fullpath . '" onclick="shareTW(\'' . $row_row1['CONTENT_ID'] . '\',\'' . $title . '\',$(this).attr(\'href\')); return false;" class="btn-socila tw"></a>';
echo '</div>';
echo '</div>';
echo '</div>';
echo '</div>';
$index++;
<span><?=$sizeCap ?>: <?=$size ?></span>
</p>
</div>
<div class="box-btn cf">
<a href="<?=$link ?>" target="_blank" class="btn red"><?=$downloadCap ?></a>
</div>
</div>
<?php } } ?>
</div>
</div>
<?php } ?>
<div class="box-footer-content cf">
<div class="box-date-modified">
<?=$lastEditCap ?> : <? echo ConvertDate($row['LAST_UPDATE_DATE']) ?>
</div>
<div class="box-plugin-social">
<div class="fb-share-button" data-href="<?=$path ?>" data-layout="button_count"></div>
<a href="https://twitter.com/share" class="twitter-share-button" data-url="<?=$fullpath ?>">Tweet</a>
<div class="g-plus" data-action="share" data-annotation="bubble" data-href="<?=$fullpath ?>"></div>
<span>
<script type="text/javascript" src="//media.line.me/js/line-button.js?v=20140411" ></script>
<script type="text/javascript">
new media_line_me.LineButton({"pc":false,"lang":"en","type":"a","text":"<?=$path ?>
","withUrl":true});
</script>
</span>
</div>
</div>
&CID=<?php
echo $categoryID;
?>
&CONID=<?php
echo $rowContent['CONTENT_ID'];
?>
">
<p class="text-title TcolorWhite">
<?php
echo $rowContent['CONTENT_DESC'];
?>
</p>
</a>
<p class="text-date TcolorGray">
<?php
echo ConvertDate($rowContent['LAST_DATE']);
?>
</p>
<p class="text-des TcolorWhite">
<?php
echo $rowContent['BRIEF_LOC'];
?>
</p>
<div class="box-btn cf">
<a href="da-detail.php?MID=<?php
echo $MID;
?>
&CID=<?php
echo $categoryID;
?>
&CONID=<?php
<?php
require_once dirname(dirname(__FILE__)) . '/config.php';
require_once 'Common/Lib/Fun_DateTime.inc.php';
if (!CheckTourSession() || !isset($_REQUEST['rowid']) || !isset($_REQUEST['date']) || !isset($_REQUEST['time']) || !isset($_REQUEST['len']) || !isset($_REQUEST['from']) || !isset($_REQUEST['to'])) {
print get_text('CrackError');
exit;
}
$Errore = 0;
$date = ConvertDate($_REQUEST['date']);
$time = Convert24Time($_REQUEST['time']);
$badDate = (false and !($date >= date('Y-m-d', $_SESSION['ToWhenFromUTS']) && $date <= date('Y-m-d', $_SESSION['ToWhenToUTS'])));
$len = intval($_REQUEST['len']);
$from = intval($_REQUEST['from']);
$to = intval($_REQUEST['to']);
$tmpEvent = '';
$tmpDbEvent = '';
if ($date && $time && !$badDate && $from && $to && $to >= $from) {
if ($_REQUEST['rowid'] == -1) {
$query = "INSERT INTO FinTraining (FtTournament, FtScheduledDate, FtScheduledTime, FtScheduledLen, FtTargetFrom, FtTargetTo) " . "VALUES (" . StrSafe_DB($_SESSION['TourId']) . "," . StrSafe_DB($date) . "," . StrSafe_DB($time) . "," . StrSafe_DB($len) . "," . StrSafe_DB($from) . "," . StrSafe_DB($to) . ")";
} else {
$query = "UPDATE FinTraining SET " . "FtScheduledDate = " . StrSafe_DB($date) . "," . "FtScheduledTime = " . StrSafe_DB($time) . "," . "FtScheduledLen = " . StrSafe_DB($len) . "," . "FtTargetFrom = " . StrSafe_DB($from) . "," . "FtTargetTo = " . StrSafe_DB($to) . "WHERE FtTournament=" . StrSafe_DB($_SESSION['TourId']) . " AND FtScheduledDate=" . StrSafe_DB($_REQUEST['olddate']) . " AND FtScheduledTime= " . StrSafe_DB($_REQUEST['oldtime']) . " AND FtTargetFrom = " . StrSafe_DB($_REQUEST['oldfrom']) . " ";
}
$rs = safe_w_sql($query);
if (!$rs) {
$Errore = 1;
}
//salvo gli eventi se presenti
if (isset($_REQUEST["event"]) && is_array($_REQUEST["event"])) {
$query = "DELETE FROM FinTrainingEvent " . "WHERE FteTournament=" . StrSafe_DB($_SESSION['TourId']) . " AND FteScheduledDate=" . StrSafe_DB($_REQUEST['olddate']) . " AND FteScheduledTime= " . StrSafe_DB($_REQUEST['oldtime']) . " AND FteTargetFrom = " . StrSafe_DB($_REQUEST['oldfrom']) . " ";
$rs = safe_w_sql($query);
<div class="floatL checkboxContent"><input type="checkbox" name="check" value="<?php
echo $row['DIGITAL_ID'];
?>
"></div>
<div class="floatL thumbContent">
<a href="product_detail.php?p=<?php
echo $row['DIGITAL_ID'];
?>
&g=<?php
echo $row['SUB_DIGITAL_ID'];
?>
" class="dBlock" style="background-image: url('http://cache.my.kapook.com/imgkapook_2014/31_35_1438829370.jpg');"></a>
</div>
<div class="floatL nameContent">
<div><? echo '<a href="digital_detail.php?p='.$row['DIGITAL_ID'].'&g='.$row['SUB_DIGITAL_ID'].'">'. $row['DIGITAL_DESC_LOC'].'</a>' ?></div>
<div>วันที่สร้าง <? echo ConvertDate($row['CREATE_DATE']); ?> | วันที่ปรับปรุง <? echo ConvertDate($row['LAST_UPDATE_DATE']); ?></div>
</div>
<div class="floatL stausContent">
<? if($row['FLAG'] == 0){ ?>
<span class="staus1"></span> <a href="digital_action.php?enable&p=<?php
echo $row['DIGITAL_ID'];
?>
&g=<?php
echo $row['FLAG'];
?>
&a=<?php
echo $row['SUB_DIGITAL_ID'];
?>
">
Enable
// matchno calcolato
list(, $cc, $ee, $mm) = explode('_', $Key);
$mm2 = $mm + 1;
if ($cc == 'FSScheduledLen' && (strlen(trim($vv)) == 0 || !$vv)) {
$SearchifMatch = "SELECT * from FinSchedule " . "where " . " FSEvent=" . StrSafe_DB($ee) . " AND FSTeamEvent='1'" . " AND FSMatchNo in ({$mm}, {$mm2}) " . " AND FSTournament=" . StrSafe_DB($_SESSION['TourId']);
$Rs = safe_R_sql($SearchifMatch);
if (safe_num_rows($Rs) && strlen(trim($vv)) == 0) {
$vv = 0;
} elseif (!safe_num_rows($Rs) && !$vv) {
$vv = '';
}
}
if (strlen(trim($vv)) > 0) {
$badDate = false;
if ($cc == 'FSScheduledDate') {
$vv = ConvertDate($Value);
$badDate = !($vv >= date('Y-m-d', $_SESSION['ToWhenFromUTS']) && $vv <= date('Y-m-d', $_SESSION['ToWhenToUTS']));
} elseif ($cc == 'FSScheduledTime') {
$vv = Convert24Time($vv);
}
if ($vv > 0 && !$badDate || $vv == 0 && $cc == 'FSScheduledLen') {
// Scrivo per $mm
$Insert = "INSERT INTO FinSchedule (FSEvent,FSTeamEvent,FSMatchNo,FSTournament," . $cc . ") " . "VALUES(" . StrSafe_DB($ee) . "," . StrSafe_DB('1') . "," . StrSafe_DB($mm) . "," . StrSafe_DB($_SESSION['TourId']) . "," . StrSafe_DB($vv) . "" . ") " . "ON DUPLICATE KEY UPDATE " . "FSTarget=FSTarget," . "FSGroup=FSGroup," . $cc . "=" . StrSafe_DB($vv) . " ";
$Rs = safe_w_sql($Insert);
if (!$Rs) {
$Errore = 1;
} else {
// Scrivo per $mm2
$Insert = "INSERT INTO FinSchedule (FSEvent,FSTeamEvent,FSMatchNo,FSTournament," . $cc . ") " . "VALUES(" . StrSafe_DB($ee) . "," . StrSafe_DB('1') . "," . StrSafe_DB($mm2) . "," . StrSafe_DB($_SESSION['TourId']) . "," . StrSafe_DB($vv) . "" . ") " . "ON DUPLICATE KEY UPDATE " . "FSTarget=FSTarget," . "FSGroup=FSGroup," . $cc . "=" . StrSafe_DB($vv) . " ";
$Rs = safe_w_sql($Insert);
}
</div> </div> <div class="box-slide-small"> <div id="sync2" class="owl-carousel"> <?=$thumbRender ?> </div> </div> </div> <div class="box-news-text"> <p> <?=$eventRow['CONTENT_DETAIL_DESC'] ?> </p> </div> <div class="box-footer-content cf"> <div class="box-date-modified"> วันที่แก้ไขล่าสุด : <?=ConvertDate($eventRow['LAST_DATE']) ?> </div> <div class="box-plugin-social"> Plugin Social </div> </div> </div> <div class="part-btn-back"> <div class="box-btn cf"> <a href="mdn-detail.php?MDNID=<?=$MDNID ?>" class="btn red">กลับไปพิพิธภัณฑ์</a> </div> </div> </div> </div> </div>
function CleanDate($Date)
{
$Y = 0;
$m = 0;
$d = 0;
$bits = preg_split('#[ ./-]#sim', $Date);
foreach ($bits as $k => $bit) {
$bits[$k] = intval($bit);
}
// if only one, presume it is the day, the rest is added based on now
if (count($bits) == 1) {
return date('Y-m-') . str_pad($bits[0], 2, '0', STR_PAD_LEFT);
}
if (count($bits) == 2) {
// day+month, so add year and convert!
$bits[] = date('Y');
}
if (strlen($bits[0]) == 4) {
// it is a Y-m-d already
return sprintf('%04d-%02d-%02d', $bits[0], $bits[1], $bits[2]);
}
return ConvertDate(implode('-', $bits));
}
