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>

cmd: