FM / admin

/home/u775757334/domains/civicwelllife.com/public_html/management/admin/

/home/u775757334/domains/civicwelllife.com/public_html/management/admin

Name	Size	Mode	Actions
api/	-	0755	rm
dataQuery/	-	0755	rm
dist/	-	0755	rm
fonts/	-	0755	rm
function/	-	0755	rm
icons/	-	0755	rm
images/	-	0755	rm
include/	-	0755	rm
js/	-	0755	rm
loginQuery/	-	0755	rm
scripts/	-	0755	rm
styles/	-	0755	rm
vendor/	-	0755	rm
add-product.php	18141	0644	edit dl rm
apply-fresh.php	26904	0644	edit dl rm
banner-list.php	15940	0644	edit dl rm
banner.php	15867	0644	edit dl rm
blog-list.php	15943	0644	edit dl rm
blog.php	17027	0644	edit dl rm
brand-list.php	15920	0644	edit dl rm
brand-logo-list.php	15299	0644	edit dl rm
brand-logo.php	16979	0644	edit dl rm
brand.php	16209	0644	edit dl rm
brocher-list.php	15713	0644	edit dl rm
career-enquiry-list.php	16537	0644	edit dl rm
categories-list.php	17202	0644	edit dl rm
categories.php	17416	0644	edit dl rm
change-password.php	11770	0644	edit dl rm
city-list.php	16215	0644	edit dl rm
city.php	16082	0644	edit dl rm
company-list.php	15504	0644	edit dl rm
company-office-list.php	15811	0644	edit dl rm
company-office.php	16131	0644	edit dl rm
company-profile.php	19643	0644	edit dl rm
company-stock.php	16999	0644	edit dl rm
company.php	21073	0644	edit dl rm
course-list.php	16177	0644	edit dl rm
course.php	19406	0644	edit dl rm
customer-list.php	18027	0644	edit dl rm
customer-order-list.php	20938	0644	edit dl rm
customer.php	18812	0644	edit dl rm
day.php	13822	0644	edit dl rm
dbc.php	6617	0644	edit dl rm
delivered-parcel-list.php	26169	0644	edit dl rm
distributor-list.php	17837	0644	edit dl rm
distributor-order-details.php	17018	0644	edit dl rm
distributor-order-list.php	22259	0644	edit dl rm
distributor.php	19110	0644	edit dl rm
enquiry-list.php	16660	0644	edit dl rm
export-data.php	16892	0644	edit dl rm
favicon.ico	1150	0644	edit dl rm
forgot-password.php	4019	0644	edit dl rm
gallery-list.php	15893	0644	edit dl rm
gallery.php	16793	0644	edit dl rm
genrate-customer-order.php	25330	0644	edit dl rm
genrate-lead-list.php	19566	0644	edit dl rm
genrate-lead.php	24067	0644	edit dl rm
genrate-order.php	22370	0644	edit dl rm
home.php	16384	0644	edit dl rm
import-deliver-report.php	18563	0644	edit dl rm
import-manager-user.php	20714	0644	edit dl rm
import-mis-report.php	21161	0644	edit dl rm
index.php	4739	0644	edit dl rm
inward-report-list.php	21518	0644	edit dl rm
lead-category-list.php	15237	0644	edit dl rm
lead-category.php	18615	0644	edit dl rm
lead-list.php	15963	0644	edit dl rm
lead-status-list.php	15374	0644	edit dl rm
lead-status.php	18394	0644	edit dl rm
lead.php	23475	0644	edit dl rm
manager-list.php	16921	0644	edit dl rm
manager-user-list.php	27810	0644	edit dl rm
media-list.php	17533	0644	edit dl rm
media.php	14839	0644	edit dl rm
menu-category-list.php	15739	0644	edit dl rm
menu-category.php	16257	0644	edit dl rm
menu-list.php	15953	0644	edit dl rm
menu.php	16723	0644	edit dl rm
message.php	3033	0644	edit dl rm
mis-report-list.php	17045	0644	edit dl rm
mis-sample.csv	483	0644	edit dl rm
my-order-list.php	21040	0644	edit dl rm
my-product-stock.php	17959	0644	edit dl rm
my-retailer-order-list.php	20688	0644	edit dl rm
news-list.php	17941	0644	edit dl rm
news.php	17396	0644	edit dl rm
online-product-list.php	19468	0644	edit dl rm
online-product.php	17214	0644	edit dl rm
order-details.php	20698	0644	edit dl rm
order-list.php	23106	0644	edit dl rm
order-list2.php	22470	0644	edit dl rm
parcel-details-list.php	27146	0644	edit dl rm
parcel-request-list.php	27666	0644	edit dl rm
partners-list.php	15975	0644	edit dl rm
partners.php	17715	0644	edit dl rm
pdf-category-list.php	17954	0644	edit dl rm
pdf-category.php	16234	0644	edit dl rm
pdf-list.php	18100	0644	edit dl rm
pdf.php	18717	0644	edit dl rm
poster-list.php	15925	0644	edit dl rm
poster.php	16129	0644	edit dl rm
print-bill.php	25616	0644	edit dl rm
print-customer-bill.php	25378	0644	edit dl rm
product-list.php	18289	0644	edit dl rm
product.php	22375	0644	edit dl rm
project-category.php	19504	0644	edit dl rm
project-image-list.php	17805	0644	edit dl rm
project-image.php	17612	0644	edit dl rm
project-list.php	18233	0644	edit dl rm
project-product-list.php	17820	0644	edit dl rm
project-product.php	18483	0644	edit dl rm
project.php	19003	0644	edit dl rm
receive-product-list.php	17978	0644	edit dl rm
receive-product.php	19682	0644	edit dl rm
retail-print-bill.php	26362	0644	edit dl rm
retailer-genrate-order.php	22367	0644	edit dl rm
retailer-list.php	17825	0644	edit dl rm
retailer-order-details.php	17213	0644	edit dl rm
retailer-order-list.php	21049	0644	edit dl rm
retailer.php	19086	0644	edit dl rm
rm-order-list.php	22360	0644	edit dl rm
rm-user-list.php	17766	0644	edit dl rm
rm-user.php	19056	0644	edit dl rm
service-list.php	17589	0644	edit dl rm
service.php	15818	0644	edit dl rm
setting.php	19923	0644	edit dl rm
show-student-list.php	20558	0644	edit dl rm
size-list.php	16053	0644	edit dl rm
size.php	15517	0644	edit dl rm
source-list.php	15217	0644	edit dl rm
source.php	18382	0644	edit dl rm
staff-list.php	15906	0644	edit dl rm
staff.php	17700	0644	edit dl rm
state-list.php	15944	0644	edit dl rm
state.php	15242	0644	edit dl rm
stock-transaction.php	17998	0644	edit dl rm
stock.php	16317	0644	edit dl rm
team-list.php	16019	0644	edit dl rm
team.php	16318	0644	edit dl rm
testimonial-list.php	15969	0644	edit dl rm
testimonial.php	16399	0644	edit dl rm
university-list.php	17911	0644	edit dl rm
university.php	18601	0644	edit dl rm
upload-brocher.php	18118	0644	edit dl rm
user-list.php	16591	0644	edit dl rm
user.php	21410	0644	edit dl rm
view-lead.php	23641	0644	edit dl rm
view-product.php	18105	0644	edit dl rm
website-setting.php	12534	0644	edit dl rm

Edit: /home/u775757334/domains/civicwelllife.com/public_html/management/admin/export-data.php (16892B)

<?php include'loginQuery/session_start.php';
/*header("Content-Type: application/xls");    
$date = "Date-".date('Y-m-d');
header("Content-Disposition: attachment; filename=".$date.".xls");  
header("Pragma: no-cache"); 
header("Expires: 0");*/
    include'dbc.php';
    if(isset($_POST['mode'])){
        $mode = $_POST['mode'];
    }else if(isset($_GET['mode'])){
        $mode = $_GET['mode'];
    }
    
    /*{
        1 = export delivered report
    }*/
$sql=mysqli_query($conn,"select * from $tblManager")or die(mysqli_error($conn));    
while($row=mysqli_fetch_assoc($sql))
{
    $managerNameAry[$row['id']] = $row['name']; 
    $companyNameAry[$row['id']] = $row['company_name']; 
    $companyCodeAry[$row['id']] = $row['company_code']; 
}
$sql=mysqli_query($conn,"select * from $tblManagerUser")or die(mysqli_error($conn));    
while($row=mysqli_fetch_assoc($sql))
{
    $userNameAry[$row['id']] = $row['name']; 
    $userIDAry[$row['id']] = $row['user_id']; 
    $branchNameAry[$row['id']] = $row['branch_name']; 
    $branchCodeAry[$row['id']] = $row['branch_code']; 
    $userCityAry[$row['id']] = $row['city_id']; 
    $userStateAry[$row['id']] = $row['state_id']; 
    $userZoneAry[$row['id']] = $row['zone_id']; 
    $managerEmailAry[$row['id']] = $row['manager_email']; 
    $addressTypeAry[$row['id']] = $row['address_type']; 
    $addressAry[$row['id']] = $row['address'];

}
$courierAry[]="";
$courierAry[0]="";
$sql=mysqli_query($conn,"select * from $tblCourier")or die(mysqli_error($conn));
while($row=mysqli_fetch_assoc($sql))
{
    $courierAry[$row['id']] = $row['name']; 
}

$sql=mysqli_query($conn,"select * from $tblRequestStatue")or die(mysqli_error($conn));
while($row=mysqli_fetch_assoc($sql))
{
    $parcelAry[$row['id']] = $row['name']; 
    $colorAry[$row['id']] = $row['color']; 
}
$cityAry[0] = "";
$sql=mysqli_query($conn,"select * from $tblCity")or die(mysqli_error($conn));
while($row=mysqli_fetch_assoc($sql))
{
    $cityAry[$row['id']] = $row['name']; 
}
$stateAry[]="";
$stateAry[0]="";
$sql=mysqli_query($conn,"select * from $tblState")or die(mysqli_error($conn));
while($row=mysqli_fetch_assoc($sql))
{
    $stateAry[$row['id']] = $row['name']; 
}
$zoneAry[]="";
$zoneAry[0]="";
$sql=mysqli_query($conn,"select * from $tblZone")or die(mysqli_error($conn));
while($row=mysqli_fetch_assoc($sql))
{
    $zoneAry[$row['id']] = $row['name']; 
}

if($mode==1){
        $query = $_POST['query'];
        ?>

<table>
                <tbody>
                    <tr>
                        <th>Request Code</th>
                        <th>PickupDate</th>
                        <th>AWB No</th>
                        <th>User ID</th>
                        <th>User Name</th>
                        <th>Branch Name</th>
                        <th>Branch Code</th>
                        <th>City</th>
                        <th>State</th>

<th>Zone</th>
                        <th>Manager Email</th>
                        <th>ODA/Normal</th>
                        <th>Address</th>
                        
                        <th>File</th>
                        <th>Document</th>
                        <th>Weight(kg)</th>
                        <th>Weight(grm)</th>
                        <th>Courier</th>
                        <th>Delivered Date</th>
                        <th>Destination</th>
                        <th>Consignee Name</th>
                        <th>Destination City</th>
                        <th>Status</th>
                    </tr>
                    <?php 
                    
                    $sql=mysqli_query($conn,$query) or die(mysqli_error($conn));
                    while($row=mysqli_fetch_assoc($sql)){
                        extract($row);
                    /*$start = $row['id']+1;
                    $total = $_GET['number']+$row['id'];
                    for($i=$start;$i<=$total;$i++){
                        $cardNumber = date('Y')."-".date('md')."-".rand(1000,9999)."-".sprintf("%04d", $i);
                        $values[]   = "('$cardNumber', '0',1,0)";*/

<?php }?>
   <?php if($mode==3){
        $query = $_POST['query'];
        ?>

<table>
                <tbody>
                    <tr>
                        <th>Request Code</th>
                        <th>Request Date</th>
                        <th>User ID</th>
                        <th>User Name</th>
                        <th>Branch Name</th>
                        <th>Branch Code</th>
                        <th>City</th>
                        <th>State</th>

<th>Zone</th>
                        <th>Manager Email</th>
                        <th>ODA/Normal</th>
                        <th>Address</th>
                        
                        <th>File</th>
                        <th>Document</th>
                        <th>Remark</th>
                        
                        <th>Status</th>
                    </tr>
                    <?php 
                    
                    $sql=mysqli_query($conn,$query) or die(mysqli_error($conn));
                    while($row=mysqli_fetch_assoc($sql)){
                        extract($row);
                    /*$start = $row['id']+1;
                    $total = $_GET['number']+$row['id'];
                    for($i=$start;$i<=$total;$i++){
                        $cardNumber = date('Y')."-".date('md')."-".rand(1000,9999)."-".sprintf("%04d", $i);
                        $values[]   = "('$cardNumber', '0',1,0)";*/

?>
                    <tr>
                        <td><?= $request_code; ?> </td>
                        <td><?= $request_date; ?> </td>
                        
                        <td><?= $userIDAry[$user_id]; ?></td>
                        <td><?= $userNameAry[$user_id]; ?></td>
                        <td><?= $branchNameAry[$user_id]; ?></td>
                        <td><?= $branchCodeAry[$user_id]; ?></td>
                        <td><?= $cityAry[$userCityAry[$user_id]]; ?></td>
                        <td><?= $stateAry[$userStateAry[$user_id]]; ?></td>
                        <td><?= $zoneAry[$userZoneAry[$user_id]]; ?></td>
                        <td><?= $managerEmailAry[$user_id]; ?></td>
                        <td><?= $addressType[$addressTypeAry[$user_id]]; ?></td>
                        <td><?= $addressAry[$user_id]; ?></td>
                        
                        
                        <td><?= $file_count; ?></td>
                        <td><?= $document_count; ?></td>
                        <td><?= $remark; ?></td>

</tr>
                    <?php  } 
                        
                    ?>
                </tbody>
            </table>
            
   <?php }?>

<?php if($mode==2){
        $query = $_POST['query'];
        ?>

<table>
                <tbody>
                    <tr>
                        <th>Request Code</th>
                        <th>PickupDate</th>
                        
                        <th>AWB No</th>
                        <th>User ID</th>
                        <th>User Name</th>
                        <th>Branch Name</th>
                        <th>Branch Code</th>
                        <th>City</th>
                        <th>State</th>

<th>Zone</th>
                        <th>Manager Email</th>
                        <th>ODA/Normal</th>
                        <th>Address</th>

<th>File</th>
                        <th>Document</th>
                        <th>Weight(kg)</th>
                        <th>Weight(grm)</th>
                        <th>Courier</th>
                        <th>Delivered Date</th>
                        <th>Destination</th>
                        <th>Consignee Name</th>
                        <th>Destination City</th>
                        <th>Status</th>
                    </tr>
                    <?php 
                    
                    $sql=mysqli_query($conn,$query) or die(mysqli_error($conn));
                    while($row=mysqli_fetch_assoc($sql)){
                        extract($row);
                    /*$start = $row['id']+1;
                    $total = $_GET['number']+$row['id'];
                    for($i=$start;$i<=$total;$i++){
                        $cardNumber = date('Y')."-".date('md')."-".rand(1000,9999)."-".sprintf("%04d", $i);
                        $values[]   = "('$cardNumber', '0',1,0)";*/

?>
                    <tr>
                        <td><?= $request_code; ?> </td>
                        <td><?= $pickup_date; ?> </td>
                        <td><?= $awb_number; ?> </td>
                        <td><?= $userIDAry[$user_id]; ?></td>
                        <td><?= $userNameAry[$user_id]; ?></td>
                        <td><?= $branchNameAry[$user_id]; ?></td>
                        <td><?= $branchCodeAry[$user_id]; ?></td>
                        <td><?= $cityAry[$userCityAry[$user_id]]; ?></td>
                        <td><?= $stateAry[$userStateAry[$user_id]]; ?></td>
                        <td><?= $zoneAry[$userZoneAry[$user_id]]; ?></td>
                        <td><?= $managerEmailAry[$user_id]; ?></td>
                        <td><?= $addressType[$addressTypeAry[$user_id]]; ?></td>
                        <td><?= $addressAry[$user_id]; ?></td>
                        <td><?= $file_count; ?></td>
                        <td><?= $document_count; ?></td>
                        <td><?= $weight; ?></td>
                        <td><?= $gram; ?></td>
                        <td><?= $courierAry[$courier_company_id]; ?></td>
                        <td><?= $delivered_date; ?> </td>
                        <td><?= $destinationAry[$head_office]; ?> </td>
                        <td><?= $consignee_name; ?> </td>
                        <td><?= $cityAry[$destination_city_id];?> </td>
                        <td>
                            <?= $parcelAry[$status]?>
                        </td>
                        
                    </tr>
                    <?php  } 
                        
                    ?>
                </tbody>
            </table>
   <?php }?>

<?php if($mode==4){
        $query = $_POST['query'];
        ?>

<table>
                <tbody>
                    <tr>
                        <th>State</th>
                        <th>City</th>
                        <th>Zone</th>
                        <th>Client</th>
                        <th>Company Name</th>
                        <th>Company Code</th>
                        <th>Manager Email</th>
                        <th>Branch Name</th>
                        <th>Branch Code</th>
                        <th>User ID</th>
                        <th>Name</th>
                        <th>Phone</th>
                        <th>Email</th>
                        <th>ODA/Normal</th>
                        <th>Address</th>
                        <th>Status</th>
                    </tr>
                    <?php 
                    
                    $sql=mysqli_query($conn,$query) or die(mysqli_error($conn));
                    while($row=mysqli_fetch_assoc($sql)){
                        extract($row);
                    ?>
                    <tr>
                        <td><?= $stateAry[$state_id]; ?> </td>
                        <td><?= $cityAry[$city_id]; ?> </td>
                        <td><?= $zoneAry[$zone_id]; ?> </td>
                        <td><?= $managerNameAry[$manager_id]; ?></td>
                        <td><?= $companyNameAry[$manager_id]; ?></td>
                        <td><?= $companyCodeAry[$manager_id]; ?></td>
                        <td><?= $manager_email;?></td>
                        <td><?= $branch_name; ?></td>
                        <td><?= $branch_code; ?></td>
                        <td><?= $user_id; ?></td>
                        <td><?= $name; ?></td>
                        <td><?= $phone; ?></td>
                        <td><?= $email; ?></td>
                        <td><?= $addressType[$address_type]; ?></td>
                        <td><?= $address; ?></td>
                        <td>
                            <?php 
                                if($status==1){
                                    echo "Approve";
                                }else{
                                    echo "UnApprove";
                                }
                            ?>
                        </td>
                        
                    </tr>
                    <?php  } 
                        
                    ?>
                </tbody>
            </table>
   <?php }?>

<?php if($mode==5){
        $uid = $_GET['uid'];
        ?>

<table>
                <tbody>
                    <tr>
                        <th width="30">#</th>
                        <th>Client</th>
                        <th>Client Code</th>
                        <th>Date Of Inward</th>
                        <th>pod number</th>
                        <th>Courier Company</th>
                        <th>Type of packets</th>
                        <th>remark_1</th>
                        <th>remark_2</th>
                        <th>remark_3</th>
                    </tr>
                    <?php  
                   $i=1;

$sql=mysqli_query($conn,"select * from $tblMisReport where uid='$uid'")or die(mysqli_error());
                while($row=mysqli_fetch_assoc($sql))
                {extract($row);
                    
                    
                        echo "
                                <tr>
                                    <td>{$i}</td>
                                    <td>{$managerNameAry[$client_id]}</td>
                                    <td>{$companyCodeAry[$client_id]}</td>
                                    <td>{$date_of_inward}</td>
                                    <td>{$pod_number}</td>
                                    <td>{$courier_company_name}</td>
                                    <td>{$type_of_packets}</td>
                                    <td>{$remark_1}</td>
                                    <td>{$remark_2}</td>
                                    <td>{$remark_3}</td>
                                </tr>"; 
                                $i++;
                        
                } 
                        
                    ?>
                </tbody>
            </table>
   <?php }?>                  
 <style>
    table tr th{
        background: #087be1;
        color: #fff;
    }
     table tr th,td{
        border: 1px solid #f1f1f1;
     }
 </style>

Request Code	PickupDate	AWB No	User ID	User Name	Branch Name	Branch Code	City	State	Zone	Manager Email	ODA/Normal	Address	File	Document	Weight(kg)	Weight(grm)	Courier	Delivered Date	Destination	Consignee Name	Destination City	Status

Request Code	Request Date	User ID	User Name	Branch Name	Branch Code	City	State	Zone	Manager Email	ODA/Normal	Address	File	Document	Remark	Status

Request Code	PickupDate	AWB No	User ID	User Name	Branch Name	Branch Code	City	State	Zone	Manager Email	ODA/Normal	Address	File	Document	Weight(kg)	Weight(grm)	Courier	Delivered Date	Destination	Consignee Name	Destination City	Status

State	City	Zone	Client	Company Name	Company Code	Manager Email	Branch Name	Branch Code	User ID	Name	Phone	Email	ODA/Normal	Address	Status

"; $i++; } ?>

#	Client	Client Code	Date Of Inward	pod number	Courier Company	Type of packets	remark_1	remark_2	remark_3
{$i}	{$managerNameAry[$client_id]}	{$companyCodeAry[$client_id]}	{$date_of_inward}	{$pod_number}	{$courier_company_name}	{$type_of_packets}	{$remark_1}	{$remark_2}	{$remark_3}