<? session_start();
include_once ('includes/database.php');
include_once ("includes/dbFunc.php");
if (!isset($_SESSION['user']))
{
header("Location: login.php"); / Redirect browser /
exit;
}
/////////////////////////////////////////////////////////////////////
include('includes/Paging.class.php');
$arrMainParam['TOTAL_RECORDS'] = '';
$arrChildParam['FORM_NAME'] = 'frm';
$arrMainParam['RECORDS_PER_PAGE'] = 10;
$arrMainParam['PAGELINKS_PER_PAGE'] = 10;
$arrChildParam['SHOW_TOTAL_RECORDS_FOUND'] = '0';
$arrChildParam['PAGINATION_STYLE'] = '3';
$arrChildParam['SPT_URL_PARAM'] = '1';
//////////////////////////////////////////////////////////////////////////
if($POST['btnAction']=="delete" && isset($POST['selection'])){
// delete the eflyer account
$selection = $POST['selection'];
$selection_arr=count($selection);
for($i=0;$i<$selection_arr;$i++){
$sql_del_eflyer = "delete from tbleflyer WHERE Eflyer_id ='".$selection[$i]."'";
$enRes = mysql_query($sql_del_eflyer)or die("Invalid query: " . mysql_error());
$sql_insert_History="insert into tblhistoryeflyer (History_user_id ,History_eflyer_id) values('".$SESSION['userID']."','".$selection[$i]."')";
$res_insert_History= mysql_query($sql_insert_History)or die("Invalid query: " . mysql_error());
}
$message="E-Flyer deleted succesfully";
}
$sql_slct_eflyer="select * from tbleflyer where Eflyer_user_id='".$_SESSION['userID']."'";
$res_slct_eflyer= mysql_query($sql_slct_eflyer)or die("Invalid query: " . mysql_error());
//die($sql_slct_eflyer);
$num_slct_eflyer = mysql_num_rows($res_slct_eflyer);
$num_rows=mysql_num_rows($res_slct_eflyer);
$arrMainParam['TOTAL_RECORDS'] = $num_rows;
$objPaging = new Paging($arrMainParam);
$sql_slct_eflyer.= $objPaging->SPT_SQL_WITH_LIMIT;
$res_slct_eflyer1=mysql_query($sql_slct_eflyer);
if($num_slct_eflyer>0){
$i=1;
$table_string="<table><tr><td><input type='checkbox' name='tickall' id='tickall' onclick='javascript:checkall();'></td><td>Eflye Name</td><td>Eflyer Area</td><td>Eflyer Created</td><td>Eflyer Send Date</td><td>Eflyer Credit</td><td>Eflyer Status</td></tr>";
while($rw_slct=mysql_fetch_array($res_slct_eflyer1, MYSQL_BOTH)){
if($i%2!=0){
$trcolor = "#EFEFEF";
}else{
$trcolor = "#FFFFFF";
}
$i++;
$table_string.="<tr bgcolor=".$trcolor."><td><input type='checkbox' name='selection[]' id='selection[]' value='".$rw_slct['Eflyer_Id']."'></td>";
$table_string.="<td ><a href='eflyerProof.php?id=".$rw_slct['Eflyer_Id']."'>".$rw_slct['Eflyer_Name']."</a></td>";
if($rw_slct['Area_Send']=="")
$area_num=0;
else
$area_num=$rw_slct['Area_Send'];
$area_send_arr=explode(",",$rw_slct['Area_Send']);
$sql_state="select area_def from tblareadef where area_id in(".$area_num.") ";
$res_state= mysql_query($sql_state)or die("Invalid query: " . mysql_error());
//die($sql_state);
$area_send="";
while($rw_state=mysql_fetch_array($res_state, MYSQL_BOTH))
{
$area_send.=$rw_state['area_def'].",";
}
$area_send=substr($area_send,0,-1);
$table_string.="<td title='".$area_send."'>".substr($area_send,0,80)."</td>";
$table_string.="<td>".$rw_slct['Eflyer_datetime']."</td>";
$table_string.="<td>".$rw_slct['Date_Send']."</td>";
$table_string.="<td>".$rw_slct['Eflyer_credit']."</td>";
if($rw_slct['Eflyer_status']==1){
$table_string.="<td>Paid Send</td></tr>";
}else if($rw_slct['Eflyer_status']==0){
$table_string.="<td>Pending</td></tr>";
}else if($rw_slct['Eflyer_status']==3){
$table_string.="<td>Viewed</td></tr>";
}else if($rw_slct['Eflyer_status']==2){
$table_string.="<td>Paid Un Send</td></tr>";
}
}
$table_string.="<tr>
<td bgcolor='C9C37F' valign='top' align='center' colspan='7'>
<font color='green'>To Edit / Re-Send a E-Flyer previously created, please click on name of E-Flyer
</td>
</tr></table>";
}else{
$message="No Eflyer Created Yet";
}
// conetent start
$data=file_get_contents("template/heade_left_footer.html");
$data=eregi_replace("%%title%%","E-Flyer",$data);
$btnaction='<select name="btnAction">
<option value="delete">Delete</option>
</select> <input type="submit" name="Go" value="Go">';
$data3=file_get_contents("template/eflyerListing.html");
$data3=eregi_replace("%%eflyerList%%","eflyerListing.php",$data3);
$data3=eregi_replace("%%tableString%%",$table_string,$data3);
$data3=eregi_replace("%%btnAction%%",$btnaction,$data3);
$data3=eregi_replace("%%paging%%",$objPaging->fnCreateSPT($arrChildParam),$data3);
$data=eregi_replace("%%inner_table%%",$data3,$data);
if (isset($message))
{
$data=eregi_replace("<!--MESSAGE","<!--MESSAGE-->",$data);
$data=eregi_replace("MESSAGE-->","<!--MESSAGE-->",$data);
$data=eregi_replace("%%message%%",$message,$data);
}
print $data;
exit();
?>
