180 lines
5.9 KiB
PHP
180 lines
5.9 KiB
PHP
<?php
|
|
header("Content-type: application/x-msdownload");
|
|
header("Content-Disposition: attachment; filename=License Details.xls");
|
|
header("Pragma: no-cache");
|
|
header("Expires: 0");
|
|
|
|
?>
|
|
|
|
<?php
|
|
include 'includes/config/config.php';
|
|
?>
|
|
<html>
|
|
<body>
|
|
<table border="1">
|
|
|
|
<tr>
|
|
<th>Department Name</th>
|
|
<th>Executive Name</th>
|
|
<th>Serial No:</th>
|
|
<th>Zone:</th>
|
|
<th>Ward No:</th>
|
|
<th>Name of the Unit:</th>
|
|
<th>Name of Applicant with Designation in the Unit:</th>
|
|
<th>Father's/Husband's Name of Applicant:</th>
|
|
<th>Partner/Proprietor/Director/Authorized signatory </th>
|
|
<th>Trade/Industry with HP</th>
|
|
<th>Any other remarks/Information</th>
|
|
<th>License No:</th>
|
|
<th>License Status:</th>
|
|
<th>License Generation Date</th>
|
|
<th>License Valid Up to</th>
|
|
<th>Address of Premises:</th>
|
|
<th>Telephone No:</th>
|
|
<th>Email Id:</th>
|
|
<th>Residential Address of Applicant:</th>
|
|
<th>Telephone No</th>
|
|
<th>Email Id:</th>
|
|
|
|
|
|
<th>Product Name</th>
|
|
<th>Product Code:</th>
|
|
|
|
<th>Whether Applicant is Owner/Tenant/Legal Occupier</th>
|
|
<th>Date of Establishment of the Unit:</th>
|
|
<th>Area of the Establishment in Sq.Mtrs :</th>
|
|
<th>Age of Building premises (in years) for which Trade License is applied for</th>
|
|
<th>Whether the premises is protected under Delhi Special Protections Act-2011:</th>
|
|
<th>Whether sufficient space for loading & unloading is available or not and also mention the width of road:</th>
|
|
<th>Whether the premises is approved/regularized as per Building Bye-Laws:</th>
|
|
|
|
<th>Whether the trade/articles of storage are Pollutant/obnoxious/hazardous or apparently prone to fire:</th>
|
|
<th>Whether proof of legal occupancy of establishment attached</th>
|
|
<th>Whether identity and residence proof attached</th>
|
|
<th>Whether sketch map showing location of property attached:</th>
|
|
<th>Whether proof of payment of parking and conversion charges, as applicable attached:</th>
|
|
<th>Whether proof for date of commencement of Business/Affidavit in the matter attached:</th>
|
|
<th>Whether Structural Safety Certificate attached(if applicable):</th>
|
|
<th>Whether pollution NOC attached (if applicable):</th>
|
|
<th>Whether Fire Safety Certificate attached, (if applicable):</th>
|
|
<th>Whether name of the other partners/directors of the Firm/Parent Organization with percentage and address attached (if applicable):</th>
|
|
|
|
<th>License DD No.</th>
|
|
<th>License Receipt No</th>
|
|
<th>License DD Date</th>
|
|
<th>Total Amount (License)</th>
|
|
<th>Bank Name (License)</th>
|
|
<th>Bank Branch (License)</th>
|
|
<th>Registration Fees</th>
|
|
<th>Previous Year Amount (License)</th>
|
|
<th>License Amount</th>
|
|
<th>Advance Amount (License)</th>
|
|
|
|
<th>Processing DD No</th>
|
|
<th>Processing Receipt No</th>
|
|
<th>Processing DD Date</th>
|
|
<th>Processing Amount</th>
|
|
<th>Bank Name (Processing)</th>
|
|
<th>Bank Branch (Processing)</th>
|
|
|
|
|
|
<?php
|
|
$sql = $_SESSION['exportData'];
|
|
$results = mysqli_query($conn,$sql);
|
|
while($row = @mysqli_fetch_array($results))
|
|
{
|
|
@extract($row);
|
|
$applicantId = $row['id'];
|
|
$sql_address = "SELECT * FROM applicant_address WHERE applicant_id=$applicantId";
|
|
$result_address = @mysqli_query($conn,$sql_address);
|
|
$row_address = @mysqli_fetch_array($result_address);
|
|
@extract($row_address);
|
|
|
|
$sql_zone = "SELECT zone_name FROM zone WHERE zone_id=$zone";
|
|
$result_zone = mysqli_query($conn,$sql_zone);
|
|
$row_zone = mysqli_fetch_array($result_zone);
|
|
|
|
$sql_ward = "SELECT ward_name FROM ward WHERE ward_id=$ward_no";
|
|
$result_ward = mysqli_query($conn,$sql_ward);
|
|
$row_ward = mysqli_fetch_array($result_ward);
|
|
|
|
$sql_check_list = "SELECT * FROM applicant_check_list_document WHERE applicant_id=$applicantId";
|
|
$result_check_list = @mysqli_query($conn,$sql_check_list);
|
|
$row_check_list = @mysqli_fetch_array($result_check_list);
|
|
@extract($row_check_list);
|
|
?>
|
|
|
|
<tr>
|
|
<td><?php echo $dept_name;?></td>
|
|
<td><?php echo $executive_name;?></td>
|
|
<td><?php echo $serial_no;?></td>
|
|
<td><?php echo $row_zone['zone_name'];?></td>
|
|
<td><?php echo $row_ward['ward_name'];?></td>
|
|
<td><?php echo $name_of_unit;?></td>
|
|
<td><?php echo $name_of_applicant;?></td>
|
|
<td><?php echo $name_of_applicant_gurdian;?></td>
|
|
<td><?php echo $authorizedSignatory;?></td>
|
|
<td><?php echo $trade_with_hp;?></td>
|
|
<td><?php echo $remarks;?></td>
|
|
<td><?php echo $licence_no;?></td>
|
|
<td><?php echo $license_status;?></td>
|
|
<td><?php echo $license_generation_date;?></td>
|
|
<td><?php echo $license_valid_up;?></td>
|
|
|
|
<td><?php echo $address_one;?></td>
|
|
<td><?php echo $telephone_one;?></td>
|
|
<td><?php echo $email_id_one;?></td>
|
|
<td><?php echo $address_two;?></td>
|
|
<td><?php echo $telephone_two;?></td>
|
|
<td><?php echo $email_id_two;?></td>
|
|
|
|
|
|
<td><?php echo $product_name;?></td>
|
|
<td><?php echo $product_code;?></td>
|
|
|
|
|
|
<td><?php echo $applicant_verification;?></td>
|
|
<td><?php echo $date_of_unit_establishment;?></td>
|
|
<td><?php echo $area_of_establishment;?></td>
|
|
<td><?php echo $age_of_building;?></td>
|
|
<td><?php echo $protection_act;?></td>
|
|
<td> <?php echo $sufficient_space;?></td>
|
|
<td><?php echo $building_bye_laws;?></td>
|
|
<td><?php echo $article_verification;?></td>
|
|
|
|
|
|
<td><?php echo $proof_of_legal_occupancy;?></td>
|
|
<td><?php echo $identity_residence_proof;?></td>
|
|
<td><?php echo $sketch_map;?></td>
|
|
<td><?php echo $proof_of_payment;?></td>
|
|
<td><?php echo $proof_date_commencement;?></td>
|
|
<td><?php echo $structural_safety_certificate;?></td>
|
|
<td><?php echo $pollution_noc;?></td>
|
|
<td><?php echo $fire_safety_certificate;?></td>
|
|
<td><?php echo $name_of_partners;?></td>
|
|
|
|
<td><?php echo $checkNo;?></td>
|
|
<td><?php echo $receiptNo;?></td>
|
|
<td><?php echo $checkDate;?></td>
|
|
<td><?php echo $amount;?></td>
|
|
<td><?php echo $bankName;?></td>
|
|
<td><?php echo $bankBranch;?></td>
|
|
<td><?php echo $registrationFees?></td>
|
|
<td><?php echo $previousYear;?></td>
|
|
<td><?php echo $licenseAmount;?></td>
|
|
<td><?php echo $advanceAmount;?></td>
|
|
|
|
<td><?php echo $pf_checkNo;?></td>
|
|
<td><?php echo $pf_receiptNo;?></td>
|
|
<td><?php echo $pf_checkDate;?></td>
|
|
<td><?php echo $pf_amount;?></td>
|
|
<td><?php echo $pf_bankName;?></td>
|
|
<td><?php echo $pf_bankBranch;?></td>
|
|
|
|
|
|
</tr>
|
|
<?php }?>
|
|
|
|
</table>
|
|
</body>
|
|
</html>
|