pageLimit = 50; $link = ""; if (!empty($filter_keyword)) { $link .= "&query=".$filter_keyword; $sql = "(`name` LIKE '%$filter_keyword%' OR `headline` LIKE '%$filter_keyword%' OR `description` LIKE '%$filter_keyword%') "; $db->where($sql); } if (!empty($_GET['range']) && in_array($_GET['range'], array('Today','Yesterday','This Week','This Month','Last Month','This Year'))) { if ($_GET['range'] == 'Today' || $_GET['range'] == 'Yesterday') { $this_start = strtotime(date('M')." ".date('d').", ".date('Y')." 12:00am"); $this_end = strtotime(date('M')." ".date('d').", ".date('Y')." 11:59pm"); if ($_GET['range'] == 'Yesterday') { $this_start = strtotime(date('M')." ".date('d',strtotime("-1 days")).", ".date('Y')." 12:00am"); $this_end = strtotime(date('M')." ".date('d',strtotime("-1 days")).", ".date('Y')." 11:59pm"); } $main_range = 'Today'; $title = "Daily"; } elseif ($_GET['range'] == 'This Week') { $time = strtotime(date('l').", ".date('M')." ".date('d').", ".date('Y')); if (date('l') == 'Saturday') { $this_start = strtotime(date('M')." ".date('d').", ".date('Y')." 12:00am"); } else{ $this_start = strtotime('last saturday, 12:00am', $time); } if (date('l') == 'Friday') { $this_end = strtotime(date('M')." ".date('d').", ".date('Y')." 11:59pm"); } else{ $this_end = strtotime('next Friday, 11:59pm', $time); } $main_range = 'This Week'; $title = "Weekly"; } elseif ($_GET['range'] == 'This Month' ||$_GET['range'] == 'Last Month') { $this_start = strtotime("1 ".date('M')." ".date('Y')." 12:00am"); $this_end = strtotime(cal_days_in_month(CAL_GREGORIAN, date('m'), date('Y'))." ".date('M')." ".date('Y')." 11:59pm"); if ($_GET['range'] == 'Last Month') { $this_start = strtotime("1 ".date('M',strtotime("-1 month"))." ".date('Y')." 12:00am"); $this_end = strtotime(cal_days_in_month(CAL_GREGORIAN, date('m',strtotime("-1 month")), date('Y'))." ".date('M',strtotime("-1 month"))." ".date('Y')." 11:59pm"); } $main_range = 'This Month'; $title = "Monthly"; } elseif ($_GET['range'] == 'This Year') { $this_start = strtotime("1 January ".date('Y')." 12:00am"); $this_end = strtotime("31 December ".date('Y')." 11:59pm"); $main_range = 'This Year'; $title = "Yearly"; } } $start = ''; $end = ''; $first_code = ''; $second_code = ''; if (!empty($_GET['range']) && !in_array($_GET['range'], array('Today','Yesterday','This Week','This Month','Last Month','This Year'))) { $arr = explode('-', $_GET['range']); if (preg_match('~(0[1-9]|1[012])[- /.](0[1-9]|[12][0-9]|3[01])[- /.](19|20)\d\d~m', $arr[0]) && preg_match('~(0[1-9]|1[012])[- /.](0[1-9]|[12][0-9]|3[01])[- /.](19|20)\d\d~m', $arr[1])) { $start = PT_Secure($arr[0]); $end = PT_Secure($arr[1]); $this_start = strtotime($start); $this_end = strtotime($end); $month_days = cal_days_in_month(CAL_GREGORIAN, date('m',strtotime($start)), date('Y',strtotime($start))); $diff = abs(strtotime($end) - strtotime($start)); $years = floor($diff / (365*60*60*24)); $months = floor(($diff - $years * 365*60*60*24) / (30*60*60*24)); $days = floor(($diff - $years * 365*60*60*24 - $months*30*60*60*24)/ (60*60*24)); if ($years >= 1) { $array = array(); for ($i=date('Y',strtotime($start)); $i <= date('Y',strtotime($end)); $i++) { $array["'".$i."'"] = 0; } $main_range = 'Custom'; $code = 'Y'; $title = "Yearly"; } elseif ($months >= 1) { $array = array('01' => 0 ,'02' => 0 ,'03' => 0 ,'04' => 0 ,'05' => 0 ,'06' => 0 ,'07' => 0 ,'08' => 0 ,'09' => 0 ,'10' => 0 ,'11' => 0 ,'12' => 0); $code = 'm'; $main_range = 'This Year'; $title = "Monthly"; if (date('Y',strtotime($start)) == date('Y',strtotime($end))) { $array = array(); for ($i=date('m',strtotime($start)); $i <= date('m',strtotime($end)); $i++) { $array["'".(int)$i."'"] = 0; } $code = 'm'; $main_range = 'Custom'; } else{ $month = cal_days_in_month(CAL_GREGORIAN, date('m',strtotime($start)), date('Y',strtotime($start))); $array = array(); for ($i=(int)date('m',strtotime($start)); $i <= 12; $i++) { $array["'".(int)$i.'-'.date('Y',strtotime($start))."'"] = 0; } for ($i=1; $i <= (int)date('m',strtotime($end)); $i++) { $array["'".(int)$i.'-'.date('Y',strtotime($end))."'"] = 0; } $first_code = 'm'; $second_code = 'Y'; $main_range = 'Custom'; } } elseif ($days > 7) { if (date('m',strtotime($start)) == date('m',strtotime($end))) { $array = array(); for ($i=date('d',strtotime($start)); $i <= date('d',strtotime($end)); $i++) { $array["'".(int)$i."'"] = 0; } $code = 'd'; $main_range = 'Custom'; } else{ $month = cal_days_in_month(CAL_GREGORIAN, date('m',strtotime($start)), date('Y',strtotime($start))); $array = array(); for ($i=(int)date('d',strtotime($start)); $i <= $month; $i++) { $array["'".(int)$i.'-'.date('m',strtotime($start))."'"] = 0; } for ($i=1; $i <= (int)date('d',strtotime($end)); $i++) { $array["'".(int)$i.'-'.date('m',strtotime($end))."'"] = 0; } $first_code = 'd'; $second_code = 'm'; $main_range = 'Custom'; } $title = "Daily"; } elseif ($days >= 1 && $days < 8) { $title = "Daily"; $code = 'l'; $array = array('Saturday' => 0 , 'Sunday' => 0 , 'Monday' => 0 , 'Tuesday' => 0 , 'Wednesday' => 0 , 'Thursday' => 0 , 'Friday' => 0); if (date('m',strtotime($start)) == date('m',strtotime($end))) { $array = array(); for ($i=date('d',strtotime($start)); $i <= date('d',strtotime($end)); $i++) { $array["'".(int)$i."'"] = 0; } $code = 'd'; $main_range = 'Custom'; } else{ $month = cal_days_in_month(CAL_GREGORIAN, date('m',strtotime($start)), date('Y',strtotime($start))); $array = array(); for ($i=(int)date('d',strtotime($start)); $i <= $month; $i++) { $array["'".(int)$i.'-'.date('m',strtotime($start))."'"] = 0; } for ($i=1; $i <= (int)date('d',strtotime($end)); $i++) { $array["'".(int)$i.'-'.date('m',strtotime($end))."'"] = 0; } $first_code = 'd'; $second_code = 'm'; $main_range = 'Custom'; } } } } $rang_link = $link; if (!empty($this_start) && !empty($this_end)) { $link .= "&range=".PT_Secure($_GET['range']); $db->where('posted',$this_start,'>=')->where('posted',$this_end,'<='); } $sort_link = $link; $sort_array = array('DESC_i' => array('id' , 'DESC'), 'ASC_i' => array('id' , 'ASC'), 'DESC_t' => array('headline' , 'DESC'), 'ASC_t' => array('headline' , 'ASC'), 'DESC_s' => array('spent' , 'DESC'), 'ASC_s' => array('spent' , 'ASC'), 'DESC_p' => array('posted' , 'DESC'), 'ASC_p' => array('posted' , 'ASC'), 'DESC_l' => array('placement' , 'DESC'), 'ASC_l' => array('placement' , 'ASC'), 'DESC_r' => array('results' , 'DESC'), 'ASC_r' => array('results' , 'ASC')); if (!empty($_GET['sort']) && in_array($_GET['sort'], array_keys($sort_array))) { $db->orderBy($sort_array[$_GET['sort']][0],$sort_array[$_GET['sort']][1]); $link .= "&sort=".PT_Secure($_GET['sort']); $rang_link .= "&sort=".PT_Secure($_GET['sort']); } else{ $_GET['sort'] = 'DESC_i'; $db->orderBy('id', 'DESC'); } $user_ads = $db->objectbuilder()->paginate(T_USR_ADS, $page); if (($page > $db->totalPages) && !empty($_GET['page-id'])) { header("Location: " . PT_LoadAdminLinkSettings('manage-user-ads')); exit(); } ?>
ID | Website | Title | User | Wallet | Spent | Published | Placement | Results | Action |
---|