|
S
swanside author
Hi, I have a custom view that shows the infomation from the below code.
select job.`Order_Date`,
job.`File_No`,
job.`Job_No`,
IFNULL((select sum(Paying_Rate*Working_Hrs) from labour where Job_No = job.Job_No),0) as Labsubtotal,
IFNULL((select sum(Quantity*Unit_Price+(Quantity*Unit_Price*+Additional_Cost/100)) from material where Job_No = job.Job_No),0) as Matsubtotal,
(select Labsubtotal*0.175) as Labvat,
(select Matsubtotal*0.175) as Matvat,
(select Matsubtotal + Labsubtotal) as subtotal,
(select Labsubtotal*0.175 + Matsubtotal*0.175 ) as vat,
(select Labsubtotal*1.175 + Matsubtotal*1.175) as TOTAL,
job.`Customer_ID`,
job.`Order_Time`,
job.`Contract`,
job.`Order_Site_Address`,
job.`Job_Description`,
job.`Invoice_Printed`,
job.`Invoice_Printing_Date`,
job.`Invoice_Tax_Date`,
job.`Payment_Received`,
job.`CustomerRef`,
job.`Customer_Name`,
job.`Payment_Due_date`,
job.`Payment_Date`,
job.`Locked`
From `job`
In the Fields order and Totals, I have selected TOTAL to be totalled and subtotal to be totalled,
If I do a search by customer, I return 3102 entries and it shows 20 records per page, and there are 156 pages, I can change the display to show 500 results per page and that leaves me with this error.
Fatal error: Maximum execution time of 60 seconds exceeded in C:\Domains\swanside.com\wwwroot\data\include\dbconnection.php on line 24
Any ideas please
|
|