/
home
/
desid573
/
public_html
/
drivers
/
/home/desid573/public_html/drivers
mkdir
upload
Name
Size
Mode
Actions
training/
-
0755
rm
twilio-php-master/
-
0755
rm
avail.php
19359
0644
edit
dl
rm
cancel_booking.php
4537
0644
edit
dl
rm
checkDetails.php
1568
0644
edit
dl
rm
checkDetailsId.php
1774
0644
edit
dl
rm
cleaning_record.pdf
117117
0644
edit
dl
rm
contractor_conduct.pdf
110192
0644
edit
dl
rm
create.php
2610
0644
edit
dl
rm
createbilling.php
8952
0644
edit
dl
rm
createdriver.php
5278
0644
edit
dl
rm
createSMS.php
1844
0644
edit
dl
rm
daily.php
9342
0644
edit
dl
rm
default.php
16383
0644
edit
dl
rm
delete.php
935
0644
edit
dl
rm
deletedriver.php
3619
0644
edit
dl
rm
driverBilling.php
8378
0644
edit
dl
rm
driver_check_qld.php
3907
0644
edit
dl
rm
drugs_policy.pdf
78742
0644
edit
dl
rm
error_log
390475
0644
edit
dl
rm
getDailyAvailability.php
3065
0644
edit
dl
rm
getDefaultAvailability.php
1102
0644
edit
dl
rm
getDriverAvailability.php
1642
0644
edit
dl
rm
home.php
5517
0644
edit
dl
rm
incident.php
1871
0644
edit
dl
rm
incident_report.php
6179
0644
edit
dl
rm
index1.php
3937
0644
edit
dl
rm
licence_file_qld.php
1768
0644
edit
dl
rm
list.php
2046
0644
edit
dl
rm
login.php
7782
0644
edit
dl
rm
loginDriver.php
1214
0644
edit
dl
rm
medical.pdf
32899
0644
edit
dl
rm
new.php
835
0644
edit
dl
rm
off.php
3502
0644
edit
dl
rm
qld_report.php
1109
0644
edit
dl
rm
register.php
8676
0644
edit
dl
rm
setDefaultAvailability.php
3257
0644
edit
dl
rm
setDriverAvailability.php
3365
0644
edit
dl
rm
setDriverPin.php
2189
0644
edit
dl
rm
smsregister.php
1564
0644
edit
dl
rm
updateDetails.php
4527
0644
edit
dl
rm
updateDetailsDriver.php
5101
0644
edit
dl
rm
Edit:
/home/desid573/public_html/drivers/createbilling.php
(8952B)
<!DOCTYPE html> <html lang="en"> <head> <meta charset="utf-8"> <meta http-equiv="X-UA-Compatible" content="IE=edge"> <meta name="viewport" content="width=device-width, initial-scale=1"> <!-- The above 3 meta tags *must* come first in the head; any other head content must come *after* these tags --> <title>Create Driver Billing</title> <!-- Bootstrap --> <link href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.6/css/bootstrap.min.css" rel="stylesheet"> <!-- HTML5 shim and Respond.js for IE8 support of HTML5 elements and media queries --> <!-- WARNING: Respond.js doesn't work if you view the page via file:// --> <!--[if lt IE 9]> <script src="https://oss.maxcdn.com/html5shiv/3.7.2/html5shiv.min.js"></script> <script src="https://oss.maxcdn.com/respond/1.4.2/respond.min.js"></script> <![endif]--> <style> body{ background-color: #d9d9d9; } .bgloader { display: none; position: fixed; width: 100%; height: 100%; background-color:#f26f18; opacity : 0.4; z-index: 100; } .loader { display: none; position: fixed; left: 50%; top: 50%; z-index: 101; margin: -60px 0 0 -60px; border: 16px solid #f3f3f3; /* Light grey */ border-top: 16px solid #000080; /* Blue */ border-radius: 50%; width: 120px; height: 120px; animation: spin 2s linear infinite; } @keyframes spin { 0% { transform: rotate(0deg); } 100% { transform: rotate(360deg); } } </style> </head> <body> <div class="loader"></div> <div class="bgloader"></div> <div class="container"> <div class="row"> <div class="col-lg-12"> <? $dbhost = "localhost"; $dbuser = "desid573_inquiri"; $dbpass = "@G&{)0*&Ts^V"; $dbname = "desid573_inquiries"; $conn = new mysqli($dbhost, $dbuser, $dbpass, $dbname) or die($conn->connect_error); $qcon=mysqli_connect($dbhost, $dbuser, $dbpass, $dbname); $result = $conn->query("SELECT id, driver FROM desid573_eway_codes.drivers ORDER BY `driver`"); echo "<select id='driver_id' name='id'>"; echo "<option value='' selected hidden>Select Driver</option>"; while ($row = $result->fetch_assoc()) { unset($id, $name); $id = $row['id']; $name = $row['driver']; echo '<option value="'.$name.'">'.$name.'</option>'; } echo "</select>"; ?> <br> <label>Name</label> <input type="text" required data-validation="required" readonly class="form-control" placeholder="Driver Name" name="name" id="name" > </div> </div> <div class="row"> <div class="col-lg-12"> <label>ABN</label> <input type="text" required data-validation="required" class="form-control" placeholder="ABN" name="abn" id="abn" > </div> </div> <div class="row"> <div class="col-lg-12"> <label>Address Line 1</label> <input type="text" class="form-control" placeholder="Address Line 1 (eg 1 Smith St)" name="line1" id="line1" > </div> </div> <div class="row"> <div class="col-lg-12"> <label>Address Line 2</label> <input type="text" class="form-control" placeholder="Address Line 2 (eg Smithtown NSW 2000)" name="line2" id="line2" > </div> </div> <div class="row"> <div class="col-lg-12"> <label>Email</label> <input type="text" required data-validation="required" class="form-control" placeholder="Driver Email" name="email" id="email" > </div> </div> <div class="row"> <div class="col-lg-12"> <label>Drivers Licence No.</label> <input type="text" required data-validation="required" class="form-control" placeholder="Licence Number" name="licence" id="licence" > </div> </div> <div class="row"> <div class="col-lg-12"> <label>State Rideshare Driver Number (if applicable)</label> <input type="text" class="form-control" placeholder="eg. Driver Authorisation number" name="stateDriver" id="stateDriver" > </div> </div> <div class="row"> <div class="col-lg-12"> <label>Vehicle Registration</label> <input type="text" required data-validation="required" class="form-control" placeholder="Rego" name="registration" id="registration" > </div> </div> <div class="row"> <div class="col-lg-12"> <label>State Rideshare Vehicle Number (if applicable)</label> <input type="text" class="form-control" placeholder="eg. Booked hire service licence number" name="stateVehicle" id="stateVehicle" > </div> </div> <div class="row"> <div class="col-lg-12"> <label>BSB</label> <input type="text" required data-validation="required" class="form-control" placeholder="BSB (no spaces or dashes)" name="bsb" id="bsb" > </div> </div> <div class="row"> <div class="col-lg-12"> <label for="password">Account No</label> <input type="text" required data-validation="required" class="form-control" placeholder="Account No. (No spaces or dashes)" name="acc" id="acc" > </div> </div> <div class="row"> <div class="col-lg-12"> <label for="password">Commission</label> <select id="commission"> <option value="0.8">80%</option> <option value="0.85">85%</option> <option value="0.9">90%</option> </select> </div> </div> <br> <div class="row"> <div class="col-xs-12 no-padding"> <input type="button" name="button" class="btn-block btn btn-primary" id="button" value="Submit"> </div> </div> <div class="col-xs-12 no-padding" style="text-align:center"> </br> Result: <span style="color:#FF0000;font-size: 150%;text-align: center;" id="test"></span><br> </div> </div> <!-- jQuery (necessary for Bootstrap's JavaScript plugins) --> <script src="https://ajax.googleapis.com/ajax/libs/jquery/2.1.4/jquery.min.js"></script> <!-- Include all compiled plugins (below), or include individual files as needed --> <script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.6/js/bootstrap.min.js"></script> <script src="//cdnjs.cloudflare.com/ajax/libs/jquery-form-validator/2.3.23/jquery.form-validator.min.js"></script> <script type="text/javascript"> $(document).ready(function(){ }) $("#driver_id").on('change', function() { $(".loader, .bgloader").show(); var name = this.value var datastring = {name: name} $.ajax({ type: "POST", url:"checkDetails.php", data: datastring, dataType: 'json', success: function (data) { console.log(data); $(".loader, .bgloader").hide(); $("#name").val(name); $("#abn").val(data.abn); $("#line1").val(data.line1); $("#line2").val(data.line2); $("#email").val(data.email); $("#licence").val(data.licence); $("#stateDriver").val(data.stateDriver); $("#registration").val(data.registration); $("#stateVehicle").val(data.stateVehicle); // var option = '#commission option[value=' + data.comm + ']'; // console.log(option); // $(option).prop('selected', true); $("#commission").val(data.comm); } }) }) $("#button").click(function(){ $(".loader, .bgloader").show(); var name = $("#name").val(); var email = $("#email").val(); var licence = $("#licence").val(); var stateDriver = $("#stateDriver").val(); var registration = $("#registration").val(); var stateVehicle = $("#stateVehicle").val(); var abn = $("#abn").val(); var line1 = $("#line1").val(); var line2 = $("#line2").val(); var comm = $("#commission").val(); var bsb = $("#bsb").val(); var acc = $("#acc").val(); var datastring = {name: name, email: email, abn: abn, line1: line1, line2: line2, comm: comm, bsb: bsb, acc: acc, licence: licence, stateDriver: stateDriver, registration: registration, stateVehicle: stateVehicle}; console.log(datastring); $.ajax({ type: "POST", url:"updateDetails.php", data: datastring, dataType: 'json', success: function (data) { console.log(data); $(".loader, .bgloader").hide(); }, error: function (xhr, ajaxOptions, thrownError) { alert(xhr.status); alert(thrownError); $(".loader, .bgloader").hide(); } }) }) </script> </body> </html>
Save
Create Driver Billing
$dbhost = "localhost"; $dbuser = "desid573_inquiri"; $dbpass = "@G&{)0*&Ts^V"; $dbname = "desid573_inquiries"; $conn = new mysqli($dbhost, $dbuser, $dbpass, $dbname) or die($conn->connect_error); $qcon=mysqli_connect($dbhost, $dbuser, $dbpass, $dbname); $result = $conn->query("SELECT id, driver FROM desid573_eway_codes.drivers ORDER BY `driver`"); echo "
"; echo "
Select Driver
"; while ($row = $result->fetch_assoc()) { unset($id, $name); $id = $row['id']; $name = $row['driver']; echo '
'.$name.'
'; } echo "
"; ?>
Name
ABN
Address Line 1
Address Line 2
Email
Drivers Licence No.
State Rideshare Driver Number (if applicable)
Vehicle Registration
State Rideshare Vehicle Number (if applicable)
BSB
Account No
Commission
80%
85%
90%
Result: