<?php
/********************************************************************************************************************
#Coder : Kapil Verma
#Description : This Code is used to display list of all product and remove any on them
*********************************************************************************************************************/
extract($_GET);
extract($_POST);
$obj_product = new common();
$currentTimestamp = getCurrentTimestamp();
if ($pid != '' && $action == 'delete') {
$deleteProduct = $obj_product->delete(TBL_GHEAD, 'id =' . $pid);
$_SESSION['msg'] = RECORD_DELETE;
echo '<script>location.href="' . DEFAULT_ADMIN_URL . '/group_head/index.php";</script>';
exit;
}
$getProduct = $obj_product->read(TBL_GHEAD, '', ' creation_date DESC');
?>
<?php
/********************************************************************************************************************
#Coder : Kapil Verma
#Description : This Code is used to display list of all product and remove any on them
*********************************************************************************************************************/
extract($_GET);
extract($_POST);
$obj_product = new common();
$currentTimestamp = getCurrentTimestamp();
if ($prod_id != '' && $action == 'delete') {
$deleteProduct = $obj_product->delete(TBL_MEMBER, 'id =' . $prod_id);
unlink(LIST_ROOT_ADMIN . "/members/upload/" . $file);
$_SESSION['msg'] = RECORD_DELETE;
echo '<script>location.href="' . DEFAULT_ADMIN_URL . '/admin/members/index.php";</script>';
}
$getProduct = $obj_product->read(TBL_MEMBER);
?>
</tr>
</table></td>
</tr>
<tr>
<td align="center" valign="top"><table width="600" border="0" cellspacing="0" cellpadding="0" align="center">
<tr>
<td align="left" valign="top" style="font-family:Arial, Helvetica, sans-serif; font-size:42px; color:#1e1e1e; font-weight:bold; text-transform:uppercase;" id="new_car_link">New Cars</td>
</tr>
<tr>
<td align="left" valign="top" style="font-family:Arial, Helvetica, sans-serif; font-size:12px; color:#4c5051; line-height:18px; padding:10px 0 18px 0; border-bottom:2px dashed #e8e8e8;"> SYLC Corporation vous apporte les affaires "STOCK U.S.A NEUF" du moment. Decouvrez des lots de voitures americaines diponbles immediatement aux US mais aussi disponible sur le territoire europeen.
Veuillez nous contacter afin de reserver votre vehicule, demande de renseignement ou brochures. </td>
</tr>
</table></td>
</tr>';
$common_object = new common();
$used_car_text = mysql_fetch_object($common_object->read(TBL_ADMIN, "", ''));
$all_brands = $common_object->read(TBL_BRANDS, "publish='yes'", '');
while ($brands = mysql_fetch_object($all_brands)) {
$childs = $common_object->read(TBL_NEW_CAR, "brand_id={$brands->id} AND publish=1", '');
$full_data .= '<tr>
<td align="center" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td align="left" valign="top"><table width="600" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td align="left" valign="top" style="padding:0 0 10px 0;"><img src="http://www.sylc-export.com/voitures-americaines/superadmin/images/brands/' . $brands->logo . '" width="172" height="98" alt="ford" border="0" /></td>
</tr>
</table></td>
</tr>
<tr>
<td align="center" valign="top"><table width="600" border="0" align="center" cellpadding="0" cellspacing="0" style="border:1px solid #e1e1e1; border-bottom:0px;">
<tr>
<?php
extract($_GET);
$url_listing = DEFAULT_URL . '/revue_automobiles';
if (isset($_GET['reviewID'])) {
$id = convert_uudecode(base64_decode($_GET['reviewID']));
$obj_setting = new common();
$fetchSetting = $obj_setting->read('reviews', 'id = ' . $id);
$getSetting = $db->fetchNextObject($fetchSetting);
$id = $getSetting->id;
$short_description = $getSetting->short_description;
$old_new = $getSetting->old_new;
$make = $getSetting->make;
$model = $getSetting->model;
$pdsf = $getSetting->pdsf;
$mpg = $getSetting->mpg;
$make_name = $getSetting->make_name;
$model_name = $getSetting->model_name;
$year = $getSetting->year;
$expert = $getSetting->expert;
$ensemble = $getSetting->ensemble;
$ensemble = $getSetting->ensemble;
$characteristique = $getSetting->characteristique;
$image = $getSetting->image;
$title = $make_name . ' ' . $model_name . ' ' . $year;
$currentUrl = DEFAULT_URL . $_SERVER['REQUEST_URI'];
$all_media_query = $obj_setting->customQuery("SELECT * FROM reviews_media WHERE review_id=" . $id);
$all_media = array();
while ($mediaRow = mysql_fetch_object($all_media_query)) {
$mediaid = $mediaRow->id;
$review_id = $mediaRow->review_id;
#Description : This Code is used to Manage Pages
*************************************************************************************************************/
extract($_GET);
extract($_POST);
$obj_setting = new common();
$obj = new validation();
#Code to Fetch page category data
#END
$publish = 1;
/* Get Current Date Time Stamp */
$currentTimestamp = getCurrentTimestamp();
if ($_SERVER['REQUEST_METHOD'] == 'POST') {
$error = '';
/*validate required fields*/
$obj->add_fields($content, 'req', 'Please Enter Content');
$error = $obj->validate();
if ($error) {
$errorMsg = "<font color='#FF0000' family='verdana' size=2>Please fill all required fields.</font>";
} else {
/*save welcome section content*/
$dataArr = array('content' => $content);
$banner_insert = $obj_setting->update('editor_rows', $dataArr, "id=1");
$_SESSION['success_msg'] = 'Successfully Saved';
echo '<script>location.href="' . DEFAULT_URL . '/superadmin/home/welcome.php";</script>';
exit;
}
}
/*Fetch welcome section content*/
$fetchSetting = $obj_setting->read('editor_rows', 'id = 1');
$getSetting = $db->fetchNextObject($fetchSetting);
$content = $getSetting->content;
/* Get Current Date Time Stamp */
$currentTimestamp = getCurrentTimestamp();
$obj_handle = new Handle();
if (isset($submit) && $submit != "" && $_SERVER['REQUEST_METHOD'] == 'POST') {
$error = '';
$obj->add_fields($name, 'req', 'Please Enter Group-Head Name');
$obj->add_fields($address, 'req', 'Please Enter Address');
$obj->add_fields($phone, 'req', 'Please Enter Phone No');
$obj->add_fields($phone, 'num', 'Please Enter Valid Phone No');
$obj->add_fields($phone, 'min=6', 'Please Enter Valid Phone No');
$obj->add_fields($phone, 'max=12', 'Please Enter Valid Phone No');
$error = $obj->validate();
if ($error) {
$errorMsg = "<font color='#FF0000' family='verdana' size=2>" . $error . "</font>";
} else {
$dataArr = array('name' => $name, 'address' => $address, 'phone' => $phone, 'status' => $publish, 'creation_date' => $currentTimestamp);
$update_product = $obj_product->update(TBL_GHEAD, $dataArr, 'id=' . $prod_id);
$_SESSION['msg'] = RECORD_UPDATE;
redirectUrl(DEFAULT_ADMIN_URL . '/group_head/index.php');
//echo '<script>location.href="'.DEFAULT_ADMIN_URL.'/group_head/index.php";</script>';
exit;
}
} else {
#Code to Fetch seleted ID's data
$getProduct = $obj_product->read(TBL_GHEAD, 'id=' . $prod_id);
$fetchProduct = $db->fetchNextObject($getProduct);
$name = $fetchProduct->name;
$address = $fetchProduct->address;
$phone = $fetchProduct->phone;
$publish = $fetchProduct->status;
}
<?php
session_start();
$error = 0;
$error_login_msg = "";
if (trim($_POST['useremail']) != "") {
$common = new common();
$wherecondition = "email='" . trim($_POST['useremail']) . "'";
$usercount = $common->numberOfRows("users", $wherecondition);
if ($usercount == 0) {
$error_login_msg = '<span class="error_msg">Email non reconnu! Veuillez réessayer ou créer un nouveau compte.</span>';
} else {
$userqrywhrcondition = "email='" . trim($_POST['useremail']) . "'";
$user = $common->read("users", $userqrywhrcondition);
$uservalue = mysql_fetch_object($user);
//$password = base64_decode($uservalue->original_pswd);
$password = base64_decode($uservalue->password);
// Your subject
$subject = 'mot de passe oublié';
$message = nl2br("Message de La Centrale : compte utilisateur\n\t\t\t\t\t\t\tLa Centrale\n\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t------------------------------\n\t\t\t\t\t\t\t\n\t\t\t\t\t\t\tVous avez oublié votre mot de passe : \n\t\t\t\t\t\t\t\n\t\t\t\t\t\t\tIdentifiant : " . trim($_POST['useremail']) . "\n\t\t\t\t\t\t\t\n\t\t\t\t\t\t\tMot de passe : {$password}");
$message = html_entity_decode(htmlentities($message, ENT_QUOTES, "UTF-8"));
$sentmail = sendSmtpMail(trim($_POST['useremail']), $subject, $message);
$error_login_msg = '<span class="success_msg">Mot de passe envoyé ! Si le message n\'apparaît pas d\'ici quelques minutes, vérifiez les courriers indésirables.</span>';
//echo "<script>window.location.href = '".DEFAULT_URL."/wishlist'</script>";
}
} else {
if (isset($_POST['useremail'])) {
$error_login_msg = '<span class="error_msg">S\'il vous plaît entrez l\'adresse e-mail valide pour obtenir votre mot de passe.</span>';
}
}
$obj_setting = new common();
$obj = new validation();
#Code to Fetch page category data
if ($_SERVER['REQUEST_METHOD'] == 'POST') {
$error = '';
/*validate required fields*/
$obj->add_fields($brand_name, 'req', 'Please Enter Brand Name');
$id = $_GET['id'];
$obj->add_fields($brand_name, 'unique', 'Please Enter Unique Brand Name', 'car_brands', "brand_name='" . $brand_name . "' and id!=" . $id);
$error = $obj->validate();
if ($error) {
$errorMsg = "<font color='#FF0000' family='verdana' size=2>" . $error . "</font>";
} else {
/*save welcome section content*/
$dataArr = array('brand_name' => $brand_name);
if (!isset($_GET['id'])) {
$aboutusInsert = $obj_setting->save('car_brands', $dataArr);
} else {
$aboutusInsert = $obj_setting->update('car_brands', $dataArr, 'id = ' . $_GET['id']);
}
$_SESSION['success_msg'] = 'Successfully Saved';
echo '<script>location.href="' . DEFAULT_URL . '/superadmin/home/brands.php";</script>';
exit;
}
}
/*Fetch brandn content*/
if (isset($_GET['id'])) {
$fetchSetting = $obj_setting->read('car_brands', 'id = ' . $_GET['id']);
$getSetting = $db->fetchNextObject($fetchSetting);
$brandName = $getSetting->brand_name;
}
<?php
/*************************************************************************************************************
#Coder : Keshav Sharma
*************************************************************************************************************/
extract($_GET);
extract($_POST);
$obj_block = new common();
$obj = new validation();
$obj_handle = new Handle();
$getbrandBlock = $obj_block->read(TBL_BRANDS, " publish=1");
/* Get Current Date Time Stamp */
$currentTimestamp = getCurrentTimestamp();
/* Get list of all brands */
if (isset($sub) && $sub != "" && $_SERVER['REQUEST_METHOD'] == 'POST') {
$error = '';
$obj->add_fields($model_name, 'req', 'Please Enter Model');
$obj->add_fields($brand_id, 'req', 'Please Select Brand');
$obj->add_fields($year, 'req', 'Please Enter Year');
$obj->add_fields($year, 'num', 'Please Enter vaild Year');
$obj->add_fields($color, 'req', 'Please Enter Color');
$obj->add_fields($dispo, 'req', 'Please Enter Dispo');
$obj->add_fields($prix, 'req', 'Please Enter Prix');
$obj->add_fields($stockType, 'req', 'Please Select Stock Type');
$obj->add_fields($_FILES['file']['name'], 'req', 'Please Upload Image');
$obj->add_fields($_FILES['file'], 'ftype=jpg,gif,png', 'Please Upload Valid Image');
$error = $obj->validate();
//--------------------------------------------//
<?php
extract($_POST);
extract($_GET);
$obj_setting = new common();
/*Fetch tabs*/
$total_rows = $common->numberOfRows('content_page', "page_name='presentation'");
$allTabs = $common->customQuery("SELECT slug,tab_title FROM content_page where page_name='presentation' ORDER BY id ASC");
/*Fetch tab content*/
if ($tab_title == '') {
$tab_title = 'presentation';
}
$fetchSetting = $obj_setting->read('content_page', "slug = '{$tab_title}'");
$getSetting = $db->fetchNextObject($fetchSetting);
$content = $getSetting->content;
/*Fetch banner section content*/
$fetchSetting = $obj_setting->read('content_page', 'id = 6');
$getSetting = $db->fetchNextObject($fetchSetting);
$topBanner = $getSetting->content;
$fetchSetting = $obj_setting->read('content_page', 'id = 7');
$getSetting = $db->fetchNextObject($fetchSetting);
$sideBanner = $getSetting->content;
$image_name = time() . $_FILES['file']['name'];
$path = LIST_ROOT . '/images/pages/media/';
move_uploaded_file($_FILES["file"]["tmp_name"], $path . $image_name);
} else {
$image_name = $oldimage;
}
$slug = str_replace(' ', '_', strtolower($tabtitle));
$dataArr = array('title' => $mediaTitle, 'image' => $image_name, 'youtubeurl' => $url, 'type' => $media_type);
if ($id == "") {
$banner_insert = $obj_setting->save('media', $dataArr);
} else {
$banner_insert = $obj_setting->update('media', $dataArr, "id=" . $id);
}
$_SESSION['success_msg'] = 'Successfully Saved';
echo '<script>location.href="' . DEFAULT_URL . '/superadmin/page/media.php";</script>';
exit;
}
}
/*Fetch banner section content*/
if (isset($_GET['id'])) {
$fetchSetting = $obj_setting->read('media', 'id = ' . $_GET['id']);
$getSetting = $db->fetchNextObject($fetchSetting);
$id = $getSetting->id;
$mediaType = $getSetting->type;
$mediaTitle = $getSetting->title;
$bannerImage = $getSetting->image;
$url = $getSetting->youtubeurl;
$heading = "Edit";
} else {
$heading = "Add New";
}
#Description : This Code is used to Manage Pages
*************************************************************************************************************/
extract($_GET);
extract($_POST);
$obj_setting = new common();
$obj = new validation();
#Code to Fetch page category data
#END
$publish = 1;
/* Get Current Date Time Stamp */
$currentTimestamp = getCurrentTimestamp();
if ($_SERVER['REQUEST_METHOD'] == 'POST') {
$error = '';
/*validate required fields*/
$obj->add_fields($content, 'req', 'Please Enter Content');
$error = $obj->validate();
if ($error) {
$errorMsg = "<font color='#FF0000' family='verdana' size=2>{$error}</font>";
} else {
/*save personalized search content*/
$dataArr = array('content' => $content);
$aboutus_insert = $obj_setting->update('content_page', $dataArr, "page_name = 'Personalized Search'");
$_SESSION['success_msg'] = 'Successfully Saved';
echo '<script>location.href="' . DEFAULT_URL . '/superadmin/personalized_search/index.php";</script>';
exit;
}
}
/*Fetch personalized search content*/
$fetchSetting = $obj_setting->read('content_page', "page_name = 'Personalized Search'");
$getSetting = $db->fetchNextObject($fetchSetting);
$content = $getSetting->content;
<?php
extract($_POST);
extract($_GET);
$obj_setting = new common();
$common_function = new commonFunction();
/*Fetch tab content*/
if ($slug != '') {
$fetchSetting = $obj_setting->read('news_articles', "slug = '{$slug}'");
$getSetting = $db->fetchNextObject($fetchSetting);
$articleId = $getSetting->id;
}
/*Fetch categories*/
$total_rows = $obj_setting->numberOfRows('news_category');
//number of rows in pages table
$allCategories = $obj_setting->customQuery("SELECT * FROM news_category WHERE EXISTS (SELECT * FROM news_articles\n WHERE news_category.id = news_articles.category_id)");
/*Fetch articles*/
if ($articleId != '') {
$total_articles = $obj_setting->numberOfRows('news_articles', "id='" . $articleId . "'");
$allArticles = $obj_setting->customQuery("SELECT category.category_name,category.id,category.slug as cateslug,articles.title,articles.content,articles.slug FROM news_articles as articles LEFT JOIN news_category as category ON articles.category_id=category.id where articles.id='" . $articleId . "'");
} else {
$total_articles = $obj_setting->numberOfRows('news_articles');
$allArticles = $obj_setting->customQuery("SELECT category.category_name,category.id,articles.title,articles.content,articles.slug FROM news_articles as articles LEFT JOIN news_category as category ON articles.category_id=category.id order by title ASC");
}
$fetchSetting = $obj_setting->read('content_page', 'id = 7');
$getSetting = $db->fetchNextObject($fetchSetting);
$sideBanner = $getSetting->content;
<?php
extract($_POST);
extract($_GET);
$common = new common();
/*Fetch personalized search content*/
$fetchSetting = $common->read('content_page', "page_name = 'Personalized Search'");
$getSetting = $db->fetchNextObject($fetchSetting);
$content = $getSetting->content;
/*Fetch car brand names*/
$modelList = array();
$manf = $common->CustomQuery("SELECT * FROM `attribute_option_value` WHERE `attribute_id` = '2' ORDER BY `value`, `sort_order` ASC");
while ($row = mysql_fetch_assoc($manf)) {
$modelList[] = $row;
}
ini_set('display_errors', true);
ini_set('error_reporting', E_ALL);
/*Recherche personnalisee Inquiry*/
if ($_SERVER['REQUEST_METHOD'] == 'POST') {
require_once 'lib/iContactApi.php';
// code for lead save on iContact
iContactApi::getInstance()->setConfig(array('appId' => ICONTACT_APPID, 'apiPassword' => ICONTACT_APIPASSWORD, 'apiUsername' => ICONTACT_APIUSERNAME));
// Store the singleton
$oiContact = iContactApi::getInstance();
try {
//Create a contact
//Create a contact
$listName = "RecherchePersonaliseeEnquiry({$marque})";
$getLists = $oiContact->getLists();
$found = 0;
foreach ($getLists as $aList) {
$obj->add_fields($content, 'req', 'Please Enter Content');
$error = $obj->validate();
if ($error) {
$errorMsg = "<font color='#FF0000' family='verdana' size=2>" . $error . "</font>";
} else {
/*save category*/
$slug = str_replace(' ', '_', strtolower($title));
$dataArr = array('category_id' => $category_id, 'title' => $title, 'content' => $content, 'slug' => $slug);
if ($id == "") {
$categoryInsert = $obj_setting->save('news_articles', $dataArr);
} else {
$categoryInsert = $obj_setting->update('news_articles', $dataArr, "id=" . $id);
}
$_SESSION['success_msg'] = 'Successfully Saved';
echo '<script>location.href="' . DEFAULT_URL . '/superadmin/page/articles.php";</script>';
exit;
}
}
/*Fetch banner section content*/
if (isset($_GET['id'])) {
$fetchSetting = $obj_setting->read('news_articles', 'id = ' . $_GET['id']);
$getSetting = $db->fetchNextObject($fetchSetting);
$id = $getSetting->id;
$categoryId = $getSetting->category_id;
$title = $getSetting->title;
$content = $getSetting->content;
$heading = "Edit";
} else {
$heading = "Add New";
}
$allCategories = $obj_setting->customQuery("SELECT id,category_name FROM news_category order by category_name ASC");
$result = "Please fill all the required fields.";
}
unset($objLogin);
} else {
if (isset($forgot_submit)) {
$objValidation = new validation();
$objValidation->add_fields($email, 'req', 'Please Enter Email Address');
$error = $objValidation->validate();
if ($error) {
$errorForgot = $error;
$flag = 1;
unset($objValidation);
} else {
$objLogin = new LoginSystem();
$objCommon = new common();
$result_forgot = $objCommon->read(TBL_ADMIN, "email='" . $objLogin->clean($email) . "'");
$row_forgot = $db->fetchNextObject($result_forgot);
//pr($row_forgot);exit;
if ($row_forgot->email == $email && isset($row_forgot->email)) {
$message = '
<p>Your Login Details are as follows :</p>
<table width="75%" border="0" cellpadding="2" cellspacing="0">
<tr>
<td>Username:</td>
<td>' . $row_forgot->username . '</td>
</tr>
<tr>
<td>Password:</td>
<td>' . $row_forgot->password . '</td>
</tr>
</table>';
<?php
/*************************************************************************************************************
#Coder : Kapil Verma
#Description : This Code is used to Manage Pages
*************************************************************************************************************/
extract($_GET);
$obj_setting = new common();
$obj = new validation();
$currentTimestamp = getCurrentTimestamp();
#Code to Fetch seleted ID's data
$fetchSetting = $obj_setting->read('template', ' id = 1');
$getSetting = $db->fetchNextObject($fetchSetting);
$email = $getSetting->email;
$subject = $getSetting->subject;
$template = $getSetting->template;
$next_date = $getSetting->next_date;
extract($_POST);
/* Get Current Date Time Stamp */
$currentTimestamp = getCurrentTimestamp();
#saving data in database after validation
if ($_SERVER['REQUEST_METHOD'] == 'POST') {
$error = '';
$obj->add_fields($email, 'req', 'Please Enter Email');
$obj->add_fields($email, 'email', 'Please Enter A Valid Email');
$obj->add_fields($subject, 'req', 'Please Enter Subject');
$obj->add_fields($template, 'req', 'Please Enter Template');
$error = $obj->validate();
if ($error) {
$errorMsg = "<font color='#FF0000' family='verdana' size=2>" . $error . "</font>";
} else {
<?php
/*************************************************************************************************************
#Coder : Kapil Verma
#Description : This Code is used to Manage Pages
*************************************************************************************************************/
extract($_GET);
$obj_setting = new common();
$obj = new validation();
#Code to Fetch seleted ID's data
$fetchSetting = $obj_setting->read(TBL_PAGE, 'id = ' . $id);
$getSetting = $db->fetchNextObject($fetchSetting);
$id = $getSetting->id;
$name = $getSetting->name;
$nameToShow = $getSetting->name;
$publish = 1;
//$publish = $getSetting->publish;
$desc = $getSetting->desc;
$slug = $getSetting->slug;
$metatitle = $getSetting->metatitle;
$metakeyword = $getSetting->metakeyword;
$metadescription = $getSetting->metadescription;
$can_delete = $getSetting->can_delete;
$page_catval = $getSetting->page_cat;
extract($_POST);
/* Get Current Date Time Stamp */
$currentTimestamp = getCurrentTimestamp();
#saving data in database after validation
if ($_SERVER['REQUEST_METHOD'] == 'POST') {
$error = '';
$obj->add_fields($name, 'req', 'Please Enter Page Title');
<?php
/*************************************************************************************************************
#Coder : Kapil Verma
#Description : This Code is used to Manage Pages
*************************************************************************************************************/
extract($_GET);
$obj_setting = new common();
$obj = new validation();
#Code to Fetch seleted ID's data
$fetchSetting = $obj_setting->read('email_log', 'id = ' . $id);
$getSetting = $db->fetchNextObject($fetchSetting);
$id = $getSetting->id;
$email = $getSetting->email;
$status = $getSetting->status;
$sent = $getSetting->sent_date;
$next = $getSetting->next_date;
$content = $getSetting->content;
unset($obj_setting);
unset($obj);
move_uploaded_file($_FILES['logo']['tmp_name'], LIST_ROOT_ADMIN . "/members/upload/" . $logo);
unlink(LIST_ROOT_ADMIN . "/members/upload/" . $logo_hidden);
} else {
$logo = $logo_hidden;
}
$p_slug = $obj_handle->makeAlias($name);
if ($obj_product->numberOfRows(TBL_PRODUCT, "p_slug = '" . $p_slug . "'") > 0) {
$p_slug = $obj_handle->makeAlias($p_slug . " " . $prod_id);
}
$dataArr = array('name' => $name, 'logo' => $logo, 'desc' => $desc, 'cat_id' => $cat_id, 'sub_cat_id' => $sub_cat_id, 'publish' => $publish, 'p_slug' => $p_slug);
$update_product = $obj_product->update(TBL_PRODUCT, $dataArr, 'id=' . $prod_id);
$_SESSION['msg'] = RECORD_UPDATE;
redirectUrl(DEFAULT_ADMIN_URL . '/members/product.php');
exit;
}
} else {
#Code to Fetch seleted ID's data
$getProduct = $obj_product->read(TBL_PRODUCT, 'id=' . $prod_id);
$fetchProduct = $db->fetchNextObject($getProduct);
$name = $fetchProduct->name;
$logo = $fetchProduct->logo;
$desc = $fetchProduct->desc;
$cat_id = $fetchProduct->cat_id;
$sub_cat_id = $fetchProduct->sub_cat_id;
$publish = $fetchProduct->publish;
$old_p_slug = $fetchProduct->p_slug;
}
$all_category = $obj_product->read(TBL_CATEGORY, 'publish=1');
if ($sub_cat_id != '' && $sub_cat_id != 0) {
$get_sub_cat = $obj_product->read(TBL_SUBCATEGORY, 'cid=' . $cat_id . ' AND publish=1');
}
$obj = new validation();
if ($_SERVER['REQUEST_METHOD'] == 'POST') {
$error = '';
/*validate required fields*/
$obj->add_fields($content, 'req', 'Please Enter Content');
$obj->add_fields($_FILES['topbanner'], 'ftype=jpg,gif,png', 'Please Upload Valid Banner');
$obj->add_fields($_FILES['topbanner'], "imgwh=1250,300", "Please Upload Valid Banner(1250pxX00px)");
$error = $obj->validate();
if ($error) {
$errorMsg = "<font color='#FF0000' family='verdana' size=2>{$error}</font>";
} else {
/*save media content*/
if ($_FILES['topbanner']['name'] != "") {
$image_name = time() . $_FILES['topbanner']['name'];
$path = LIST_ROOT . '/images/pages/media/';
move_uploaded_file($_FILES["topbanner"]["tmp_name"], $path . $image_name);
} else {
$image_name = $oldtopimage;
}
$dataArr = array('page_name' => 'media', 'content' => $content, 'banner_image' => $image_name);
$aboutus_insert = $obj_setting->update('content_page', $dataArr, "id=16");
$_SESSION['success_msg'] = 'Successfully Saved';
echo '<script>location.href="' . DEFAULT_URL . '/superadmin/page/mediacontent.php";</script>';
exit;
}
}
/*Fetch media content*/
$fetchSetting = $obj_setting->read('content_page', 'id = 16');
$getSetting = $db->fetchNextObject($fetchSetting);
$content = $getSetting->content;
$topBanner = $getSetting->banner_image;
$obj->add_fields($category_name, 'uniquevalue', 'Please Enter Unique Category Name', array('news_category', "category_name='" . mysql_real_escape_string($category_name) . "'"));
} else {
$obj->add_fields($category_name, 'uniquevalue', 'Please Enter Unique Category Name', array('news_category', "category_name='" . mysql_real_escape_string($category_name) . "' and id!=" . $id));
}
$error = $obj->validate();
if ($error) {
$errorMsg = "<font color='#FF0000' family='verdana' size=2>" . $error . "</font>";
} else {
/*save category*/
$slug = $commonFunction->url_slug(strtolower($category_name));
$dataArr = array('category_name' => htmlentities($category_name), 'slug' => $slug);
if ($id == "") {
$categoryInsert = $obj_setting->save('news_category', $dataArr);
} else {
$categoryInsert = $obj_setting->update('news_category', $dataArr, "id=" . $id);
}
$_SESSION['success_msg'] = 'Successfully Saved';
echo '<script>location.href="' . DEFAULT_URL . '/superadmin/page/news_category.php";</script>';
exit;
}
}
/*Fetch banner section content*/
if (isset($_GET['id'])) {
$fetchSetting = $obj_setting->read('news_category', 'id = ' . $_GET['id']);
$getSetting = $db->fetchNextObject($fetchSetting);
$id = $getSetting->id;
$catgoryName = $getSetting->category_name;
$heading = "Edit";
} else {
$heading = "Add New";
}
$successstatus = 1;
}
$dataArr = array('site_title' => $site_title, 'meta_title' => $meta_title, 'meta_keywords' => $meta_keywords, 'meta_description' => $meta_description, 'google_map_key' => $google_map_key, 'phone1' => $phone1, 'phone2' => $phone2, 'office_address' => $office_address, 'slogan' => $slogan, 'logo' => $imageName, 'copyright_text_footer' => $copyright_text_footer, 'facebook' => $facebook, 'twitter' => $twitter, 'youtube' => $youtube, 'rss' => $rss);
$update_site = $obj_setting->update(TBL_ADMIN, $dataArr, 'id = ' . $_SESSION['LoggedInId']);
if ($successstatus == 0) {
$_SESSION['success_msg'] = 'Image size is greater then 200kb ,so this image could not be saved.Your other information has been saved successfully.';
} else {
if ($successstatus == 2) {
$_SESSION['success_msg'] = 'Image type is not JPEG or GIF ,so this image could not be saved.Your other information has been saved successfully.';
} else {
$_SESSION['success_msg'] = 'Your information has been saved successfully.';
}
}
}
#Code to Fetch data to show on form
$fetchSetting = $obj_setting->read(TBL_ADMIN, 'id = ' . $_SESSION['LoggedInId']);
$getSetting = $db->fetchNextObject($fetchSetting);
$site_title = $getSetting->site_title;
$meta_title = $getSetting->meta_title;
$meta_keywords = $getSetting->meta_keywords;
$meta_description = $getSetting->meta_description;
$google_map_key = $getSetting->google_map_key;
$phone1 = $getSetting->phone1;
$phone2 = $getSetting->phone2;
$office_address = $getSetting->office_address;
$slogan = $getSetting->slogan;
$logo_header = $getSetting->logo;
$copyright_text_footer = $getSetting->copyright_text_footer;
$facebook = $getSetting->facebook;
$twitter = $getSetting->twitter;
$youtube = $getSetting->youtube;
}
}
if (isset($price) && $price[0] != "" && $price[1] != "") {
if ($first) {
$whereCondition .= 'price between ' . $price[0] . ' and ' . $price[1];
$first = false;
} else {
$whereCondition .= ' and price between ' . $price[0] . ' and ' . $price[1];
}
}
if (isset($page)) {
$carPages->current_page = $page;
}
}
$invOrderBy = explode('~', $invSort);
$carPages->default_ipp = $invPageLimit;
$carPages->pageUrl = 'products.php';
if (!isset($search)) {
$carPages->pageUrl = 'notre_inventaire';
}
$eu = $invPageLimit * ($invCurPage - 1);
$inventoryTotalRows = $common->numberOfRows('car_flat', $whereCondition);
//number of rows in pages table
$addCarToQuery = '';
$carPages->items_total = $inventoryTotalRows;
$carPages->paginate();
$all_cars = $common->read('car_flat', $whereCondition, $invOrderBy[0] . " " . $invOrderBy[1] . " LIMIT 0, " . $invPageLimit);
$all_car = array();
while ($row = mysql_fetch_array($all_cars)) {
$all_car[] = $row;
}
if ($_FILES['file']['name'] != "") {
$image_name = time() . $_FILES['file']['name'];
$path = LIST_ROOT . '/images/logistique/';
move_uploaded_file($_FILES["file"]["tmp_name"], $path . $image_name);
} else {
$image_name = $oldimage;
}
$slug = str_replace(' ', '_', strtolower($tabtitle));
$dataArr = array('tab_title' => htmlentities($tabtitle), 'banner_image' => $image_name, 'content' => $content, 'page_name' => 'Logistique', 'slug' => $slug);
if ($id == "") {
$banner_insert = $obj_setting->save('content_page', $dataArr);
} else {
$banner_insert = $obj_setting->update('content_page', $dataArr, "id=" . $id);
}
$_SESSION['success_msg'] = 'Successfully Saved';
echo '<script>location.href="' . DEFAULT_URL . '/superadmin/logistique/index.php";</script>';
exit;
}
}
/*Fetch banner section content*/
if (isset($_GET['id'])) {
$fetchSetting = $obj_setting->read('content_page', 'id = ' . $_GET['id']);
$getSetting = $db->fetchNextObject($fetchSetting);
$id = $getSetting->id;
$tabTitle = $getSetting->tab_title;
$bannerImage = $getSetting->banner_image;
$content = $getSetting->content;
$heading = "Edit";
} else {
$heading = "Add New";
}
function buildViewElements($postArr = array(), $fileArr = array())
{
global $db;
$attribute_list = $this->read($this->attr_table, $whereCondition = '', $orderBy = 'tab, sort, attribute_id ASC', $groupBy = '');
$tab = 0;
$flag = false;
if (count($postArr) > 0) {
$flag = true;
}
$step = 0;
while ($getAttrRow = $db->fetchNextObject($attribute_list)) {
if ($getAttrRow->tab != $tab) {
$tab = $getAttrRow->tab;
switch ($getAttrRow->tab) {
case 1:
echo '<div id="general_tab"><table border="0" cellpadding="0" cellspacing="0" width="100%"><tbody>';
break;
case 2:
echo $this->getStock_Vin($postArr) . '</tbody></table></div><div id="images_tab" class="tab_zero_height"><h1>' . $getAttrRow->frontend_label . '</h1><table border="0" cellpadding="0" cellspacing="0" width="100%"><tbody>';
break;
case 3:
echo '</tbody></table></div><div id="info_p1_tab" class="tab_zero_height"><table border="0" cellpadding="0" cellspacing="0" width="100%"><tbody>';
break;
case 4:
echo '</tbody></table></div><div id="info_p2_tab" class="tab_zero_height"><table height="" border="0" cellpadding="0" cellspacing="0" width="100%"><tbody>';
break;
case 5:
echo '</tbody></table></div><div id="dealer_tab" class="tab_zero_height"><table border="0" cellpadding="0" cellspacing="0" width="100%"><tbody>';
break;
}
}
if ($step == 0 && $getAttrRow->tab == 1 && !empty($_REQUEST['type']) && $_REQUEST['type'] == 'nostock') {
$obj_block = new common();
$obj_handle = new Handle();
echo '<tr>
<th valign="top">Brand:</th>
<td>';
if ($flag) {
if (!empty($postArr['brand_id'])) {
$getbrandBlock = $obj_block->read(TBL_BRANDS, " publish=1 AND id = " . $postArr['brand_id']);
$brand = mysql_fetch_array($getbrandBlock);
echo !empty($brand['title']) ? $brand['title'] : 'None';
}
} else {
$getbrandBlock = $obj_block->read(TBL_BRANDS, " publish=1");
echo '<select name="brand_id" class="select-form required">
<option value="">Select Brand</option>';
while ($brands = mysql_fetch_object($getbrandBlock)) {
echo '<option value="' . $brands->id . '">' . $brands->title . '</option>';
}
echo '</select>';
}
echo '</td>
<td></td>
<td> </td>
</tr>';
}
$step++;
$req_text = ' ';
switch ($getAttrRow->frontend_type) {
case "text":
if ($flag) {
$getAttrRow->default_value = $postArr[$getAttrRow->attribute_code];
}
if (is_numeric($getAttrRow->default_value)) {
$getAttrRow->default_value = number_format($getAttrRow->default_value);
}
echo ' <tr>
<th valign="top">' . $getAttrRow->frontend_label . ':</th>
<td><span>' . $getAttrRow->default_value . '</span></td>
<td>' . $req_text . '</td>
</tr>';
break;
case "textarea":
if ($flag) {
$getAttrRow->default_value = $postArr[$getAttrRow->attribute_code];
}
if ($getAttrRow->attribute_code == 'features' || $getAttrRow->attribute_code == 'std_equip') {
$getAttrRow->default_value = $this->getList($getAttrRow->default_value);
}
echo ' <tr>
<th valign="top">' . $getAttrRow->frontend_label . ':</th>
<td><p>' . $getAttrRow->default_value . '</p></td>
<td>' . $req_text . '</td>
</tr>';
break;
case "select":
if ($flag) {
$default_value = $postArr[$getAttrRow->attribute_code];
}
echo ' <tr>
<th valign="top">' . $getAttrRow->frontend_label . ':</th>
<td><span>' . $default_value . '</span></td>
<td>' . $req_text . '</td>
</tr>';
break;
case "checkbox":
if ($flag) {
$default_value = $postArr[$getAttrRow->attribute_code];
}
echo ' <tr>
<th valign="top">' . $getAttrRow->frontend_label . ':</th>
<td>' . $default_value . '</td>
<td>' . $req_text . '</td>
</tr>';
break;
case "radio":
if ($flag) {
$default_value = $postArr[$getAttrRow->attribute_code];
}
echo ' <tr>
<th valign="top">' . $getAttrRow->frontend_label . ':</th>
<td>' . $default_value . '</td>
<td>' . $req_text . '</td>
</tr>';
break;
case "media_upload":
$return = '<tr><td><img src="' . $this->getImageUrl($fileArr["images_1"]) . '"></td><td><img src="' . $this->getImageUrl($fileArr["images_2"]) . '"></td><td>' . $req_text . '</td></tr>';
echo $return;
break;
}
}
echo '</tbody></table></div>';
}
$news_footer_above_block_contents = $dynamic_editor_text->footer_above_text;
$news_footer_block_contents = $dynamic_editor_text->footer_text;
$full_data .= '<tr>
<td align="center" height="262" valign="top"><a href="http://www.sylc-export.com/" target="_blank"><img style="border:none; display:block" src="' . DEFAULT_ADMIN_URL . '/images/banner/' . $news_banner_image . '" border="0" width="800" height="262" alt="Banner" /></a></td>
</tr>';
$full_data .= '<tr>
<td align="left" vvalign="top"><table width="100%" border="0" align="left" bgcolor="#ffffff" cellpadding="0" cellspacing="0">
<tr>
<td valign="top" height="13" width="100%" colspan="3"> </td>
</tr>
<tr>
<td valign="top" width="13"> </td>
<td valign="top" width="768"><table width="768" border="0" align="left" cellpadding="0" cellspacing="0">
';
$nw_counter = 1;
$all_new_models = $common_object->read(TBL_NEW_MODEL, "publish=1", '');
while ($new_models = mysql_fetch_object($all_new_models)) {
if ($nw_counter == 1 || $nw_counter % 2 == 1) {
$full_data .= '<tr>';
}
$full_data .= '<td valign="top" width="365"><table width="365" border="0" align="left" cellpadding="0" cellspacing="0">
<tr>
<td colspan="2" valign="top" align="center" style="padding:8px; border:1px solid #a8a8a8;"><table width="345" border="0" align="left" cellpadding="0" cellspacing="0">
<tr>
<td valign="middle" align="center"><img src="' . DEFAULT_ADMIN_URL . '/images/new_model/' . $new_models->image . '" style="border:1px solid #a8a8a8" width="345" height="238" /></td>
</tr>
</table></td>
</tr>
<tr>
<td valign="bottom" width="242" style="padding-top:10px; font-size:16px; font-weight:bold; font-family:Arial, Helvetica, sans-serif;">' . $new_models->brand_name . ' ' . $new_models->year . '</td>
<td valign="bottom" width="120" align="right" style="padding-top:10px; font-size:16px; font-weight:bold; font-family:Arial, Helvetica, sans-serif;">' . $new_models->prix . '</td>
}
if (isset($_GET['media']) && $_GET['media'] == 'photo') {
$pagesnum = 1;
$pagesPhotonum = $_GET['page'];
}
if (isset($_GET['media']) && $_GET['media'] == 'video') {
$pagesPhotonum = 1;
$pagesnum = $_GET['page'];
}
$pagesPhoto = new Paginator();
$pagesPhoto->default_ipp = 8;
$total_rows = $common->numberOfRows('media', "type='1'");
$pagesPhoto->items_total = $total_rows;
$pagesPhoto->extraParam = 'photo';
$pagesPhoto->paginate();
$limit = 8;
$eu = $limit * ($pagesPhotonum - 1);
$allMedia = $common->customQuery("SELECT * FROM media where type = '1' ORDER BY id ASC limit {$eu}, {$limit}");
$pages = new Paginator();
$pages->default_ipp = 8;
$totalVideos = $common->numberOfRows('media', "type='0'");
$pages->items_total = $totalVideos;
$pages->extraParam = 'video';
$pages->paginate();
$limit = 8;
$eu = $limit * ($pagesnum - 1);
$allVideo = $common->customQuery("SELECT * FROM media where type = '0' ORDER BY id ASC limit {$eu}, {$limit}");
$fetchSetting = $common->read('content_page', 'id = 16');
$getSetting = $db->fetchNextObject($fetchSetting);
$bannerImage = $getSetting->banner_image;
$content = $getSetting->content;
</tr>';
//banner
$full_data .= '<tr>
<td style="padding-bottom:9px;">
<table cellpadding="0" cellspacing="0" style="background: #555555; width:600px;" width="600">
<tr>
<td width="300" style="width:300px; text-align:left; color:#fff; font-size:18px; padding-top:5px; padding-bottom:5px; padding-left:5px">
Les affaires du moment</td>
<td width="300" style="width:300px; text-align:right; color:#fff; font-size:14px; padding-top:5px; padding-bottom:5px; padding-right:5px;">
<a href="http://www.sylc-export.com/inventaire/" style="color:#fff;">VIEW ALL</a></td>
</tr>
</table>
</td>
</tr>';
$i = 1;
$all_new_models = $common_object->read(TBL__HTMLTEMPLATE, "publish=1", '');
while ($new_models = mysql_fetch_object($all_new_models)) {
if ($i == 1 || $i % 3 == 1) {
$full_data .= '<tr><td>
<table cellpadding="0" cellspacing="0" style="width:600px;" width="600">
<tr>';
}
$full_data .= '<td style="padding-bottom:9px;">
<table cellpadding="2" cellspacing="2" style="width:190px; border:1px #e2e2e2 solid" width="190">
<tr>
<td>
<img src="' . DEFAULT_ADMIN_URL . '/images/htmltemplate/' . $new_models->image . '" alt=" " style="display:block; border:0;width:188px;max-height:128px;" height="128" width="188">
</td>
</tr>
<tr>
<td style="font-family:Arial; font-size:18px; text-align:center; color:#000; height:40px;" headers="40">';
<?php
extract($_POST);
extract($_GET);
$search = new search();
$common = new common();
/*Fetch tabs*/
$total_rows = $common->numberOfRows('content_page', "page_name='Logistique'");
$allTabs = $common->customQuery("SELECT slug,tab_title FROM content_page where page_name='Logistique' ORDER BY id ASC");
if ($slug == '') {
$slug = 'notre_mission';
}
/*Fetch banner section content*/
$fetchSetting = $common->read('content_page', "slug = '" . mysql_real_escape_string($slug) . "'");
$getSetting = $db->fetchNextObject($fetchSetting);
if (empty($getSetting)) {
echo '<script>location.href = "/logistic";</script>';
}
$title = $getSetting->tab_title;
$content = $getSetting->content;
$bannerImage = $getSetting->banner_image;
/*Recherche Transport Inquiry*/
if ($_SERVER['REQUEST_METHOD'] == 'POST' && isset($_POST['logisticform'])) {
require_once 'lib/iContactApi.php';
// code for lead save on iContact
iContactApi::getInstance()->setConfig(array('appId' => ICONTACT_APPID, 'apiPassword' => ICONTACT_APIPASSWORD, 'apiUsername' => ICONTACT_APIUSERNAME));
// Store the singleton
$oiContact = iContactApi::getInstance();
try {
//Create a contact
$cid = $oiContact->CustomaddContactForm($email, 'normal', '', null, $phone, $comment, $fname, $type_transport);
