Forbidden
You don't have permission to access this resource.
Apache/2.4.56 (Win64) OpenSSL/1.1.1t PHP/8.2.4 Server at 192.168.1.108 Port 98
{{ Quotes }}
{{ "-" + QuotesAuthor +"-" }}
Web Apps Developed By:Gondren Apas|gondrenapas89@gmail.com
{{ "WELCOME "+ UserData.FirstName + " " + UserData.LastName }}
Edit
Copy
Update History
EAM & COC Attachment
Change Sector
Materials Summary
Show Request Delete
| No | Work Order | WO Description | {{ConClass.length==0?'Sector-Department':'Department'}} | Location | Supervisor | Pole/TLN Tag | Circuit | Picture | EAM WO Status | Date Received | Date Energized | Date Completed | With Variance | With BackJob | Remarks | SIForManualChk | Billing Status |
| {{ x.RowNo }} | {{ x.WorkOrder }} | {{ x.WODescription }} | {{ ConClass.length==0?x.ConClass+'-'+x.Sector+'|'+x.Department:x.Department }} | {{ x.Location }} | {{ x.Supervisor }} | {{ x.PoleTLNTag }} | {{ x.Circuit }} | {{ x.Picture }} | {{ x.EAMWOStatus }} | {{ x.DateReceived }} | {{ x.DateEnergized }} | {{ x.DateCompleted }} | {{ x.WithVariance }} | {{ x.WithBackJob }} | {{ x.Remarks }} | {{ x.SIForManualChk }} |
{{TC1D2_Prev==0?"1 → "+TC1D2_Next+" of "+ TC1D1_FindResult.length:TC1D2_Prev+" → "+TC1D2_Next+" of "+ TC1D1_FindResult.length}}
Create New Record
| Work Order |
| WO Description |
| Location |
| Department |
| Date Received |
|
|
| EAM WO Status |
{{TC1D1_PageContent[TC1D1_Row].ProjRecordNo+":"+TC1D1_PageContent[TC1D1_Row].WorkOrder+":"+TC1D1_PageContent[TC1D1_Row].WODescription}}
Upload PO From SAP
Edit
Copy
Show Update History
| Record No. | COC Date Submitted | COC Amount | COC Created By | COC Date Received | COC Received By | Deleted |
| {{ x.RecordNo }} | {{ x.COCDateSubmitted }} | {{ x.COCAmount }} | {{ x.COCCreatedBy }} | {{ x.COCDateReceived }} | {{ x.COCReceivedBy }} |
| Total COC Amount | {{NumberStyle(SumCol(TC1D421_FindResult,'COCAmount'),"WC")}} | Total PO Amount | {{ NumberStyle(TC1D421_POAmount,"WC") }} | ||
| GR Date | GR Amount |
| {{ DateStyle(x.GRDate,"C") }} | {{ NumberStyle(x.GRAmount,"WC") }} |
| Total GR Amount | {{NumberStyle(SumCol(TC1D421_GRDateAmt,'GRAmount'),"WC")}} | Total GR Amount | {{NumberStyle(SumCol(TC1D421_GRDateAmt,'GRAmount'),"WC")}} | ||
| WO Balance | {{NumberStyle(SumCol(TC1D421_FindResult,'COCAmount')-SumCol(TC1D421_GRDateAmt,'GRAmount'),"WC")}} | Balance | {{NumberStyle(TC1D421_POAmount-SumCol(TC1D421_GRDateAmt,'GRAmount'),"WC")}} | ||
| COC Aging | {{TC1D421_COCAging}} | ||||
| COC Date Submitted |
|
|
| COC Amount |
| COC Created By |
| Task | SI | Description | Qnty | Amount | P.O. No. | G.R. No. | Inv. No. | Inspected | Deleted | Contract No. | Con Sec | Con Off | SI Status | Action |
| {{ x.TaskNo }} | {{ x.Code }} | {{ x.Description }} | {{ NumberStyle(x.Qnty,"WC") }} | {{ NumberStyle(x.Amount,"WC") }} | {{ x.PO }} | {{ x.GR }} | {{ x.InvoiceNo }} | {{ x.Inspected }} {{ x.Inspected }} | {{ x.Deleted }} {{ x.Deleted }} | {{ x.ContractNo }} | {{ x.ContractingSector }} | {{ x.ContractingOffice }} | {{ x.SIStatus }} | {{ NumberStyle(SumCol(TC1D422_FindResult,"Amount"),"WC") }} |
| Task | Task Id | Service | Description | Qnty | Line Cost | PO | Deleted | Completed | Inspected | Contract | Contract Description |
| {{x.Task}} | {{x.TaskId}} | {{x.Service}} | {{x.Description}} | {{x.Quantity}} | {{x.LineCost}} | {{x.PO}} | {{x.Deleted}} | {{x.Completed}} | {{x.Inspected}} | {{x.Contract}} | {{x.ContractDescription}} | {{ NumberStyle(SumColIfs(TC1D423_FindResult,'LineCost', item=>InStr(item.LineCost,TC1D423_LineCost)>=0 && InStr(item.PO,TC1D423_PO)>=0 && InStr(item.Inspected,TC1D423_Inspected)>=0 && InStr(item.Deleted,TC1D423_Deleted)>=0),"WC") }} |
| SI Code | Amount | PO | GR | Inspected | Deleted |
| {{x.Code}} | {{x.Amount}} | {{x.POTask}} | {{x.GR}} | {{ x.Inspected }} | {{ x.Deleted }} |
| {{ NumberStyle(SumColIfs(TC1D4241_SAP,'Amount',item=>InStr(item.Amount,TC1D4241_Amount)>=0 && InStr(item.POTask,TC1D4241_PO)>=0 && InStr(item.Inspected,TC1D4241_Inspected)>=0 && InStr(item.Deleted,TC1D4241_Deleted)>=0),"WC") }} | {{ 'Count: '+CountColIfs(TC1D4241_SAP,'Amount',item=>InStr(item.Amount,TC1D4241_Amount)>=0 && InStr(item.POTask,TC1D4241_PO)>=0 && InStr(item.Inspected,TC1D4241_Inspected)>=0 && InStr(item.Deleted,TC1D4241_Deleted)>=0) }} |
| Service | Line Cost | PO | Inspected | Deleted | |
| {{x.Code}} | {{x.Amount}} | {{x.PO}} | {{x.Inspected}} | {{x.Deleted}} | |
| {{ NumberStyle(SumColIfs(TC1D4242_EAM,'Amount',item=>InStr(item.Amount,TC1D4242_Amount)>=0 && InStr(item.PO,TC1D4242_PO)>=0 && InStr(item.Inspected,TC1D4242_Inspected)>=0 && InStr(item.Deleted,TC1D4242_Deleted)>=0),"WC") }} | {{ 'Count: '+CountColIfs(TC1D4242_EAM,'Amount',item=>InStr(item.Amount,TC1D4242_Amount)>=0 && InStr(item.PO,TC1D4242_PO)>=0 && InStr(item.Inspected,TC1D4242_Inspected)>=0 && InStr(item.Deleted,TC1D4242_Deleted)>=0) }} |
{{ 'Update History of '+TC1D1_PageContent[TC1D1_Row].ProjRecordNo+":"+TC1D1_PageContent[TC1D1_Row].WorkOrder+":"+TC1D1_PageContent[TC1D1_Row].WODescription }}
| Date | Column Name | Previous Value | New Value | User | Work Station |
| {{ x.Date }} | {{ x.ColumnName }} | {{ x.PrevValue }} | {{ x.NewValue }} | {{ x.User }} | {{ x.ComputerName }} |
{{ 'EAM And COC Attachment of '+TC1D1_PageContent[TC1D1_Row].ProjRecordNo+":"+TC1D1_PageContent[TC1D1_Row].WorkOrder+":"+TC1D1_PageContent[TC1D1_Row].WODescription }}
| EAM Billing SI | {{ TC1D6_FindResult.EAMAttBillingSI }} | COC Cover Page | {{ TC1D6_FindResult.COCAttCoverPage }} | |
| EAM As-Built Sketch | {{ TC1D6_FindResult.EAMAttAsBuiltSketch }} | COC FALLAWMA | {{ TC1D6_FindResult.COCAttFALLAWMA }} | |
| EAM Pole Specs | {{ TC1D6_FindResult.EAMAttPoleSpecs }} | COC Pole Specs | {{ TC1D6_FindResult.COCAttPoleSpecs }} | |
| EAM DT Specs Install | {{ TC1D6_FindResult.EAMAttDTSpecsInstall }} | COC DT Specs Install | {{ TC1D6_FindResult.COCAttDTSpecsIns }} | |
| EAM DT Specs Retire | {{ TC1D6_FindResult.EAMAttDTSpecsRetire }} | COC DT Specs Retire | {{ TC1D6_FindResult.COCAttDTSpecsRet }} | |
| EAM Before Pictures | {{ TC1D6_FindResult.EAMAttBeforePictures }} | COC DTR | {{ TC1D6_FindResult.COCAttDTR }} | |
| EAM After Pictures | {{ TC1D6_FindResult.EAMAttAfterPictures }} | COC Wire Summary | {{ TC1D6_FindResult.COCAttWireSummary }} | |
| EAM QI Checklist | {{ TC1D6_FindResult.EAMAttQIChecklist }} | COC As-Built Sketch | {{ TC1D6_FindResult.COCAttAsBuiltSketch }} | |
| EAM FALLAWMA | {{ TC1D6_FindResult.EAMAttFALLAWMA }} | COC Services Billing | {{ TC1D6_FindResult.COCAttServicesBilling }} | |
| EAM STR | {{ TC1D6_FindResult.EAMAttSTR }} | COC Material Balancing | {{ TC1D6_FindResult.COCAttMatBal }} | |
| EAM Cover Received | {{ TC1D6_FindResult.EAMAttCoverReceived }} | COC STR | {{ TC1D6_FindResult.COCAttSTR }} | |
| EAM Permit Notice | {{ TC1D6_FindResult.EAMAttPermitNotice }} |
{{ 'Change Sector of '+TC1D1_PageContent[TC1D1_Row].ProjRecordNo+":"+TC1D1_PageContent[TC1D1_Row].WorkOrder+":"+TC1D1_PageContent[TC1D1_Row].WODescription }}
Upload Work Order Status Update
| Work Order | Department | Supervisor | Old WO Status | New WO Status | Remarks |
| {{ x.WorkOrder }} | {{ x.Department }} | {{ x.Supervisor }} | {{ x.OldWOStatus }} | {{ x.NewWOStatus }} | {{ x.Remarks }} |
{{ TC1D1_PageContent[TC1D1_Row].ProjRecordNo+":"+TC1D1_PageContent[TC1D1_Row].WorkOrder+":"+TC1D1_PageContent[TC1D1_Row].WODescription}}
| Code | Description | WFMS | IFVW | RTVW | RTMS | Balance |
| {{ x.Code }} | {{ x.Description }} | {{ NumberStyle(x.WFMS,"WCB") }} | {{ NumberStyle(x.IFVW,"WCB") }} | {{ NumberStyle(x.RTVW,"WCB") }} | {{ NumberStyle(x.RTMS,"WCB") }} | {{ NumberStyle(x.Balance,"WCB") }} |
{{ TC1D1_PageContent[TC1D1_Row].ProjRecordNo+":"+TC1D1_PageContent[TC1D1_Row].WorkOrder+":"+TC1D1_PageContent[TC1D1_Row].WODescription}}
Reason to Delete{{ TC1D1_PageContent[TC1D1_Row].DeleteSubmittedBy }}
{{'Requested By: ' + TC1D1_PageContent[TC1D1_Row].DeleteRequestedBy}}
{{'Approved By: ' + TC1D1_PageContent[TC1D1_Row].DeleteApprovedBy}}