?>
<?php
_e($ptitle, 'templatic');
?>
</div>
</div>
<?php
}
?>
<div class="<?php
templ_content_css();
?>
" >
<?php
templ_page_title_above();
//page title above action hook
?>
<script type="text/javascript" src="<?php
bloginfo('template_directory');
?>
/js/timer.js"></script>
<!-- CONTENT AREA START -->
<div class="content-title">
<?php
echo templ_page_title_filter($ptitle);
//page tilte filter
?>
</div>
function widget($args, $instance)
{
// prints the widget
extract($args, EXTR_SKIP);
$title = empty($instance['title']) ? ' ' : apply_filters('widget_title', $instance['title']);
$category = empty($instance['category']) ? '' : apply_filters('widget_category', $instance['category']);
$post_number = empty($instance['post_number']) ? '5' : apply_filters('widget_post_number', $instance['post_number']);
$user_db_table_name = get_user_table();
$status_deal = empty($instance['status_deal']) ? '' : apply_filters('widget_status_deal', $instance['status_deal']);
?>
<h3 class="deal_widget_title"><?php
_e($title, 'templatic');
?>
<small> ( <a href="<?php
echo site_url();
?>
/?ptype=taxonomy_all_deal_tab" class="b_viewalldeal"><?php
_e(VIEW_ALL_DEAL, 'templatic');
?>
</a> ) </small> </h3>
<span class="flip_postion"></span>
<div class="deals_widget">
<!-- BOF Loop -->
<?php
templ_page_title_above();
//page title above action hook
?>
<?php
$destination_path = site_url() . '/wp-content/uploads/';
?>
<script type="text/javascript" src="<?php
bloginfo('template_directory');
?>
/js/timer.js"></script>
<?php
global $wp_query, $post, $wpdb;
$current_term = $wp_query->get_queried_object();
if ($current_term->name) {
$ptitle = $current_term->name;
}
?>
<div id="loop" class="<?php
if (get_option('ptttheme_view_opt') == 'Grid View') {
echo 'grid';
} else {
echo 'list clear';
}
?>
">
<!-- BOF All Deal -->
<?php
global $wpdb, $transection_db_table_name;
$targetpage = site_url("?ptype=deals");
$postmeta_db_table_name = $wpdb->prefix . "postmeta";
$post_db_table_name = $wpdb->prefix . "posts";
$total_deals = mysql_query("select p.* from {$post_db_table_name} p where p.post_type = 'seller' and p.post_status = 'publish' ");
$total_pages = mysql_num_rows($total_deals);
$recordsperpage = $post_number;
$pagination = $_REQUEST['pagination'];
if ($pagination == '') {
$pagination = 1;
}
$strtlimit = ($pagination - 1) * $recordsperpage;
$endlimit = $strtlimit + $recordsperpage;
if ($category) {
$category = "'" . str_replace(",", "','", $category) . "'";
$sqlsql = " and p.ID in (select tr.object_id from {$wpdb->term_relationships} tr join {$wpdb->term_taxonomy} t on t.term_taxonomy_id=tr.term_taxonomy_id where t.term_id in ({$category}) )";
}
$dealcnt_sql = $wpdb->get_results("select p.* from {$post_db_table_name} p where p.post_type = 'seller' and p.post_status = 'publish' {$sqlsql} ORDER BY ID DESC limit {$strtlimit},{$recordsperpage} ");
if (count($dealcnt_sql) > 0) {
$pcount = 0;
foreach ($dealcnt_sql as $post) {
if ($status_deal == 'all') {
$expired = get_post_meta($post->ID, 'is_expired', true) == '1' || get_post_meta($post->ID, 'is_expired', true) == '0';
} else {
$expired = get_post_meta($post->ID, 'is_expired', true) == '0';
}
if ($status_deal == 'all') {
$pcount++;
if (get_post_meta($post->ID, 'enddate', true) != '0') {
deal_expire_process($post->ID);
}
$coupon_website = get_post_meta($post->ID, 'coupon_website', true);
$owner_name = get_post_meta($post->ID, 'owner_name', true);
$our_price = get_post_meta($post->ID, 'our_price', true);
$current_price = get_post_meta($post->ID, 'current_price', true);
$sellsql = "select count(*) from {$transection_db_table_name} where post_id=" . $post->ID . " and status=1";
$totdiff = $current_price - $our_price;
$percent = $totdiff * 100;
$percentsave = $percent / $current_price;
$sellsqlinfo = $wpdb->get_var($sellsql);
if (get_post_meta($post->ID, 'enddate', true) != '0') {
if (get_post_meta($post->ID, 'coupon_end_date_time', true) != "") {
$date = get_post_meta($post->ID, 'coupon_end_date_time', true);
$tardate = date("F d, Y H:i:s", get_post_meta($post->ID, 'coupon_end_date_time', true));
$targatedate = date("d-m-y H:i:s", get_post_meta($post->ID, 'coupon_end_date_time', true));
$tardate1 = date("F d, Y", get_post_meta($post->ID, 'coupon_end_date_time', true));
$enddate1 = date("Y-m-d H:i:s", get_post_meta($post->ID, 'coupon_end_date_time', true));
if (date("Y-m-d H:i:s") >= $enddate1 && get_post_meta($post->ID, 'enddate', true) != '0') {
if (get_post_meta($post->ID, 'is_expired', true) == '0' || get_post_meta($post->ID, 'is_expired', true) == '') {
update_post_meta($post->ID, 'is_expired', '1');
}
}
} else {
if (get_post_meta($post->ID, 'enddate', true) != '0' && get_post_meta($post->ID, 'no_of_coupon', true) == $sellsqlinfo) {
if (get_post_meta($post->ID, 'is_expired', true) == '0' || get_post_meta($post->ID, 'is_expired', true) == '') {
update_post_meta($post->ID, 'is_expired', '1');
}
}
}
}
$stdate = date("F d, Y H:i:s", get_post_meta($post->ID, 'coupon_start_date_time', true));
$no_of_coupon = get_post_meta($post->ID, 'no_of_coupon', true);
?>
<div <?php
post_class('post posts_deals');
?>
id="post_<?php
the_ID();
?>
" >
<div class="product_image "> <a href="<?php
the_permalink();
?>
">
<?php
if (get_post_meta($post->ID, 'file_name', true) != "") {
?>
<img src="<?php
echo templ_thumbimage_filter(get_post_meta($post->ID, 'file_name', true), 260, 180);
?>
" alt="" />
<?php
} else {
?>
<img src="<?php
echo get_template_directory_uri() . "/images/no-image.png";
?>
" width="260" height="180" alt="" />
<?php
}
?>
</a></div>
<div class="product_image grid_img"> <a href="<?php
the_permalink();
?>
">
<?php
if (get_post_meta($post->ID, 'file_name', true) != "") {
?>
<img src="<?php
echo templ_thumbimage_filter(get_post_meta($post->ID, 'file_name', true), 280, 180);
?>
" alt="" />
<?php
} else {
?>
<div class="noimg"><?php
_e('Image <br />not available', 'templatic');
?>
</div>
<?php
}
?>
</a> </div>
<div class="content_right content_right_inner"><span class="title_grey"><?php
_e(PROVIDE_BY, 'templatic');
?>
</span>
<?php
$user_db_table_name = get_user_table();
$user_data = $wpdb->get_row("select * from {$user_db_table_name} where ID = '" . $post->post_author . "'");
?>
<a href="<?php
echo get_author_posts_url($post->post_author);
?>
" class="top_lnk" title="<?php
echo $user_data->display_name;
?>
"><?php
echo get_post_meta($post->ID, 'owner_name', true);
?>
</a>
<h3><a href="<?php
the_permalink();
?>
"><?php
echo $post->post_title;
?>
</a></h3>
<div class="grid_price"><span class="strike_rate"><?php
_e('Our Price :', 'templatic');
?>
<s><?php
echo get_currency_sym();
echo $current_price;
?>
</s></span> <span class="rate"><?php
_e('Offer Price :', 'templatic');
?>
<?php
echo get_currency_sym();
echo $our_price;
?>
</span> </div>
<?php
if (date("Y-m-d H:i:s") >= $enddate1 || strtotime($stdate) >= strtotime($tardate) || get_post_meta($post->ID, 'no_of_coupon', true) == $sellsqlinfo) {
if (get_post_meta($post->ID, 'is_expired', true) == '1') {
?>
<div class="i_expire"><?php
echo THIS_DEAL;
?>
<span><?php
echo EXPIRED;
?>
</span> <?php
echo ON;
?>
<span><?php
echo $tardate1;
?>
</span></div>
<?php
}
if (get_post_meta($post->ID, 'no_of_coupon', true) == $sellsqlinfo && get_post_meta($post->ID, 'is_expired', true) != '1') {
?>
<div class="i_start"><span><?php
echo "Is Sold Out";
?>
</span></div>
<?php
}
} else {
if (get_post_meta($post->ID, 'coupon_end_date_time', true)) {
?>
<div class="deal_time_box">
<div class="time_line"> </div>
<div id="countdowncontainer_<?php
_e($post->ID, 'templatic');
?>
"></div>
<div class="fr" id="fr_<?php
echo $post->ID;
?>
">
<div class="price_main"> <span class="strike_rate"><?php
echo get_currency_sym();
echo $current_price;
?>
</span> <span class="rate"><?php
echo get_currency_sym();
echo $our_price;
?>
</span> </div>
<?php
if (get_post_meta($post->ID, 'coupon_type', true) == 1) {
?>
<a href="<?php
echo get_post_meta($post->ID, 'coupon_link', true);
?>
" title="<?php
echo BUY_NOW;
?>
" class="btn_buy" target="_blank"><?php
echo BUY_NOW;
?>
</a>
<?php
} else {
?>
<a href="<?php
echo get_option('siteurl');
?>
/?ptype=buydeal&did=<?php
_e($post->ID, 'templatic');
?>
" title="<?php
echo BUY_NOW;
?>
" class="btn_buy"><?php
echo BUY_NOW;
?>
</a>
<?php
}
?>
</div>
<?php
$targatedate = explode(' ', $targatedate);
$tar_date = explode('-', $targatedate[0]);
$tar_time = explode(':', $targatedate[1]);
$timezone = get_option('ptthemes_time_offset');
$exp_year = explode(',', $tardate1);
?>
<script>
displayTZCountDown(setTZCountDown('<?php
echo $tar_date[1];
?>
','<?php
echo $tar_date[0];
?>
','<?php
echo $tar_time[0];
?>
','<?php
echo $timezone;
?>
','<?php
echo $exp_year[1];
?>
'),'countdowncontainer_<?php
_e($post->ID, 'templatic');
?>
','fr_<?php
echo $post->ID;
?>
','<?php
echo $tardate1;
?>
');
</script>
</div>
<?php
}
}
?>
<ul class="rate_summery">
<li class="rate_current_price"><span><?php
echo CURRENT_PRICE;
?>
</span> <strong><small><?php
echo get_currency_sym();
?>
</small><?php
echo $current_price;
?>
</strong></li>
<li class="rate_our_price"><span><?php
echo OUR_PRICE;
?>
</span> <strong><small><?php
echo get_currency_sym();
?>
</small><?php
echo $our_price;
?>
</strong></li>
<li class="rate_percentage"><span><?php
echo YOU_SAVE;
?>
</span> <strong><?php
echo @number_format($percentsave, 2);
?>
%</strong></li>
<li class="bdr_none rate_item_sold"><span><?php
echo ITEMS_SOLD;
?>
</span> <strong><?php
echo $sellsqlinfo;
?>
</strong>
</ul>
<?php
$post_categories = wp_get_post_terms($post->ID, 'seller_category');
if ($post_categories[1] != "") {
?>
<div class="post_cats clearfix">
<?php
the_taxonomies(array('before' => '<span class="categories">', 'sep' => '</span><span class="tags">', 'after' => '</span>'));
?>
</div>
<?php
}
if (get_post_meta($post->ID, 'enddate', true) == '0' && get_option('ptttheme_view_opt') != 'Grid View' && get_post_meta($post->ID, 'status', true) == '1') {
?>
<?php
if (get_post_meta($post->ID, 'coupon_type', true) == 1) {
?>
<a href="<?php
echo get_post_meta($post->ID, 'coupon_link', true);
?>
" title="<?php
echo BUY_NOW;
?>
" class="btn_buy_deal" target="_blank"><?php
echo BUY_NOW;
?>
</a>
<?php
} else {
?>
<a href="<?php
echo get_option('siteurl');
?>
/?ptype=buydeal&did=<?php
_e($post->ID, 'templatic');
?>
" title="<?php
echo BUY_NOW;
?>
" class="btn_buy_deal"><?php
echo BUY_NOW;
?>
</a>
<?php
}
}
if (get_post_meta($post->ID, 'is_expired', true) != 1 && get_option('ptttheme_view_opt') == 'Grid View') {
if (get_post_meta($post->ID, 'coupon_type', true) == 1) {
?>
<a href="<?php
echo get_post_meta($post->ID, 'coupon_link', true);
?>
" title="<?php
echo BUY_NOW;
?>
" class="btn_buy_grid"><?php
echo BUY_NOW;
?>
</a>
<?php
} else {
?>
<a href="<?php
echo get_option('siteurl');
?>
/?ptype=buydeal&did=<?php
_e($post->ID, 'templatic');
?>
" title="<?php
echo BUY_NOW;
?>
" class="btn_buy_grid"><?php
echo BUY_NOW;
?>
</a>
<?php
}
}
?>
<div class="text_content" id="content_<?php
_e($post->ID, 'templatic');
?>
"><?php
echo "" . $post->post_excerpt . "";
?>
<a href="<?php
the_permalink();
?>
" class="readmore_link"><?php
_e(get_option('ptthemes_content_excerpt_readmore'));
?>
</a></div>
</div>
</div>
<?php
$page_layout = templ_get_page_layout();
if ($pcount == 3) {
$pcount = 0;
?>
<div class="hr clear"></div>
<?php
}
} else {
if (get_post_meta($post->ID, 'is_expired', true) != 1) {
$pcount++;
if (get_post_meta($post->ID, 'enddate', true) != '0') {
deal_expire_process($post->ID);
}
$coupon_website = get_post_meta($post->ID, 'coupon_website', true);
$owner_name = get_post_meta($post->ID, 'owner_name', true);
$our_price = get_post_meta($post->ID, 'our_price', true);
$current_price = get_post_meta($post->ID, 'current_price', true);
$sellsql = "select count(*) from {$transection_db_table_name} where post_id=" . $post->ID . " and status=1";
$totdiff = $current_price - $our_price;
$percent = $totdiff * 100;
$recordsperpage = $post_number;
$percentsave = $percent / $current_price;
$sellsqlinfo = $wpdb->get_var($sellsql);
if (get_post_meta($post->ID, 'enddate', true) != '0') {
if (get_post_meta($post->ID, 'coupon_end_date_time', true) != "") {
$date = get_post_meta($post->ID, 'coupon_end_date_time', true);
$tardate = date("F d, Y H:i:s", get_post_meta($post->ID, 'coupon_end_date_time', true));
$targatedate = date("d-m-y H:i:s", get_post_meta($post->ID, 'coupon_end_date_time', true));
$tardate1 = date("F d, Y", get_post_meta($post->ID, 'coupon_end_date_time', true));
$enddate1 = date("Y-m-d H:i:s", get_post_meta($post->ID, 'coupon_end_date_time', true));
if (date("Y-m-d H:i:s") >= $enddate1 && get_post_meta($post->ID, 'enddate', true) != '0') {
if (get_post_meta($post->ID, 'is_expired', true) == '0' || get_post_meta($post->ID, 'is_expired', true) == '') {
update_post_meta($post->ID, 'is_expired', '1');
}
}
} else {
if (get_post_meta($post->ID, 'enddate', true) != '0' && get_post_meta($post->ID, 'no_of_coupon', true) == $sellsqlinfo) {
if (get_post_meta($post->ID, 'is_expired', true) == '0' || get_post_meta($post->ID, 'is_expired', true) == '') {
update_post_meta($post->ID, 'is_expired', '1');
}
}
}
}
$stdate = date("F d, Y H:i:s", get_post_meta($post->ID, 'coupon_start_date_time', true));
$no_of_coupon = get_post_meta($post->ID, 'no_of_coupon', true);
?>
<div <?php
post_class('post posts_deals');
?>
id="post_<?php
the_ID();
?>
" >
<div class="product_image "> <a href="<?php
the_permalink();
?>
">
<?php
if (get_post_meta($post->ID, 'file_name', true) != "") {
?>
<img src="<?php
echo templ_thumbimage_filter(get_post_meta($post->ID, 'file_name', true), 260, 180);
?>
" alt="" />
<?php
} else {
?>
<img src="<?php
echo get_template_directory_uri() . "/images/no-image.png";
?>
" width="260" height="180" alt="" />
<?php
}
?>
</a> </div>
<div class="product_image grid_img"> <a href="<?php
the_permalink();
?>
">
<?php
if (get_post_meta($post->ID, 'file_name', true) != "") {
?>
<img src="<?php
echo templ_thumbimage_filter(get_post_meta($post->ID, 'file_name', true), 280, 180);
?>
" alt="" />
<?php
} else {
?>
<div class="noimg"> <?php
_e('Image <br /> not available', 'templatic');
?>
</div>
<?php
}
?>
</a> </div>
<div class="content_right content_right_inner"><?php
if (get_option('ptthemes_listing_author') != 'No') {
?>
<span class="title_grey"><?php
echo PROVIDE_BY;
?>
</span>
<?php
$user_db_table_name = get_user_table();
$user_data = $wpdb->get_row("select * from {$user_db_table_name} where ID = '" . $post->post_author . "'");
?>
<a href="<?php
echo get_author_posts_url($post->post_author);
?>
" class="top_lnk" title="<?php
echo $user_data->display_name;
?>
"><?php
echo get_post_meta($post->ID, 'owner_name', true);
?>
</a>
<?php
}
?>
<h3><a href="<?php
the_permalink();
?>
"><?php
echo $post->post_title;
?>
</a></h3>
<div class="grid_price"><span class="strike_rate"><?php
_e(OUR_PRICES, 'templatic');
?>
<s><?php
echo get_currency_sym();
echo $current_price;
?>
</s></span> <span class="rate"><?php
_e(OFFER_PRICE, 'templatic');
?>
<?php
echo get_currency_sym();
echo $our_price;
?>
</span>
</div>
<?php
if (get_post_meta($post->ID, 'enddate', true) != '0' || get_post_meta($post->ID, 'no_of_coupon', true) == $sellsqlinfo) {
if (date("Y-m-d H:i:s") >= $enddate1 || get_post_meta($post->ID, 'no_of_coupon', true) == $sellsqlinfo) {
if (get_post_meta($post->ID, 'is_expired', true) == '1') {
if (get_post_meta($post->ID, 'is_expired', true) == '0') {
update_post_meta($post->ID, 'is_expired', '1');
}
?>
<div class="i_expire"><?php
echo THIS_DEAL;
?>
<span><?php
echo EXPIRED;
?>
</span> <?php
echo ON;
?>
<span><?php
echo $tardate1;
?>
</span></div>
<?php
}
if (get_post_meta($post->ID, 'no_of_coupon', true) == $sellsqlinfo && get_post_meta($post->ID, 'is_expired', true) != '1') {
?>
<div class="i_start"><span><?php
echo "Is Sold Out";
?>
</span></div>
<?php
}
} else {
if (get_post_meta($post->ID, 'coupon_end_date_time', true)) {
?>
<div class="deal_time_box">
<div class="time_line"> </div>
<div id="countdowncontainer_<?php
_e($post->ID, 'templatic');
?>
"></div>
<div class="fr" id="fr_<?php
echo $post->ID;
?>
">
<div class="price_main"> <span class="strike_rate"><?php
echo get_currency_sym();
echo $current_price;
?>
</span> <span class="rate"><?php
echo get_currency_sym();
echo $our_price;
?>
</span> </div>
<?php
if (get_post_meta($post->ID, 'coupon_type', true) == 1) {
?>
<a href="<?php
echo get_post_meta($post->ID, 'coupon_link', true);
?>
" title="<?php
_e(BUY_NOW, 'templatic');
?>
" class="btn_buy" target="_blank"><?php
_e(BUY_NOW, 'templatic');
?>
</a>
<?php
} else {
?>
<a href="<?php
echo get_option('siteurl');
?>
/?ptype=buydeal&did=<?php
_e($post->ID, 'templatic');
?>
" title="<?php
_e(BUY_NOW, 'templatic');
?>
" class="btn_buy"><?php
_e(BUY_NOW, 'templatic');
?>
</a>
<?php
}
?>
</div>
<?php
$targatedate = explode(' ', $targatedate);
$tar_date = explode('-', $targatedate[0]);
$tar_time = explode(':', $targatedate[1]);
$timezone = get_option('ptthemes_time_offset');
$exp_year = explode(',', $tardate1);
?>
<script>
displayTZCountDown(setTZCountDown('<?php
echo $tar_date[1];
?>
','<?php
echo $tar_date[0];
?>
','<?php
echo $tar_time[0];
?>
','<?php
echo $timezone;
?>
','<?php
echo $exp_year[1];
?>
'),'countdowncontainer_<?php
_e($post->ID, 'templatic');
?>
','fr_<?php
echo $post->ID;
?>
','<?php
echo $tardate1;
?>
');
</script>
</div>
<?php
}
}
}
?>
<ul class="rate_summery">
<li class="rate_current_price"><span>
<?php
echo CURRENT_PRICE;
?>
</span> <strong><small><?php
echo get_currency_sym();
?>
</small><?php
echo $current_price;
?>
</strong></li>
<li class="rate_our_price"><span>
<?php
echo OUR_PRICE;
?>
</span> <strong><small><?php
echo get_currency_sym();
?>
</small><?php
echo $our_price;
?>
</strong></li>
<li class="rate_percentage"><span>
<?php
echo YOU_SAVE;
?>
</span> <strong><?php
echo @number_format($percentsave, 2);
?>
%</strong></li>
<li class="bdr_none rate_item_sold"><span>
<?php
echo ITEMS_SOLD;
?>
</span> <strong><?php
echo $sellsqlinfo;
?>
</strong> </li>
</ul>
<?php
if (templ_is_show_post_category()) {
?>
<div class="post_cats clearfix">
<?php
the_taxonomies(array('before' => '<span class="categories">', 'sep' => '</span><span class="tags">', 'after' => '</span>'));
?>
</div>
<?php
}
?>
<?php
if (get_post_meta($post->ID, 'enddate', true) == '0' && get_option('ptttheme_view_opt') != 'Grid View' && get_post_meta($post->ID, 'status', true) == '1' && get_post_meta($post->ID, 'is_expired', true) == '0') {
?>
<?php
if (get_post_meta($post->ID, 'coupon_type', true) == 1) {
?>
<a href="<?php
echo get_post_meta($post->ID, 'coupon_link', true);
?>
" title="<?php
echo BUY_NOW;
?>
" class="btn_buy_deal" target="_blank"><?php
echo BUY_NOW;
?>
</a>
<?php
} else {
?>
<a href="<?php
echo get_option('siteurl');
?>
/?ptype=buydeal&did=<?php
_e($post->ID, 'templatic');
?>
" title="<?php
echo BUY_NOW;
?>
" class="btn_buy_deal"><?php
echo BUY_NOW;
?>
</a>
<?php
}
}
?>
<?php
if (get_post_meta($post->ID, 'is_expired', true) != 1) {
if (get_post_meta($post->ID, 'coupon_type', true) == 1) {
?>
<a href="<?php
echo get_post_meta($post->ID, 'coupon_link', true);
?>
" onclick="" title="<?php
echo BUY_NOW;
?>
" class="btn_buy_grid"><?php
echo BUY_NOW;
?>
</a>
<?php
} else {
?>
<a href="<?php
echo get_option('siteurl');
?>
/?ptype=buydeal&did=<?php
_e($post->ID, 'templatic');
?>
" title="<?php
echo BUY_NOW;
?>
" class="btn_buy_grid"><?php
echo BUY_NOW;
?>
</a>
<?php
}
}
?>
<div class="text_content" id="content_<?php
_e($post->ID, 'templatic');
?>
">
<?php
echo "" . $post->post_excerpt . "";
?>
<a href="<?php
the_permalink();
?>
" class="readmore_link">
<?php
_e(get_option('ptthemes_content_excerpt_readmore'));
?>
</a> </div>
</div>
</div>
<?php
$page_layout = templ_get_page_layout();
if ($pcount == 3) {
$pcount = 0;
?>
<div class="hr clear"></div>
<?php
}
}
}
}
}
?>
<!-- EOF All Deal -->
</div>
</div>
<!-- CONTENT AREA END -->
<?php
}