File manager - Edit - /home/autoph/public_html/connectv1/include/components/reports/generate_report.php
Back
<!-- BODY --> <input type="hidden" name="report-type" id="report-type" value="<?php echo $report_type; ?>" readonly /> <label class="dropdown mx-0 my-0">Sort and Order</label> <div class="col-sm-6 "> <div class="row mb-1 border rounded pb-2 pt-2 "> <div class="col-sm-6 "> <div class="form-group my-0 mx-0 "> <div class="form-group dropdown-input mb-1"> <select name="sort-by" id="sort-by" class="form-control form-control-sm report-field " style="width: 100%;"> <option value="1" selected>Lastname (Individual)</option> <option value="2">Firstname (Individual)</option> <option value="3">Name (Corporation)</option> <option value="4">Date Created</option> <option value="5">Date Uploaded</option> </select> </div> <!--form-group dropdown--> </div> <!--form-group--> </div> <!--col-sm-3--> <div class="col-sm-3 mt-1 "> <!-- text input --> <div class="form-group my-0 mx-0 "> <div class="custom-control custom-radio ml-0"> <input class="custom-control-input " type="radio" id="rdo-asc" value="ASC" name="order"> <label for="rdo-asc" class="custom-control-label">Ascending</label> </div> </div> <!--form-group--> </div> <!--col-sm-3--> <div class="col-sm-3 mt-1"> <!-- text input --> <div class="form-group my-0 mx-0"> <div class="custom-control custom-radio ml-0"> <input class="custom-control-input" type="radio" id="rdo-desc" value="DESC" name="order"> <label for="rdo-desc" class="custom-control-label">Descending</label> </div> </div> <!--form-group--> </div> <!--col-sm-3--> </div> <!-- row --> </div> <!-- cols --> <label class="dropdown mx-0 my-0">Report Manager</label> <div class="col-sm-6 mb-3" > <div class="row mb-1 border rounded pb-2 pt-2"> <div class="col-sm-6 mt-1 "> <!-- text input --> <div class="form-group my-0 mx-0 "> <div class="custom-control custom-radio ml-0"> <input class="custom-control-input " type="radio" id="rdo-dl-yes" value="1" name="downloadable"> <label for="rdo-dl-yes" class="custom-control-label">Downloadable</label> </div> </div> <!--form-group--> </div> <!--col-sm-3--> <div class="col-sm-6 mt-1"> <!-- text input --> <div class="form-group my-0 mx-0"> <div class="custom-control custom-radio ml-0"> <input class="custom-control-input" type="radio" id="rdo-dl-no" value="0" name="downloadable"> <label for="rdo-dl-no" class="custom-control-label">Read-only</label> </div> </div> <!--form-group--> </div> <!--col-sm-3--> </div> <!-- row --> </div> <div class="row"> <div class="col-sm-3 "> <div class="form-group my-0 mx-0 "> <div class="form-group dropdown-input mb-1"> <label class="dropdown mx-0 my-0">Date Created From<span class="required-symbol" style="color:red;" hidden>*</span></label> <div class="input-group date" id="reg-from-date" data-target-input="nearest"> <input autocomplete="off" name="reg-from" id="reg-from" data-inputmask-alias="datetime" data-inputmask-inputformat="mm/dd/yyyy" data-mask type="text" class="form-control form-control-sm report-field datetimepicker-input" data-target="#reg-from-date" /> <div class="input-group-append" data-target="#reg-from-date" data-toggle="datetimepicker"> <div class="input-group-text"><i class="fa fa-calendar"></i></div> </div> </div> </div> </div> </div> <div class="col-sm-3"> <div class="form-group my-0 mx-0"> <div class="form-group dropdown-input mb-1"> <label class="dropdown mx-0 my-0">Date Created To<span class="required-symbol" style="color:red;" hidden>*</span></label> <div class="input-group date" id="reg-to-date" data-target-input="nearest"> <input name="reg-to" id="reg-to" autocomplete="off" data-inputmask-alias="datetime" data-inputmask-inputformat="mm/dd/yyyy" data-mask type="text" class="form-control form-control-sm report-field datetimepicker-input" data-target="#reg-to-date" /> <div class="input-group-append" data-target="#reg-to-date" data-toggle="datetimepicker"> <div class="input-group-text"><i class="fa fa-calendar"></i></div> </div> </div> </div> </div> </div> </div> <!--row--> <div class="row"> <div class="col-sm-3"> <!-- text input --> <div class="form-group my-0 mx-0"> <div class="form-group dropdown-input mb-1"> <label class="dropdown mx-0 my-0">DMS</label> <select name="dms" id="dms" class="form-control form-control-sm report-field " style="width: 100%;"> <option value="0" selected>All</option> <?php $company = $db -> return_result("SELECT sd.`id`, sd.`name` FROM `source_dms` sd INNER JOIN source_company sc ON sd.id = sc.dms_id WHERE sd.status = 1 AND sc.id IN (".$granted_company_ids.") GROUP BY sd.id ORDER BY sd.name ASC "); foreach($company as $data){ echo "<option value='{$data['id']}' >".$data['name']."</option>"; } ?> </select> </div> <!--form-group dropdown--> </div> <!--form-group--> </div> <!--col-sm-3--> <div class="col-sm-3"> <div class="form-group my-0 mx-0"> <div class="form-group dropdown-input mb-1"> <label class="dropdown mx-0 my-0">Company</label> <select name="company" id="company" class="form-control form-control-sm report-field select4" style="width: 100%;"> <option value="0" selected> All</option> <?php $company = $db -> return_result("SELECT `id`, `code`,`name` FROM `source_company` WHERE status = 1 AND id IN (".$granted_company_ids.") ORDER BY code ASC"); foreach($company as $data){ echo "<option value='{$data['id']}' >".strtoupper($data['code'].' - '.$data['name'])."</option>"; } ?> </select> </div> </div> </div> <div class="col-sm-3"> <div class="form-group my-0 mx-0"> <div class="form-group dropdown-input mb-1"> <label class="dropdown mx-0 my-0">Dealer</label> <select name="dealer" id="dealer" class="form-control form-control-sm report-field select5" style="width: 100%;"> <option value="0" selected> All</option> <!-- <?php $company = $db -> return_result("SELECT sc.id,sc.name FROM `source_dealer` sc INNER JOIN source_company_dealer scd ON sc.id = scd.dealer_id WHERE type = 1 AND sc.status = 1 GROUP BY sc.id ORDER BY sc.name ASC"); foreach($company as $data){ echo "<option value='{$data['id']}'>".$data['name']."</option>"; } ?> --> </select> </div> </div> </div> </div> <div class="row"> <div class="col-sm-3"> <div class="form-group my-0 mx-0"> <div class="form-group dropdown-input mb-1"> <label class="dropdown mx-0 my-0">Customer Type</label> <select name="type" id="type" class="form-control form-control-sm report-field " style="width: 100%;"> <option value="0" selected>All</option> <option value="1">Individual</option> <option value="2">Corporation</option> </select> </div> </div> </div> <div class="col-sm-3"> <div class="form-group my-0 mx-0"> <div class="form-group dropdown-input mb-1"> <label class="dropdown mx-0 my-0">Customer Category</label> <select name="category" id="category" class="form-control form-control-sm report-field " style="width: 100%;"> <option value="0" selected>All</option> <?php $categories = $db -> return_result("SELECT * FROM `customer_category` WHERE 1 AND id != 0 ORDER BY id ASC"); //print_r($clients); foreach($categories as $category){ echo "<option value='{$category['id']}'>".$category['name']."</option>"; } ?> <!-- <option value="SVO">SVO</option> <option value="SAO">SAO</option> <option value="LYL">LYL</option> <option value="SLY">SLY</option> <option value="VIP">VIP</option> <option value="VVIP">VVIP</option> --> <!-- <option value="VVIP" >VVIP</option> --> </select> </div> </div> </div> <div class="col-sm-3"> <div class="form-group my-0 mx-0"> <div class="form-group dropdown-input mb-1"> <label class="dropdown mx-0 my-0">Customer Status</label> <select name="active-status" id="active-status" class="form-control form-control-sm report-field " style="width: 100%;"> <option value="0" selected>All</option> <option value="1">Active</option> <option value="2">Inactive</option> </select> </div> </div> </div> <div class="col-sm-3" <?php echo ($report_type == 1 || $report_type == 2 || $report_type == 3 || $report_type == 4) ? "" : "style=display:;" ;?> id="filter-data-area"> <div class="form-group my-0 mx-0"> <div class="form-group dropdown-input mb-1"> <label class="dropdown mx-0 my-0">Customer Data</label> <select name="filter-data" id="filter-data" class="form-control form-control-sm report-field " style="width: 100%;"> <option value="0" selected> Disable</option> <?php $filter_data_menu = array("Complete Data","Incomplete Data","No Address","No Gender","No Date of birth"); foreach($filter_data_menu as $menu){ echo "<option value='$menu'>$menu</option>"; } ?> </select> </div> </div> </div> </div> <div class="row"> <div class="col-sm-3"> <div class="form-group my-0 mx-0"> <div class="form-group dropdown-input mb-1"> <label class="dropdown mx-0 my-0">Gender</label> <select name="gender" id="gender" class="form-control form-control-sm report-field " style="width: 100%;"> <option value="0" selected>All</option> <?php // $gender = $db -> return_result("SELECT `id`, `gender_name` FROM `all_gender` WHERE `status` = 1 ORDER by `gender_name` DESC"); //print_r($clients); $gender = $db -> return_result("SELECT `id`, `gender_name` FROM `all_gender` WHERE `status` = 1 ORDER by `gender_name` DESC"); //print_r($clients); foreach($gender as $data){ echo "<option value='{$data['id']}'>".$data['gender_name']."</option>"; } ?> </select> </div> <!--form-group dropdown--> </div> <!--form-group--> </div> <!--col-sm-3--> <div class="col-sm-3"> <div class="form-group my-0 mx-0"> <div class="form-group dropdown-input mb-1"> <label class="dropdown mx-0 my-0">Date of Birth</label> <div class="input-group date" id="date-of-birth-div" data-target-input="nearest"> <input autocomplete="off" name="date-of-birth" id="date-of-birth" data-inputmask-alias="datetime" data-inputmask-inputformat="mm/dd/yyyy" data-mask type="text" class="form-control form-control-sm report-field datetimepicker-input" data-target="#date-of-birth-div" /> <div class="input-group-append" data-target="#date-of-birth-div" data-toggle="datetimepicker"> <div class="input-group-text"><i class="fa fa-calendar"></i></div> </div> </div> </div> </div> </div> <div class="col-sm-3"> <div class="form-group my-0 mx-0"> <div class="form-group dropdown-input mb-1"> <label class="dropdown mx-0 my-0">Age from</label> <input type="number" name="age-from" id="age-from" class="form-control form-control-sm report-field" placeholder="" maxlength="15"> </div> </div> </div> <div class="col-sm-3"> <div class="form-group my-0 mx-0"> <div class="form-group dropdown-input mb-1"> <label class="dropdown mx-0 my-0">Age to</label> <input type="number" name="age-to" id="age-to" class="form-control form-control-sm report-field" placeholder="" maxlength="15"> </div> </div> </div> </div> <!--row--> <div class="row"> <div class="col-sm-3" <?php echo ($report_type == 2 || $report_type == 3 || $report_type == 4) ? "" : "style=display:;" ;?> id="brand-area"> <div class="form-group my-0 mx-0"> <div class="form-group dropdown-input mb-1"> <label class="dropdown mx-0 my-0">Brand</label> <select name="brand" id="brand" class="form-control form-control-sm report-field select3" style="width: 100%;"> <option value="0" selected> All</option> <?php $categories = $db -> return_result("SELECT id,name FROM `source_brand` WHERE 1 AND status = 1 ORDER BY name ASC"); //print_r($clients); foreach($categories as $category){ echo "<option value='{$category['id']}'>".$category['name']."</option>"; } ?> <?php // $token_key = '1024241010244'; // $data = get_content('http://www.autohub.ph/connect/LOAD_BRANDS.php?requestKey='.$token_key.''); // // if($data === FALSE) { // // $return_arr["status"]=0; // // $return_arr["message"]=" Error has occurred. Try again."; // // echo json_encode($return_arr); // // exit; // // } // // if((substr($data, 0, 1) === '[') && substr($data, strlen($data) -1 , strlen($data)) === ']'){ // // $data = substr($data, 1, -1); // // } // // echo $data;exit; // $decodedData = json_decode($data,true); // // echo $decodedData[0]['b_name'];exit; // // print_r($decodedData); // // // $company = $db -> return_result("SELECT `id`, `name` FROM `source_brand` WHERE `status` = 1 ORDER BY name ASC"); // foreach($decodedData as $data){ // echo "<option value='{$data['b_name']}'>".$data['b_name']."</option>"; // } // function get_content($URL){ // $ch = curl_init(); // curl_setopt($ch, CURLOPT_RETURNTRANSFER, true); // curl_setopt($ch, CURLOPT_URL, $URL); // $data = curl_exec($ch); // curl_close($ch); // return $data; // } ?> </select> </div> </div> </div> <div class="col-sm-3" <?php echo ($report_type == 2 || $report_type == 3 || $report_type == 4) ? "" : "style=display:;" ;?> id="model-area"> <div class="form-group my-0 mx-0"> <div class="form-group dropdown-input mb-1"> <label class="dropdown mx-0 my-0">Model</label> <select name="model" id="model" class="form-control form-control-sm report-field select3" style="width: 100%;"> <option value="0" selected> All</option> <?php // $company = $db -> return_result("SELECT `id`, `name` FROM `source_car_model` WHERE `status` = 1 ORDER BY name ASC"); // foreach($company as $data){ // echo "<option value='{$data['id']}'>".$data['name']."</option>"; // } ?> </select> </div> </div> </div> </div> <div class="row"> <div class="col-sm-3"> <div class="form-group my-0 mx-0"> <div class="form-group dropdown-input mb-1"> <label class="dropdown mx-0 my-0">Insurance Company</label> <select name="insurance-company" id="insurance-company" class="form-control form-control-sm report-field select6" style="width: 100%;"> <option value="0" selected> All</option> <?php $insurance_company = $db -> return_result("SELECT id,name FROM `source_insurance_company` WHERE id <> 0 AND status = 1 GROUP BY id ORDER BY name ASC "); foreach($insurance_company as $data){ echo "<option value='{$data['id']}'>".$data['name']."</option>"; } ?> </select> </div> </div> </div> <div class="col-sm-3"> <div class="form-group my-0 mx-0"> <div class="form-group dropdown-input mb-1"> <label class="dropdown mx-0 my-0">Insurance Type</label> <select name="insurance-type" id="insurance-type" class="form-control form-control-sm report-field select7" style="width: 100%;"> <option value="0" selected> All</option> <?php $insurance_company = $db -> return_result("SELECT id,name FROM `source_insurance_type` WHERE id <> 0 AND status = 1 GROUP BY id ORDER BY name ASC "); foreach($insurance_company as $data){ echo "<option value='{$data['id']}'>".$data['name']."</option>"; } ?> </select> </div> </div> </div> <div class="col-sm-3"> <div class="form-group my-0 mx-0"> <div class="form-group dropdown-input mb-1"> <label class="dropdown mx-0 my-0">Financing Company</label> <select name="finance-company" id="finance-company" class="form-control form-control-sm report-field select8" style="width: 100%;"> <option value="0" selected> All</option> <?php $insurance_company = $db -> return_result("SELECT id,name FROM `source_finance_company` WHERE id <> 0 AND status = 1 GROUP BY id ORDER BY name ASC "); foreach($insurance_company as $data){ echo "<option value='{$data['id']}'>".$data['name']."</option>"; } ?> </select> </div> </div> </div> </div> <div class="row"> <div class="col-sm-3"> <div class="form-group my-0 mx-0"> <div class="form-group dropdown-input mb-1"> <label class="dropdown mx-0 my-0">State</label> <select name="state" id="state" class="form-control form-control-sm report-field select3" style="width: 100%;"> <option value="0" selected>All</option> <?php $state = $db -> return_result("SELECT `provCode`,`provDesc` FROM `all_state` WHERE id != '0' ORDER by provDesc ASC"); //print_r($clients); foreach($state as $data){ echo "<option value='{$data['provCode']}'>".$data['provDesc']."</option>"; } ?> </select> </div> </div> </div> <div class="col-sm-3"> <div class="form-group my-0 mx-0"> <div class="form-group dropdown-input mb-1"> <label class="dropdown mx-0 my-0">City</label> <select name="city" id="city" class="form-control form-control-sm report-field select3" style="width: 100%;"> <option value="0" selected>All</option> </select> </div> </div> </div> <!-- </div> /.row <div class="row"> --> </div> <!--row--> <div class="row"> <div class="col-sm-3"> <div class="form-group my-0 mx-0"> <div class="form-group dropdown-input mb-1"> <label class="dropdown mx-0 my-0">Date Uploaded From</label> <div class="input-group date" id="upload-from-date" data-target-input="nearest"> <input autocomplete="off" name="upload-from" id="upload-from" data-inputmask-alias="datetime" data-inputmask-inputformat="mm/dd/yyyy" data-mask type="text" class="form-control form-control-sm report-field datetimepicker-input" data-target="#upload-from-date" /> <div class="input-group-append" data-target="#upload-from-date" data-toggle="datetimepicker"> <div class="input-group-text"><i class="fa fa-calendar"></i></div> </div> </div> </div> </div> </div> <div class="col-sm-3"> <div class="form-group my-0 mx-0"> <div class="form-group dropdown-input mb-1"> <label class="dropdown mx-0 my-0">Date Uploaded To</label> <div class="input-group date" id="upload-to-date" data-target-input="nearest"> <input name="upload-to" id="upload-to" autocomplete="off" data-inputmask-alias="datetime" data-inputmask-inputformat="mm/dd/yyyy" data-mask type="text" class="form-control form-control-sm report-field datetimepicker-input" data-target="#upload-to-date" /> <div class="input-group-append" data-target="#upload-to-date" data-toggle="datetimepicker"> <div class="input-group-text"><i class="fa fa-calendar"></i></div> </div> </div> </div> </div> </div> </div> <div class="row"> <div class="col-sm-6"> <div class="form-group my-0 mx-0"> <div class="form-group dropdown-input mb-1"> <label class="dropdown mx-0 my-0">Uploaded By</label> <select name="upload-by" id="upload-by" class="form-control form-control-sm report-field upload-by" style="width: 100%;"></select> </div> </div> </div> </div> <input type="hidden" name="uploaded-by" id="uploaded-by" value="" readonly /> <div class="row"> <div class="col"> <div class="form-group my-0 mx-0"> <div class="form-group dropdown-input mb-1"> <label class="dropdown mx-0 my-0">Report Description</label> <textarea row="2" class="form-control form-control-sm report-field" rows=2 placeholder="" id="report-description" name="report-description"></textarea> </div> </div> </div> </div> <!-- <div class="col-12 mt-3"> <input type="submit" name="submit" id="submit" value="Request Report" class="btn btn-success float-right"> </div> -->
| ver. 1.4 |
.
| PHP 7.3.33 | Generation time: 0 |
proxy
|
phpinfo
|
Settings