/** * 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)); }