<?php
    include_once('../config.php');
    date_default_timezone_set('Asia/Kolkata'); 
    $currentTime = date('d-m-Y H:i:s');
    $TodayDate = date('d-m-Y');
    // $beforeTime = date('d-m-Y H:i:s');
    // $sql ="SELECT * FROM msme_form WHERE payment_status = 'Unpaid'  AND  created_time < (NOW() - INTERVAL 5 MINUTE)ORDER BY id DESC LIMIT 10";
    $sql ="SELECT * FROM msme_form WHERE payment_status = 'Unpaid' AND form_created_date ='".$TodayDate."' ORDER BY id DESC LIMIT 10";
    $result = $conn->query($sql);
    while($row = $result->fetch_assoc()){
        $data = 
        [
            "id"                                =>                  $row['id'],
            "fname"                             =>                  $row["form_name"],
            "aname"                             =>                  $row['applicant_name'],
            "amob"                              =>                  $row['mobile_number'],
            "aemail"                            =>                  $row['email_id'],
            "office_address"                    =>                  $row['office_address'],
            "state"                             =>                  str_replace('_', ' ',$row['office_state']),
            "district"                          =>                  $row['office_district'],
            "pincode"                           =>                  $row['pincode'],
            "social_category"                   =>                  $row['social_category'],
            "uam_number"                        =>                  $row['uam_number'],
            "pan_card_number"                   =>                  $row['pan_card_number'],
            "bank_account_number"               =>                  $row['bank_account_numbe'],
            "ifsc_code"                         =>                  $row['ifsc_code'],
            "business_name"                     =>                  $row['business_name'],
            "date_of_commencement_of_business"  =>                  $row['date_of_commencement_of_business'],
            "type_of_organisation"              =>                  $row['type_of_organisation'],
            "main_business_activity_of_enterprise" =>               $row['main_business_activity_of_enterprise'],
            "additional_details_about_business"    =>               $row['additional_details_about_business'],
            "persons_employed_male"                =>               $row['persons_employed_male'],
            "persons_employed_female"              =>               $row['persons_employed_female'],
            "persons_employed_other"               =>               $row['persons_employed_other'],
            "persons_employed_total"               =>               $row['persons_employed_total'],
            "upload_aadhaar_card_front"            =>               $row['upload_aadhaar_card_front'],
            "upload_aadhaar_card_back"             =>               $row['upload_aadhaar_card_back'],
            "upload_pan_card_front"                =>               $row['upload_pan_card_front'],
            "total_amt"                            =>               $row['total_amount'],
            "payment_status"                       =>               'Pending',
            "order_id"                             =>               $row['order_id'],
            "payment_id"                           =>               $row['payment_id'],
            "gateway"                              =>               $row['c_gateway'],
            "merchant"                             =>               $row['c_gateway_merchant'],
            "created_at"                           =>               $row['form_created_on'],
            "payment_stage"                        =>               $row['payment_stage'],
            "fpage"                                  =>               'udyogaadhaar.net'
        ];
        $postArray[] = $data;
    }
   // echo $json = json_encode($postArray); 
?>