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 }
<?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 . "'"); 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 $user_data->display_name; ?> " class="top_lnk" target="_blank"><?php echo get_post_meta($post->ID, 'owner_name', true); ?> </a> <?php } else {