ManageVehicleRates

<?php

//page to find a voucher//
//require('checkPagePermissions.php');
//include('Menu.html');
$retString = "<table width=100% height=100%>";
$retString.= "<tr><td width=100% colspan=2 height=50 align=center><div id='getVehicleRatesFormdiv' name='getVehicleRatesFormdiv' align=center></div><div id='getVehicleRatesButtonsdiv' name='getVehicleRatesButtonsdiv' align=center></div></td></tr>";
$retString.= "<tr><td width=50% align=center><div id='VehicleRatesGriddiv' name='VehicleRatesGriddiv' align=center></div><div id='VehicleRatesGridButtonsdiv' name='VehicleRatesGridButtonsdiv' align=center></div></td>";
$retString.= "<td width=50% align=center><div id='UpdateVehicleRatesFormdiv2' name='UpdateVehicleRatesFormdiv2' align=center></div><div id='UpdateVehicleRatesButtonsdiv' name='UpdateVehicleRatesButtonsdiv' align=center></div></td></tr>";
$retString.="</table>";
//$retString.= "<script type='text/javascript' src='JSIncludes/ManageVehicleRates.js'></script>";
$retString.= "<script type='text/javascript' src='JSIncludes/helpFunction.js'></script>";
$retString.= "<script type='text/javascript' src='JSIncludes/searchFunction.js'></script>";
$retString.= "<script type='text/javascript' src='JSIncludes/windowHelp.js'></script>";
//$retString.= "<script type='text/javascript' src='JSIncludes/checkQueryPermissions.js'></script>";

$retString.="<script type='text/javascript'>
	function LoadManageVehicleRates()
	{
		Ext.define('VehicleRates',
		{
			extend:'Ext.data.Model',
			fields:
			[
				{name:'ID', type:'integer'},
				{name:'VehicleType_ID', type:'integer'},
				{name:'HourlyRate', type:'double'},
				{name:'HourlyMinimum', type:'double'},
				{name:'MilageRate', type:'double'},
				{name:'MilageMinimum', type:'double'},
				{name:'AreaType_ID', type:'integer'},
				{name:'Active', type:'integer'},
				{name:'VehicleType', type:'string'},
				{name:'AreaType', type:'string'},
				{name:'VehicleID', type:'integer'},
				{name:'AreaID', type:'integer'}
			]
		});
		var VehicleRatesStore = Ext.create('Ext.data.Store',
		{
			model:'VehicleRates',
			proxy:
			{
				type:'ajax',
				url:'getFiles/getVehicleRates.php',
				reader:
				{
					type:'json',
					root:'rows'
				}
			},
			autoLoad:false
		});

		Ext.define('VehicleRatesCompanies',
		{
			extend:'Ext.data.Model',
			fields:
			[
				{name:'ID', type:'integer'},
				{name:'CompanyName', type:'string'},
				{name:'CurrencyAbbr', type:'string'}
			]
		});
		var CompaniesStore = Ext.create('Ext.data.Store',
		{
			model:'VehicleRatesCompanies',
			proxy:
			{
				type:'ajax',
				url:'getFiles/getCompanies.php',
				reader:
				{
					type:'json',
					root:'rows'
				}
			},
			autoLoad:true
		});
		CompaniesStore.addListener('load', function()
		{
			if (CompaniesStore.getCount() == 1)
			{
				Ext.getCmp('getVehicleRatesCompanyID').setValue(CompaniesStore.getAt(0).get('ID'));
				Ext.getCmp('getVehicleRatesCompanyID').disable();
				Ext.getCmp('UpdateVehicleRatesCompanyID').setValue(CompaniesStore.getAt(0).get('ID'));
				VehicleTypesStore.load({params:{'CompanyID':CompaniesStore.getAt(0).get('ID')}});

				Ext.getCmp('UpdateVehicleRatesForm').getForm().findField('HourlyRate').labelEl.dom.innerText = Ext.getCmp('HourlyRate').fieldLabel + ' (' + CompaniesStore.getAt(0).get('CurrencyAbbr')+')';
				Ext.getCmp('UpdateVehicleRatesForm').getForm().findField('MilageRate').labelEl.dom.innerText = Ext.getCmp('MilageRate').fieldLabel + ' (' + CompaniesStore.getAt(0).get('CurrencyAbbr')+')';
			}
		});

		Ext.define('AreaTypes',
		{
			extend:'Ext.data.Model',
			fields:
			[
				{name:'ID', type:'integer'},
				{name:'Type', type:'string'}
			]
		});
		var AreaTypesStore = Ext.create('Ext.data.Store',
		{
			model:'AreaTypes',
			proxy:
			{
				type:'ajax',
				url:'getFiles/getAreaTypes.php',
				reader:
				{
					type:'json',
					root:'rows'
				}
			},
			autoLoad:true
		});

		Ext.define('VehicleTypes',
		{
			extend:'Ext.data.Model',
			fields:
			[
				{name:'ID', type:'integer'},
				{name:'Type', type:'string'}
			]
		});
		var VehicleTypesStore = Ext.create('Ext.data.Store',
		{
			model:'VehicleTypes',
			proxy:
			{
				type:'ajax',
				url:'getFiles/getVehicleTypes.php',
				reader:
				{
					type:'json',
					root:'rows'
				}
			},
			autoLoad:false
		});

		var getVehicleRatesForm = new Ext.FormPanel
		({
			renderTo:'getVehicleRatesFormdiv',
			layout:'column',
			items:
			[{
				xtype:'combo',
				name:'getVehicleRatesCompanyID',
				id:'getVehicleRatesCompanyID',
				store:CompaniesStore,
				mode:'local',
				displayField:'CompanyName',
				valueField:'ID',
				fieldLabel:'Company',
				forceSelection:true,
				listeners:
				{
					select: function(selectbox,record,index)
					{
						VehicleTypesStore.load({params:{'CompanyID':Ext.getCmp('getVehicleRatesCompanyID').getValue()}});
						Ext.getCmp('UpdateVehicleRatesCompanyID').setValue(Ext.getCmp('getVehicleRatesCompanyID').getValue());
					}
				}
			},
			{
				xtype:'combo',
				name:'RatesVehicleType',
				id:'RatesVehicleType',
				store:VehicleTypesStore,
				queryMode:'local',
				displayField:'Type',
				valueField:'ID',
				fieldLabel:'Vehicle Types',
				forceSelection:true
			}]
		});
		Ext.create('Ext.Button',
		{
			text:'Get Vehicle Rates ',
			cls:'btn ',
			renderTo:'getVehicleRatesButtonsdiv',
			handler:function()
			{
				var ID = Ext.getCmp('getVehicleRatesCompanyID').getValue();
				VehicleRatesStore.load({params:{'CompanyID':ID,'VehicleType':Ext.getCmp('RatesVehicleType').getValue()}});
			}
		});

		var VehicleRatesGrid = new Ext.grid.GridPanel
		({
			id:'VehicleRatesGrid',
			name:'VehicleRatesGrid',
			store:VehicleRatesStore,
			height:400,
			title:'Vehicle Rates',
			border:true,
			renderTo:'VehicleRatesGriddiv',
			columnLines:true,
			columns:
			[
				{header:'VehicleType', name:'VehicleType', flex:1, dataIndex:'VehicleType'},
				{header:'Hourly Rate', name:'Hourly Rate', flex:1, dataIndex:'HourlyRate'},
				{header:'Hourly Minimum', name:'Hourly Minimum', flex:1, dataIndex:'HourlyMinimum'},
				{header:'Milage Rate', name:'Milage Rate', flex:1, dataIndex:'MilageRate'},
				{header:'Milage Minimum', name:'Milage Minimum', flex:1, dataIndex:'MilageMinimum'},
				{header:'Area Type', name:'Area Type', flex:1, dataIndex:'AreaType', hidden:true},
				{header:'Active', name:'Active', flex:1, dataIndex:'Active'}
			],
			selModel :new Ext.selection.RowModel
			({
				singleSelect:true,
				listeners:
				{
					select: function(rowModel, record, index, smObj)
					{
						UpdateVehicleRatesForm.getForm().loadRecord(record);
						Ext.getCmp('VehicleType1').disable();
						Ext.getCmp('VehicleType1').setValue(record.get('VehicleType'));
						Ext.getCmp('AreaType').disable();
						Ext.getCmp('UpdateVehicleRatesID').setValue(record.get('ID'));
					}
				}
			})
		});

		Ext.create('Ext.Button',
		{
			text:'Help',
			renderTo:'VehicleRatesGridButtonsdiv',
			cls:'btn ',
			handler:function()
			{
					windowHelp('Tutorials/ManageVehicleRates.mp4');
			}
		});

		Ext.create('Ext.Button',
		{
			text:'Search',
			renderTo:'VehicleRatesGridButtonsdiv',
			cls:'btn ',
			handler:function()
			{
				searchFunction(Ext.getCmp('VehicleRatesGrid'));
			}
		});

		Ext.create('Ext.Button',
		{
			text:'Refresh',
			renderTo:'VehicleRatesGridButtonsdiv',
			cls:'btn ',
			handler:function()
			{
				Ext.getCmp('VehicleRatesGrid').getStore().clearFilter();
			}
		});

	var UpdateVehicleRatesForm = new Ext.FormPanel
	({
		renderTo:'UpdateVehicleRatesFormdiv2',
		url:'ManageVehicleRatesSubmit.php',
		id:'UpdateVehicleRatesForm',
		items:
		[{
			xtype:'textfield',
			id:'UpdateVehicleRatesID',
			name:'UpdateVehicleRatesID',
			hidden:true
		},
		{
			xtype:'textfield',
			id:'UpdateVehicleRatesCompanyID',
			name:'UpdateVehicleRatesCompanyID',
			hidden:true
		},

		{
			xtype:'textfield',
			id:'VehicleType_ID',
			name:'VehicleType_ID',
			hidden:true
		},
		{
			xtype:'textfield',
			id:'AreaType_ID',
			name:'AreaType_ID',
			hidden:true,
			value:1
		},
		{
			xtype:'combo',
			name:'VehicleType1',
			id:'VehicleType1',
			store:VehicleTypesStore,
			queryMode:'local',
			displayField:'Type',
			valueField:'ID',
			fieldLabel:'Vehicle Type',
			forceSelection:true,
			listeners:
			{
				select: function(selectbox,record,index)
				{
					Ext.getCmp('VehicleType_ID').setValue(record[0].get('ID'));
				}
			}


		},
		{
			xtype:'combo',
			name:'AreaType',
			id:'AreaType',
			store:AreaTypesStore,
			mode:'local',
			displayField:'Type',
			valueField:'ID',
			fieldLabel:'Area Type',
			hidden:true,
			value:1,
			listeners:
			{
				select: function(selectbox,record,index)
				{
					Ext.getCmp('AreaType_ID').setValue(record[0].get('ID'));
				}
			}
		},
		{
			xtype:'textfield',
			name:'HourlyRate',
			id:'HourlyRate',
			fieldLabel:'Hourly Rate '
		},
		{
			xtype:'textfield',
			name:'HourlyMinimum',
			id:'HourlyMinimum',
			fieldLabel:'Hourly Minimum'
		},
		{
			xtype:'textfield',
			name:'MilageRate',
			id:'MilageRate',
			fieldLabel:'Milage Rate'
		},
		{
			xtype:'textfield',
			name:'MilageMinimum',
			id:'MilageMinimum',
			fieldLabel:'Milage Minimum'
		},
		{
			xtype:'checkbox',
			name:'Active',
			id:'Active',
			fieldLabel:'Active',
			value:true
		},
		{
			xtype:'textfield',
			name:'Action',
			id:'Action',
			hidden:true
		}]
	});

	Ext.create('Ext.Button',
	{
		renderTo:'UpdateVehicleRatesButtonsdiv',
		text:'Update/Create',
		name:'UpdateVehicleRatesUpdate1',
		id:'UpdateVehicleRatesUpdate1',
		cls:'btn ',
		handler:function()
		{
			if (Ext.getCmp('UpdateVehicleRatesID').getValue() == '')
				var Action = 'Create';
			else
				var Action = 'Update';
			Ext.Ajax.request
			({
				url:'ManageVehicleRatesSubmit.php',
				success: function()
				{
					Ext.Msg.alert('Success', 'Vehicle Rate successfully updated');
					var ID = Ext.getCmp('UpdateVehicleRatesCompanyID').getValue();
					VehicleRatesStore.load({params:{'CompanyID':ID,'VehicleType':Ext.getCmp('RatesVehicleType').getValue()}});
					UpdateVehicleRatesForm.getForm().reset();
					Ext.getCmp('UpdateVehicleRatesCompanyID').setValue(ID);

					Ext.getCmp('VehicleType1').enable();
					Ext.getCmp('AreaType').enable();
				},
				failure: function()
				{
					Ext.Msg.alert('Error', 'Problem submitting vehicle rate');
				},
				params:
				{
					'ID':Ext.getCmp('UpdateVehicleRatesID').getValue(),
					'CompanyID':Ext.getCmp('UpdateVehicleRatesCompanyID').getValue(),
					'VehicleType_ID':Ext.getCmp('VehicleType_ID').getValue(),
					'AreaType_ID':Ext.getCmp('AreaType_ID').getValue(),
					'Action':Action,
					'VehicleType':Ext.getCmp('VehicleType1').getValue(),
					'AreaType':Ext.getCmp('AreaType').getValue(),
					'HourlyRate':Ext.getCmp('HourlyRate').getValue(),
					'HourlyMinimum':Ext.getCmp('HourlyMinimum').getValue(),
					'MilageRate':Ext.getCmp('MilageRate').getValue(),
					'MilageMinimum':Ext.getCmp('MilageMinimum').getValue(),
					'Active':Ext.getCmp('Active').getValue()
				}
			});
		}
	});

	Ext.create('Ext.Button',
	{
		renderTo:'UpdateVehicleRatesButtonsdiv',
		text:'Delete Vehicle Rate',
		name:'UpdateVehicleRatesDelete1',
		id:'UpdateVehicleRatesDelete1',
		cls:'btn ',
		handler:function()
		{
			var Action = 'Delete';
			Ext.Ajax.request
			({
				url:'ManageVehicleRatesSubmit.php',
				success: function()
				{
					Ext.Msg.alert('Success', 'Vehicle rate successfully deleted');
					var ID = Ext.getCmp('UpdateVehicleRatesCompanyID').getValue();
					VehicleRatesStore.load({params:{'CompanyID':ID,'VehicleType':Ext.getCmp('RatesVehicleType').getValue()}});
					UpdateVehicleRatesForm.getForm().reset();
					Ext.getCmp('UpdateVehicleRatesCompanyID').setValue(ID);
					Ext.getCmp('VehicleType1').enable();
					Ext.getCmp('AreaType').enable();

				},
				failure: function()
				{
					Ext.Msg.alert('Error', 'Problem deleting vehicle rate');
				},
				params:
				{
					'ID':Ext.getCmp('UpdateVehicleRatesID').getValue(),
					'Action':Action
				}
			});
		}
	});

	Ext.create('Ext.Button',
	{
		renderTo:'UpdateVehicleRatesButtonsdiv',
		text:'Reset Form',
		cls:'btn ',
		handler:function()
		{
			var ID = Ext.getCmp('UpdateVehicleRatesCompanyID').getValue();
			UpdateVehicleRatesForm.getForm().reset();
			Ext.getCmp('UpdateVehicleRatesCompanyID').setValue(ID);
			Ext.getCmp('VehicleType1').enable();
			Ext.getCmp('AreaType').enable();
		}
	});

	}
	LoadManageVehicleRates();
	</script>";

echo '{success: true, data:{"message":'.json_encode($retString).'}}';

?>