<tr>
<td><strong>Date:</strong></td>
<td><strong>Broker/Truck:</strong></td>
<td><strong>Driver:</strong></td>
<td><strong>Start:</strong></td>
<td><strong>Finish:</strong></td>
<td><strong>Registered:</strong></td>
<td><strong>Miles:</strong></td>
</tr>
<tr class='bg'>
<td><?php
echo createInputText('newFuelLoadDate', '', "size='6px' tabindex='1'");
?>
</td>
<td><?php
echo arrayToSelect(brokersArray($conexion), '0', 'newFuelLoadBroker', "Broker", false, "tabindex='2'");
?>
</td>
<td><?php
echo createInputText('newFuelLoadDriver', '', "size='6px' tabindex='4'");
?>
</td>
<td><?php
echo createInputText('newFuelLoadStart', '', "size='6px' tabindex='5'");
?>
</td>
<td><?php
echo createInputText('newFuelLoadFinish', '', "size='6px' tabindex='6'");
?>
</td>
<td><?php
echo createCheckbox('c_checkDate', 'Date', 'customerSuperCheckDate', 'headerName="Date" varType="date"');
?>
<br/>
<?php
echo createCheckbox('c_checkCredit', 'Credit', 'checkCredit', 'headerName="Credit" varType="double"');
?>
<br/>
</td>
</tr>
<tr class='bg'>
<td> <?php
echo createInputText('searchSuperCheckId', '', "size='10px'");
?>
</td>
<td> <?php
echo arrayToSelect(customersArray($conexion), 0, 'searchSuperCheckCustomer', 'Customer');
?>
</td>
<td> <?php
echo createInputText('searchSuperCheckNumber', '', "size='10px'");
?>
</td>
<td></td>
</tr>
<tr>
<td>After Date:</td>
<td>Before Date:</td>
<td></td>
<td></td>
</tr>
<tr class='bg'>
echo createFormRow('State', $flag ? 'class="bg"' : '', false, createStateSelect($conexion, 'editDriverAddressState', $driverInfo['addressState']));
$flag = !$flag;
echo createFormRowTextField('Zip', 'editDriverAddressZip', $flag ? 'class="bg"' : '', false, "size='10px' value='" . $driverInfo['addressZip'] . "'");
$flag = !$flag;
echo createFormRowTextField('P.O.Box', 'editDriverAddressBox', $flag ? 'class="bg"' : '', false, "size='10px' value='" . $driverInfo['addressPOBox'] . "'");
$flag = !$flag;
//
echo createFormRow('Payment Terms', $flag ? 'class="bg"' : '', true, createTermSelect($conexion, 'editDriverTermId', $driverInfo['termId']));
$flag = !$flag;
echo createFormRowTextField('Percentage', 'editDriverPercentage', $flag ? 'class="bg"' : '', true, "size='10px' value='" . $driverInfo['driverPercentage'] . "'");
$flag = !$flag;
echo createFormRowTextField('Driver Start Date', 'editDriverStartDate', $flag ? 'class="bg"' : '', false, "size='10px' value='" . to_MDY($driverInfo['driverStartDate']) . "'");
$flag = !$flag;
echo createFormRow('Gender', $flag ? 'class="bg"' : '', true, arrayToSelect(array("0" => "--Select Gender--", "male" => "Male", "female" => "Female"), $driverInfo['driverGender'], 'editDriverGender', 'Gender', true));
$flag = !$flag;
echo createFormRow('Ethnicity', $flag ? 'class="bg"' : '', true, createEthnicitySelect($conexion, 'editDriverEthnicId', $driverInfo['ethnicId']));
$flag = !$flag;
echo createFormRow('Class', $flag ? 'class="bg"' : '', true, arrayToSelect(array("--Select Class--", "Class 1", "Class 2", "Class 3", "Class 4"), $driverInfo['driverClass'], 'editDriverClass', 'Class', true));
$flag = !$flag;
?>
</table>
<table>
<tr>
<td><?php
echo createSimpleButton('submitEditDriverButton', 'Submit');
?>
</td>
</tr>
</table>
</div>
dataArray['state'] = getVal('newEstimateAddressState');
dataArray['zip'] = getVal('newEstimateAddressZip');
dataArray['box'] = getVal('newEstimateAddressBox');
return arrayToDataString(dataArray);
}
</script>
<div id="center-column">
<div class="table">
<table class="listing form" cellpadding="0" cellspacing="0">
<tr>
<th class="full" colspan="2">New Estimate</th>
</tr>
<?php
$flag = true;
echo createFormRow('Customer', $flag ? 'class="bg"' : '', true, arrayToSelect(customersArray($conexion), 0, 'newEstimateCustomer', 'Customer'));
$flag = !$flag;
echo createFormRowTextField("Name", 'newEstimateName', $flag ? 'class="bg"' : '', true, 'size=25px');
$flag = !$flag;
echo createFormRowTextField('Address', 'newEstimateAddressLine1', $flag ? 'class="bg"' : '', false, 'size=25px');
$flag = !$flag;
echo createFormRowTextField('Address Line 2', 'newEstimateAddressLine2', $flag ? 'class="bg"' : '', false, 'size=25px');
$flag = !$flag;
echo createFormRowTextField('City', 'newEstimateAddressCity', $flag ? 'class="bg"' : '', false, 'size=25px');
$flag = !$flag;
echo createFormRow('State', $flag ? 'class="bg"' : '', false, createStateSelect($conexion, 'newEstimateAddressState'));
$flag = !$flag;
echo createFormRowTextField('Zip', 'newEstimateAddressZip', $flag ? 'class="bg"' : '', false, 'size=25px');
$flag = !$flag;
echo createFormRowTextField('P.O.Box', 'newEstimateAddressBox', $flag ? 'class="bg"' : '', false, 'size=25px');
$flag = !$flag;
</tr>
<tr class='bg'>
<td rowspan='2'><?php
echo arrayToSelect(array("Projects", "Estimates"), 0, 'projectType', '', true);
?>
</td>
<td><?php
echo arrayToSelect(customersArray($conexion), 0, 'pathFinderCustomerId', 'Customer');
?>
</td>
<td rowspan='2'><?php
echo createInputText('additionalDumptime', '', "size='4px'");
?>
</td>
<td rowspan='2'><?php
echo arrayToSelect(materialsArray($conexion), "0", 'pathFinderMaterialId', 'Material', false);
?>
</td>
<td rowspan='2'><input type="checkbox" id="byLoad" name="byLoad" /><label for="byLoad" >By Load</label></td>
<td rowspan='2'><?php
echo createSimpleButton('searchButton', 'Search', '');
?>
</td>
</tr>
<tr>
<td><?php
echo emptySelect("pathFinderProjectId", "Project/Estimate");
?>
</td>
</tr>
<?php
echo createCheckbox('c_fuelLoadRegistered', 'Registered', 'fuelLoadRegistered', 'headerName="Registered" varType="string"');
?>
<br/>
<?php
echo createCheckbox('c_fuelLoadMileage', 'Mileage', 'fuelLoadMileage', 'headerName="Mileage" varType="string"');
?>
<br/>
</td>
</tr>
<tr class='bg'>
<td> <?php
echo createInputText('searchFuelLoadId', '', "size='10px'");
?>
</td>
<td> <?php
echo arrayToSelect(brokersArray($conexion), 0, 'searchFuelLoadBroker', 'Broker');
?>
</td>
<td> <?php
echo emptySelect('searchFuelLoadTruck', 'Truck');
?>
</td>
<td></td>
</tr>
<tr>
<td class='first'>After Date:</td>
<td class='first'>Before Date:</td>
<td class='first'></td>
<td></td>
</tr>
<tr class='bg'>
</tr>
<tr class='bg'>
<td><?php
echo arrayToSelect(customersArray($conexion), 0, 'customerId', 'Customer');
?>
</td>
<td rowspan='2'><?php
echo createInputText('startDate', '', "size='10px'");
?>
</td>
<td rowspan='2'><?php
echo createInputText('endDate', '', "size='10px'");
?>
</td>
<td rowspan='2'><?php
echo arrayToSelect(array("0" => "All", "1" => "Paid", "2" => "Unpaid"), "0", 'paid', 'Payment', true);
?>
</td>
<td rowspan='2'><?php
echo createSimpleButton('searchButton', 'Search', '');
?>
</td>
</tr>
<tr>
<td><?php
echo emptySelect("projectId", "Project");
?>
</td>
</tr>
<?php
?>
function createStateSelect($handler, $name = 'stateId', $selected = "0")
{
$stateArray = objectArray($handler, 'state', 'stateName asc', 'stateId', 'stateName');
return arrayToSelect($stateArray, $selected, $name, 'State');
}
`catId`,`catName`
FROM
`categories`
ORDER BY `catId` ASC
');
if ($getСatsList->num_rows) {
while ($result = $dbConnection->assoc($getСatsList)) {
$catsList[$result['catId']] = $result['catName'];
}
}
$catsListDisplay = arrayToSelect($catsList, 0, '<option value="0">Категория</option>', 'name="eventCatId"');
$getSubСatsList = $dbConnection->mq('
SELECT
`subCatId`,`subCatName`, `subCatCatId`
FROM
`subCategories`
ORDER BY `subCatId` ASC
');
if ($getSubСatsList->num_rows) {
while ($result = $dbConnection->assoc($getSubСatsList)) {
$subCatsList[$result['subCatCatId']][$result['subCatId']] = $result['subCatName'];
}
}
$subCatToUserSelect = $subCatsList;
foreach ($subCatsList as $key => $value) {
$subCatsList[$key] = arrayToSelect($subCatsList[$key], 0, '<option value="0">Подкатегория</option>', 'name="eventSubCatId"');
}
$subCatsList[0] = arrayToSelect(array(), 0, '<option value="0">Подкатегория</option>', 'name="eventSubCatId"');
$subCatsDisplay = arrayToSelect(array(), 0, '<option value="0">Подкатегория</option>', 'name="eventSubCatId"');
$subCatsJs = json_encode($subCatsList);
$eventsList = eventsCabinetEdit($userId, $dbConnection, $catsList, $subCatToUserSelect);
<tr>
<td class='first'>Gender:</td>
<td class='first'>Ethnicity:</td>
<td class='first'></td>
<td> <?php
echo createSimpleButton('printButton', 'Print');
?>
</td>
</tr>
<tr class='bg'>
<td><?php
echo arrayToSelect(array("0" => "Any", "male" => "Male", "female" => "Female"), "0", 'driverGender', 'Gender', true);
?>
</td>
<td><?php
echo arrayToSelect(ethnicsArray($conexion), 0, 'ethnicId', 'Ethnic');
?>
</td>
<td></td>
<td> <?php
echo createSimpleButton('searchButton', 'Search');
?>
</td>
</tr>
</table>
</div>
<div class='table' id='driversTable' ></div>
</div>
<?include_once '../news.php';?>
</div>
</script>
<div id="center-column">
<div class="table">
<table class="listing form" cellpadding="0" cellspacing="0">
<tr>
<th class="full" colspan="4">View Broker Balance</th>
</tr>
<tr>
<td><strong>Vendor:</strong><span style="color:red;">*</span></td>
<td><strong>Invoice #:</strong><span style="color:red;">*</span></td>
<td><strong>Date:</strong><span style="color:red;">*</span></td>
<td><strong>Amount:</strong><span style="color:red;">*</span></td>
</tr>
<tr class='bg'>
<td><?php
echo arrayToSelect(vendorsArray($conexion), 0, 'vendorId', 'Vendor');
?>
</td>
<td><?php
echo createInputText('invoiceNumber', '', "size='10px'");
?>
</td>
<td><?php
echo createInputText('invoiceDate', '', "size='10px'");
?>
</td>
<td><?php
echo createInputText('invoiceAmount', '', "size='10px'");
?>
</td>
</tr>
<?php
$flag = true;
echo createFormRow('Customer', $flag ? 'class="bg"' : '', true, arrayToSelect(customersArray($conexion), $customer, 'newItemCustomerId', 'Customer'));
$flag = !$flag;
if ($customer == 0) {
echo createFormRow('Project', $flag ? 'class="bg"' : '', true, emptySelect("newItemProjectId", "Project"));
} else {
echo createFormRow('Project', $flag ? 'class="bg"' : '', true, arrayToSelect(projectsArray($conexion, $customer), $project, "newItemProjectId", "Project"));
}
$flag = !$flag;
echo createFormRow('Supplier', $flag ? 'class="bg"' : '', true, arrayToSelect(suppliersArray($conexion), $supplier, 'newItemSupplierId', 'Supplier'));
$flag = !$flag;
if ($supplier == 0) {
echo createFormRow('Material', $flag ? 'class="bg"' : '', true, emptySelect("newItemMaterialId", "Material"));
} else {
echo createFormRow('Material', $flag ? 'class="bg"' : '', true, arrayToSelect(materialBySupplierArray($conexion, $supplier), $material, "newItemMaterialId", "Material"));
}
$flag = !$flag;
echo createFormRowTextField("From <img id='newItemReverse' src='/trucking/img/48.png' width='18px'/>", 'newItemFromDisplay', $flag ? 'class="bg"' : '', false, "size=25px value=\"{$displayFrom}\"");
$flag = !$flag;
echo createFormRowTextField('To', 'newItemToDisplay', $flag ? 'class="bg"' : '', false, "size=25px value=\"{$displayTo}\"");
$flag = !$flag;
echo createFormRowTextField('Material Price', 'newItemMaterialPrice', $flag ? 'class="bg"' : '', true, "size=10px value=\"{$materialPrice}\"");
$flag = !$flag;
echo createFormRowTextField('Broker Cost', 'newItemBrokerCost', $flag ? 'class="bg"' : '', true, 'size=10px');
$flag = !$flag;
echo createFormRowTextField('Customer Cost', 'newItemCustomerCost', $flag ? 'class="bg"' : '', true, 'size=10px');
$flag = !$flag;
echo createFormRow('Type', $flag ? 'class="bg"' : '', true, arrayToRadio(array("Loads", "Tons", "hours"), "0", "newItemType", ""));
$flag = !$flag;
echo createFormRow('Description', $flag ? 'class="bg"' : '', false, createInputTextArea('newItemDescription', '', 'rows="2" cols="43"'));
<form class="editSpot hide"> <input type="hidden" name="type" value="editSpot"> <input type="hidden" name="userId" value="<?php echo $companyInfo['companyId']; ?> "> <input type="hidden" name="spotId" value="<?php echo $spots[$i]['spotId']; ?> "> <input type="text" name = "spotName" placeholder = "Название" value="<?php echo htmlspecialchars($spots[$i]['spotName']); ?> "> <?php echo arrayToSelect($cities, $spots[$i]['spotCityId'], '<option value="0">Выберите город</option>', 'name="spotCityId"'); ?> <input type="text" name = "spotShopAddress" placeholder = "Адрес" value="<?php echo htmlspecialchars($spots[$i]['spotShopAddress']); ?> "> <input type="text" name = "spotCoords" placeholder = "Координаты точки" value="<?php echo htmlspecialchars($spots[$i]['spotCoords']); ?> "> <input type="text" name = "spotPhone" placeholder = "Телефон №1" value="<?php echo htmlspecialchars($spots[$i]['spotPhone']); ?> "> <input type="text" name = "spotPhone2" placeholder = "Телефон №2" value="<?php echo htmlspecialchars($spots[$i]['spotPhone2']);
}
//console.log(data);
return data;
}
</script>
<div id='formDiv' class='table'>
<img src="/mfi/img/bg-th-left.gif" width="8" height="7" alt="" class="left" />
<img src="/mfi/img/bg-th-right.gif" width="7" height="7" alt="" class="right" />
<table class="listing form" cellpadding="0" cellspacing="0">
<tr>
<th colspan='2'>Edit Broker</th>
</tr>
<?php
//Truck
$flag = true;
echo createFormRow('Broker', $flag ? 'class="bg"' : '', true, arrayToSelect(brokersArray($conexion), $truckInfo['brokerId'], 'editTruckBrokerId', 'Broker'));
$flag = !$flag;
echo createFormRowTextField('Truck Number', 'editTruckNumber', $flag ? 'class="bg"' : '', true, "size='10px' value='" . $truckInfo['truckNumber'] . "'");
$flag = !$flag;
echo createFormRowTextField('Driver', 'editTruckDriver', $flag ? 'class="bg"' : '', false, "size='10px' value='" . $truckInfo['truckDriver'] . "'");
$flag = !$flag;
echo createFormRowTextField('Plates', 'editTruckPlates', $flag ? 'class="bg"' : '', false, "size='10px' value='" . $truckInfo['truckPlates'] . "'");
$flag = !$flag;
echo createFormRowTextField('Truck Brand', 'editTruckBrand', $flag ? 'class="bg"' : '', false, "size='10px' value='" . $truckInfo['truckBrand'] . "'");
$flag = !$flag;
echo createFormRowTextField('Truck Year Model', 'editTruckYear', $flag ? 'class="bg"' : '', false, "size='10px' value='" . $truckInfo['truckYear'] . "'");
$flag = !$flag;
echo createFormRowTextField('Serial Number', 'editTruckSerial', $flag ? 'class="bg"' : '', false, "size='10px' value='" . $truckInfo['truckSerial'] . "'");
$flag = !$flag;
echo createFormRowTextField('Tire Size', 'editTruckTireSize', $flag ? 'class="bg"' : '', false, "size='10px' value='" . $truckInfo['truckTireSize'] . "'");
$flag = !$flag;
</td>
</tr>
<tr>
<td class='first'></td>
<td class='first'></td>
<td class='first'>Payment Method:</td>
<td> <?php
echo createSimpleButton('printButton', 'Print');
?>
</td>
</tr>
<tr class='bg'>
<td></td>
<td></td>
<td><?php
echo arrayToSelect(termsArray($conexion), 0, 'searchCustomerTerm', 'Payment');
?>
</td>
<td> <?php
echo createSimpleButton('searchButton', 'Search');
?>
</td>
</tr>
</table>
</div>
<div class='table' id='customersTable' ></div>
</div>
<?include_once '../news.php';?>
</div>
<?
echo createCheckbox('c_itemDescription', 'Description', 'itemDescription', 'headerName="Number" varType="string"');
?>
<br/>
</td>
</tr>
<tr class='bg'>
<td><?php
echo arrayToSelect(customersArray($conexion), 0, 'customerId', 'Customer');
?>
</td>
<td><?php
echo arrayToSelect(vendorsArray($conexion), 0, 'vendorId', 'Vendor');
?>
</td>
<td><?php
echo arrayToSelect(materialsArray($conexion), 0, 'materialId', 'Material');
?>
</td>
<td><?php
echo createInputText('searchProposalId', '', "size='6px'");
?>
</td>
</tr>
<tr>
<td class='first'>Project</td>
<td class='first'>Supplier</td>
<td></td>
<td><?php
echo createSimpleButton('exportButton', 'Export');
?>
</td>
<form class="editUserInfo hide"> <input type="hidden" value="<?php echo $key; ?> " name="userId"> <input type="hidden" value="adminUserbaseEdit" name="type"> <div class="info">Поднятий в категории</div> <input type="text" value="<?php echo $showUsers[$key]['companyUpInCategory']; ?> " name="companyUpInCategory"> <div class="info">Поднятий во всех категориях</div> <input type="text" value="<?php echo $showUsers[$key]['companyUpInAllCategories']; ?> " name="companyUpInAllCategories"> <?php echo arrayToSelect(array(1 => 'Пользователь', 'Администратор'), $showUsers[$key]['companyPrivs'], '', ' name="companyPrivs"'); ?> <div class="saveUser">Сохранить</div> </form>
</tr>
<tr>
<td><strong>Customer/Project/Item:</strong></td>
<td><strong>Broker/Truck/Driver:</strong></td>
<td><strong>Date:</strong></td>
<td><strong>MFI:</strong></td>
<td><strong>Dump/Material:</strong></td>
<td><strong>Amount/Broker Amount:</strong></td>
</tr>
<tr class='bg'>
<td><?php
echo arrayToSelect(customersArray($conexion), '0', 'newTicketCustomer', "Customer", false, "tabindex='1'");
?>
</td>
<td><?php
echo arrayToSelect(brokersArray($conexion), '0', 'newTicketBroker', "Broker", false, "tabindex='4'");
?>
</td>
<td><?php
echo createInputText('newTicketDate', '', "size='6px' tabindex='7'");
?>
</td>
<td><?php
echo createInputText('newTicketMfi', '', "size='6px' tabindex='8'");
?>
</td>
<td><?php
echo createInputText('newTicketNumber', '', "size='6px' tabindex='9'");
?>
</td>
<td><?php
echo createSimpleButton('exportButton', 'Export');
?>
</td>
</tr>
<tr>
<td class='first'>Customer:</td>
<td class='first'>Contact:</td>
<td class='first'></td>
<td> <?php
echo createSimpleButton('printButton', 'Print');
?>
</td>
</tr>
<tr class='bg'>
<td><?php
echo arrayToSelect(customersArray($conexion), 0, 'searchProjectCustomer', 'Customer');
?>
</td>
<td><?php
echo emptySelect('searchProjectContact', 'Contact');
?>
</td>
<td></td>
<td> <?php
echo createSimpleButton('searchButton', 'Search');
?>
</td>
</tr>
</table>
</div>
echo createCheckbox('c_addressState', 'State', 'addressState', 'headerName="State" varType="string"');
?>
<br/>
<?php
echo createCheckbox('c_addressZip', 'Zip Code', 'addressZip', 'headerName="ZipCode" varType="string"');
?>
<br/>
</td>
</tr>
<tr class='bg'>
<td> <?php
echo createInputText('truckId', '', "size='10px'");
?>
</td>
<td> <?php
echo arrayToSelect(brokersArray($conexion), 0, 'brokerId', 'Broker');
?>
</td>
<td> <?php
echo createInputText('truckNumber', '', "size='10px'");
?>
</td>
<td> <?php
echo createInputText('truckBrand', '', "size='10px'");
?>
</td>
</tr>
<tr>
<td class='first'>City:</td>
<td class='first'>State:</td>
<td class='first'>Zip Code:</td>
dataArray['amount'] = getVal('newCustomerCheckAmount');
dataArray['date'] = evalDate(getVal('newCustomerCheckDate'));
return arrayToDataString(dataArray);
}
</script>
<div id="center-column">
<div class="table">
<table class="listing form" cellpadding="0" cellspacing="0">
<tr>
<th class="full" colspan="2">New Customer Check</th>
</tr>
<?php
$flag = true;
echo createFormRow('Customer', $flag ? 'class="bg"' : '', true, arrayToSelect(customersArray($conexion), isset($_GET['customerId']) ? $_GET['customerId'] : 0, 'newCustomerCheckCustomer', 'Customer'));
$flag = !$flag;
echo createFormRowTextField('Number', 'newCustomerCheckNumber', $flag ? 'class="bg"' : '', true, 'size=10px');
$flag = !$flag;
echo createFormRowTextField('Amount', 'newCustomerCheckAmount', $flag ? 'class="bg"' : '', true, 'size=10px');
$flag = !$flag;
echo createFormRowTextField('Date', 'newCustomerCheckDate', $flag ? 'class="bg"' : '', true, 'size=10px');
$flag = !$flag;
?>
</table>
<table>
<tr>
<td><?php
echo createSimpleButton('submitNewCustomerSuperCheck', 'Submit');
?>
</td>
<div class="table">
<table class="listing form" cellpadding="0" cellspacing="0">
<tr>
<th class="full" colspan="2">New Customer</th>
</tr>
<?php
$flag = true;
echo createFormRowTextField("Name", 'newCustomerName', $flag ? 'class="bg"' : '', true, 'size=25px');
$flag = !$flag;
echo createFormRowTextField('Tel', 'newCustomerTel', $flag ? 'class="bg"' : '', false, 'size=25px');
$flag = !$flag;
echo createFormRowTextField('Fax', 'newCustomerFax', $flag ? 'class="bg"' : '', false, 'size=25px');
$flag = !$flag;
echo createFormRowTextField('Website', 'newCustomerWebsite', $flag ? 'class="bg"' : '', false, 'size=25px');
$flag = !$flag;
echo createFormRow('Term', $flag ? 'class="bg"' : '', true, arrayToSelect(termsArray($conexion), 0, 'newCustomerTerm', 'Term'));
$flag = !$flag;
echo createFormRowTextField('Address', 'newCustomerAddressLine1', $flag ? 'class="bg"' : '', false, 'size=25px');
$flag = !$flag;
echo createFormRowTextField('Address Line 2', 'newCustomerAddressLine2', $flag ? 'class="bg"' : '', false, 'size=25px');
$flag = !$flag;
echo createFormRowTextField('City', 'newCustomerAddressCity', $flag ? 'class="bg"' : '', false, 'size=25px');
$flag = !$flag;
echo createFormRow('State', $flag ? 'class="bg"' : '', false, createStateSelect($conexion, 'newCustomerAddressState'));
$flag = !$flag;
echo createFormRowTextField('Zip', 'newCustomerAddressZip', $flag ? 'class="bg"' : '', false, 'size=25px');
$flag = !$flag;
echo createFormRowTextField('P.O.Box', 'newCustomerAddressBox', $flag ? 'class="bg"' : '', false, 'size=25px');
$flag = !$flag;
?>
</table>
data += glue + key + "=" + dataArray[key];
glue = "&";
}
console.log(data);
return data;
}
</script>
<div id="center-column">
<div class="table">
<table class="listing form" cellpadding="0" cellspacing="0">
<tr>
<th class="full" colspan="2">New Truck</th>
</tr>
<?php
$flag = true;
echo createFormRow('Broker', $flag ? 'class="bg"' : '', true, arrayToSelect(brokersArray($conexion), isset($_GET['brokerId']) ? $_GET['brokerId'] : 0, 'brokerId', 'Broker'));
$flag = !$flag;
echo createFormRowTextField('Truck Number', 'truckNumber', $flag ? 'class="bg"' : '', true, 'size=10px');
$flag = !$flag;
echo createFormRowTextField('Driver', 'truckDriver', $flag ? 'class="bg"' : '', false, 'size=10px');
$flag = !$flag;
echo createFormRowTextField('Plates', 'truckPlates', $flag ? 'class="bg"' : '', false, 'size=10px');
$flag = !$flag;
echo createFormRowTextField('Truck Brand', 'truckBrand', $flag ? 'class="bg"' : '', false, 'size=10px');
$flag = !$flag;
echo createFormRowTextField('Truck Year Model', 'truckYear', $flag ? 'class="bg"' : '', false, 'size=10px');
$flag = !$flag;
echo createFormRowTextField('Serial Number', 'truckSerial', $flag ? 'class="bg"' : '', false, 'size=10px');
$flag = !$flag;
echo createFormRowTextField('Tire Size', 'truckTireSize', $flag ? 'class="bg"' : '', false, 'size=10px');
$flag = !$flag;
<td> <?php
echo createSimpleButton('printButton', 'Print');
?>
</td>
</tr>
<tr>
<td><?php
echo arrayToSelect(array("Any", "Invoiced", "Not Invoiced"), 0, 'inInvoice', 'Invoice', true);
?>
</td>
<td><?php
echo arrayToSelect(array("Any", "Invoiced", "Not Invoiced"), 0, 'inReport', 'Report', true);
?>
</td>
<td><?php
echo arrayToSelect(array("Any", "Invoiced", "Not Invoiced"), 0, 'inSupplierInvoice', 'Supplier Invoice', true);
?>
</td>
<td> <?php
echo createSimpleButton('searchButton', 'Search');
?>
</td>
</tr>
</table>
</div>
<div class='table' id='ticketsTable' ></div>
</div>
<?include_once '../news.php';?>
</div>
<?
dataArray['box'] = getVal('editSupplierAddressBox');
return arrayToDataString(dataArray);
}
</script>
<div id='formDiv' class='table'>
<img src="/mfi/img/bg-th-left.gif" width="8" height="7" alt="" class="left" />
<img src="/mfi/img/bg-th-right.gif" width="7" height="7" alt="" class="right" />
<table class="listing form" cellpadding="0" cellspacing="0">
<tr>
<th colspan='2'>Edit Supplier</th>
</tr>
<?php
//Supplier
$flag = true;
echo createFormRow('Vendor', $flag ? 'class="bg"' : '', true, arrayToSelect(vendorsArray($conexion), $supplierInfo['vendorId'], 'editSupplierVendor', 'Vendor'));
$flag = !$flag;
echo createFormRowTextField("Name", 'editSupplierName', $flag ? 'class="bg"' : '', true, "size=25px value='" . $supplierInfo['supplierName'] . "'");
$flag = !$flag;
echo createFormRowTextField('Tel', 'editSupplierTel', $flag ? 'class="bg"' : '', false, "size=25px value='" . showPhoneNumber($supplierInfo['supplierTel']) . "'");
$flag = !$flag;
echo createFormRowTextField('Fax', 'editSupplierFax', $flag ? 'class="bg"' : '', false, "size=25px value='" . showPhoneNumber($supplierInfo['supplierFax']) . "'");
$flag = !$flag;
//parking address
echo createFormRowTextField('Parking Address', 'editSupplierAddressLine1', $flag ? 'class="bg"' : '', false, "size='25px' value='" . $supplierInfo['addressLine1'] . "'");
$flag = !$flag;
echo createFormRowTextField('Address Line 2', 'editSupplierAddressLine2', $flag ? 'class="bg"' : '', false, "size='25px' value='" . $supplierInfo['addressLine2'] . "'");
$flag = !$flag;
echo createFormRowTextField('City', 'editSupplierAddressCity', $flag ? 'class="bg"' : '', false, "size='25px' value='" . $supplierInfo['addressCity'] . "'");
$flag = !$flag;
//state
echo createCheckbox('c_addressCity', 'City', 'addressCity', 'headerName="City" varType="string"');
?>
<br/>
<?php
echo createCheckbox('c_addressState', 'State', 'addressState', 'headerName="State" varType="string"');
?>
<br/>
<?php
echo createCheckbox('c_addressZip', 'Zip Code', 'addressZip', 'headerName="ZipCode" varType="string"');
?>
<br/>
</td>
</tr>
<tr class='bg'>
<td> <?php
echo arrayToSelect(customersArray($conexion), 0, 'customerId', 'Customer');
?>
</td>
<td> <?php
echo createInputText('searchEstimateId', '', "size='10px'");
?>
</td>
<td> <?php
echo createInputText('searchEstimateName', '', "size='10px'");
?>
</td>
<td> <?php
echo createInputText('addressLine1', '', "size='10px'");
?>
</td>
</tr>
<td class='first'>Ethnicity:</td>
<td class='first'></td>
<td> <?php
echo createSimpleButton('printButton', 'Print');
?>
</td>
</tr>
<tr class='bg'>
<td><?php
echo arrayToSelect(array("0" => "Any", "male" => "Male", "female" => "Female"), "0", 'gender', 'Gender', true);
?>
</td>
<td>
<?php
$ethnicArray = ethnicsArray($conexion);
echo arrayToSelect($ethnicArray, 0, 'ethnicId', 'Ethnic');
?>
</td>
<td></td>
<td> <?php
echo createSimpleButton('searchButton', 'Search');
?>
</td>
</tr>
</table>
</div>
<div class='table' id='brokersTable' ></div>
</div>
<?include_once '../news.php';?>
</div>
<td><?php
echo createSimpleButton('exportButton', 'Export');
?>
</td>
</tr>
<tr class='bg'>
<td> <?php
echo emptySelect("projectId", "Project");
?>
</td>
<td> <?php
echo emptySelect("supplierId", "Supplier");
?>
</td>
<td><?php
echo arrayToSelect(array("Loads", "Tons", "Hours", "Any"), 3, "searchItemType", "", true);
?>
</td>
<td><?php
echo createSimpleButton('printButton', 'Print');
?>
</td>
</tr>
<tr>
<td></td>
<td></td>
<td></td>
<td><?php
echo createSimpleButton('searchButton', 'Search');
?>
</td>
break;
}
} catch(e) {
alert("Internal Error: Please contact the administrator.");
}
},
async: true
});
}
</script>
<div id='formDiv' class='table'>
<img src="/mfi/img/bg-th-left.gif" width="8" height="7" alt="" class="left" />
<img src="/mfi/img/bg-th-right.gif" width="7" height="7" alt="" class="right" />
<table class="listing form" cellpadding="0" cellspacing="0">
<tr>
<th colspan='4'>Supplier Information</th>
</tr>
<?php
$flag = true;
//$vendorLink = printImgLink(IMG_VIEW, NYRO_CLASS, TITLE_VIEW_VENDOR, createGenericNyroableAttributesSmall($supplierInfo['vendorId'],'vendor'));
$materials = mysql_query("SELECT * FROM suppliermaterial JOIN material USING (materialId) WHERE supplierId = '{$supplierId}'", $conexion);
while ($material = mysql_fetch_assoc($materials)) {
$delImg = createActionIcon(IMG_DELETE, 'delete' . $supplierId . "-" . $material['materialId'], 'Delete Price', '../submit/deleteSupplierMaterial.php', 'supplier=' . $supplierId . '&material=' . $material['materialId'], 'delete', " width='22' height='22'");
echo printRow($flag ? "" : "class='bg'", array($material['materialName'], decimalPad($material['supplierMaterialPrice']), to_MDY($material['supplierMaterialLastModified']), $delImg));
$flag = !$flag;
}
echo printRow(" id='newPriceListItem' " . ($flag ? "" : "class='bg'"), array(arrayToSelect(materialsArray($conexion), '0', 'newPriceListMaterial', 'Material'), createInputText('newPriceListPrice', '', ''), '', createSimpleButton('saveNewPriceList', 'Submit')));
?>
</table>
</div>
function eventsCabinetEdit($userId, Mysql $mysql, $cats = array(), $subCats = array())
{
$getEvents = $mysql->mq('
SELECT
`companyId`,
`eventId`, `eventName`, `eventCode`, `eventInfo`, `eventCondition`,
`eventCatId`, `eventSubCatId`,
`eventOldPrice`, `eventSale`, `eventSaleText`,
`eventCatId`, `eventSubCatId`, `eventStartDate`, `eventEndDate`,
`eventStopped` ,`spotId`, `spotName`,
IF(`eventImage`="", "/img/addUserImage.jpg",`eventImage`) as `eventImage`,
`eventOldPrice` - (`eventOldPrice` * (`eventSale`/100)) as `eventNewPrice`,
IF(`eventEndDate` < NOW() OR `eventStopped` = 1 , "" , " active") as eventActivity,
IF(`companyUpInCategory`>0,"active","") as upInCategory,
IF(`companyUpInAllCategories`>0,"active","") as upInAllCategories,
`companyUpInCategory`, `companyUpInAllCategories`,
IF(`eventFreezeTime`>=NOW(),"active", "") as frozen
FROM
`event`
LEFT JOIN
`eventSpots`
ON
`eventId` = `eventSpotsEventId`
LEFT JOIN
`spots`
ON
`eventSpotsSpotId` = `spotId`
LEFT JOIN
`company`
ON
`companyId` = `eventCompanyId`
WHERE
`eventCompanyId` = ' . $userId . '
ORDER BY
`eventId` DESC
');
$ups = '';
$eventId = null;
$showEvents = [];
$spotsList = [];
$displayEvents = [];
$spotsNames = [];
$spotsToCheckbox = [];
$spotsIds = [];
$getSpotsList = $mysql->mq('
SELECT
`spotId`,`spotName`
FROM
`spots`
WHERE
`spotCompanyId` = ' . $userId . '
');
if ($getSpotsList->num_rows) {
while ($result = $mysql->assoc($getSpotsList)) {
$spotsList[$result['spotId']] = $result['spotName'];
}
}
if ($getEvents->num_rows) {
for ($i = 0; $result = $mysql->assoc($getEvents); $i++) {
if (!$eventId || $eventId != $result['eventId']) {
if (!is_null($eventId)) {
$showEvents[] = $result;
$eventId = $result['eventId'];
} else {
$showEvents[] = $result;
$eventId = $result['eventId'];
}
}
$spotsToCheckbox[$eventId][$result['spotId']] = $result['spotName'];
$spotsNames[$eventId][] = $result['spotName'];
$spotsIds[$eventId][] = $result['spotId'];
if ($i == 0) {
$ups = '<script>companyUpInCat=' . $result['companyUpInCategory'] . '; companyUpInAllCat=' . $result['companyUpInAllCategories'] . ';</script>';
}
}
}
ob_start();
echo '<div>';
for ($i = 0; $i < count($showEvents); $i++) {
$class = '';
$wrapper = '';
$showEvents[$i]['spotsName'] = implode(', ', $spotsNames[$showEvents[$i]['eventId']]);
$showEvents[$i]['spots'] = arrayToCheckbox($spotsList, $spotsIds[$showEvents[$i]['eventId']], ' class="checkboxLabel"', ' name="eventSpotsSpotId[]"');
$showEvents[$i]['cats'] = arrayToSelect($cats, $showEvents[$i]['eventCatId'], '<option value="0">Категория</option>', 'name="eventCatId"');
$showEvents[$i]['subCats'] = arrayToSelect($subCats[$showEvents[$i]['eventCatId']], $showEvents[$i]['eventSubCatId'], '<option value="0">Категория</option>', 'name="eventSubCatId"');
if ($i % 2 != 0) {
$class = 'second';
$wrapper = '<div class="clear"></div></div><div>';
}
require $_SERVER['DOCUMENT_ROOT'] . '/pagesTemplates/eventsEdit.php';
echo $wrapper;
}
echo '</div>';
return ob_get_clean() . $ups;
}