- Timestamp:
- 03/26/2020 12:25:28 PM (6 years ago)
- Location:
- branches/LCSv1
- Files:
-
- 1 added
- 6 edited
-
controllers/default.py (modified) (4 diffs)
-
databases/sql.log (modified) (1 diff)
-
databases/storage.sqlite (modified) (previous)
-
errors/127.0.0.1.2020-03-26.14-00-03.b84f5844-ff06-4823-b1ba-fd927364d20b (added)
-
sessions/0f9/18f/127.0.0.1-2495501c-0773-43d5-a795-4e06d3afb058 (modified) (previous)
-
static/css/lcstrain.css (modified) (3 diffs)
-
views/default/submit.html (modified) (1 diff)
Legend:
- Unmodified
- Added
- Removed
-
branches/LCSv1/controllers/default.py
r601 r602 102 102 103 103 form = FORM(BR(), 104 TABLE(THEAD(TR(TH('Closure ID/',BR(),'Log No.'), TH('Route & Dir',BR(),'Type of Closure'),TH('Start Date/',BR(),'End Date/',BR(),'Est. Delay'),TH('Requestor/',BR(),'Radio Call No.'),TH('Status'))),104 TABLE(THEAD(TR(TH('Closure ID/',BR(),'Log No.'), TH('Route & Dir',BR(),'Type of Closure'),TH('Start Date/',BR(),'End Date/',BR(),'Est. Delay'),TH('Requestor/',BR(),'Radio Call No.'),TH('Status'))), 105 105 [TR(TD(row.closureid,HR(),row.lognum),TD(row.route,' ',row.direction,HR(),row.closuretype),TD(row.startdate,HR(),row.enddate,HR(),row.estdelay),TD(row.supervisor,BR(),db(db.supervisors.name == row.supervisor).select().first().radiocallnum),TD(LABEL('1097'), INPUT(_type='checkbox', _name='statustype', _value='1097'+row.closureid),LABEL('1098'), INPUT(_type='checkbox', _name='statustype', _value='1098'+row.closureid),LABEL('1022'), INPUT(_type='checkbox', _name='statustype', _value='1022'+row.closureid),BR(), LABEL('Statuser:'),INPUT(_name='statuser',_size='9'))) for row in closedItems], 106 106 _border='1', _cellpadding='5'),INPUT(_type='submit',_value="submit status form",_class="submit-button"),) … … 167 167 LABEL('*Direction',_for='direction'), SELECT(hwyDirections,_name='direction', requires=IS_LENGTH(minsize=1,error_message='direction cannot be empty')), XML(' '), 168 168 LABEL('*Facility',_for='facility'), SELECT(facilities,_name='facility', requires=IS_LENGTH(minsize=1,error_message='facility cannot be empty')), BR(),BR(), 169 TABLE(TR(TD(),TD('*County'),TD('*Location')),TR(TD('BEGIN='),TD(SELECT('ORA',_name='startcounty')),TD(SELECT(streets,_name='startlocation',_id='startlocation')), 170 TR(TD('END='),TD(SELECT('ORA',_name='endcounty')),TD(SELECT(streets,_name='endlocation',_id='endlocation'))))),BR(), 171 'Date Range:',BR(), 169 TABLE(TR(TD(),TD(LABEL('*County')),TD(LABEL('*Location'))), 170 TR(TD(LABEL('BEGIN=')),TD(SELECT('ORA',_name='startcounty')), 171 TD(SELECT(streets,_name='startlocation',_id='startlocation')), 172 TR(TD(LABEL('END=')),TD(SELECT('ORA',_name='endcounty')),TD(SELECT(streets,_name='endlocation',_id='endlocation'))))),BR(), 173 LABEL('Date Range:'),BR(), 172 174 LABEL('From',_for='startdate'),INPUT(_name='startdate',_size='8',_class='date'), XML(' '), 173 175 LABEL('to:',_for='enddate'), INPUT(_name='enddate',_size='8',_class='date'),XML(' '), … … 176 178 LABEL('to:',_for='endtime'),SELECT(hournames,_name='endtime'), 177 179 LABEL(':',_for='endtimemin'),SELECT('','00','15','30','45','59',_name='endtimemin'), BR(),BR(), 178 TABLE(TR(TD('*Type of Closure'),TD('*Type of Work'),TD('Estimated Delay'),TD('TMP Details')), 180 TABLE(TR(TD(LABEL('*Type of Closure') ), 181 TD(LABEL('*Type of Work')), 182 TD(LABEL('Estimated Delay')), 183 TD(LABEL('TMP Details'))), 179 184 TR(TD(SELECT(closuretypes,_name='closuretype',requires=IS_LENGTH(minsize=1,error_message='type of closure cannot be empty'))), 180 185 TD(SELECT(worktypes,_name='worktype', requires=IS_LENGTH(minsize=1,error_message='type of work cannot be empty'))), … … 183 188 INPUT(_type='checkbox', _name='detour'),'Detour Available')), 184 189 _width='100%' ), 185 TABLE(TR(TD('*Supervisor'),TD('Field Rep')), 190 TABLE(TR(TD(LABEL('*Supervisor'), _style="margin-right: 5%;"), 191 TD(LABEL('Field Rep'))), 186 192 TR(TD(SELECT(supervisors,_name='supervisor', requires=IS_LENGTH(minsize=1,error_message='supervisor cannot be empty'))), 187 193 TD(SELECT(supervisors,_name='fieldrep')))), 188 TABLE(TR(TD('Meeting Place/CHP Contact'),TD('Reason for Closure'),TD('Additional Remarks / Detour ')), 189 TR(TD(INPUT(_name='meeting')),TD(INPUT(_name='reason',_size='40')),TD(INPUT(_name='remarks',_size='40'))) ), BR(), 190 INPUT(_type='submit',_value='Submit Closure'),XML('\n'),SELECT(streetlookup,_name='stlookup', _id='stlookup', _class='hideme')) 194 TABLE(TR(TD( LABEL('Meeting Place/CHP Contact')), 195 TD(LABEL('Reason for Closure')), 196 TD(LABEL('Additional Remarks / Detour '))), 197 TR(TD(INPUT(_name='meeting', _size='30')),TD(INPUT(_name='reason',_size='40')),TD(INPUT(_name='remarks',_size='40'))) ), BR(), 198 INPUT(_type='submit',_value='Submit Closure', _class="btn btn-primary btn-default", _style="margin: 7% 45% 2% 40%;"), 199 XML('\n'),SELECT(streetlookup,_name='stlookup', _id='stlookup', _class='hideme')) 200 191 201 if form.process().accepted: 192 202 newID = calcNextClosure(form.vars.route) -
branches/LCSv1/databases/sql.log
r601 r602 18436 18436 DELETE FROM sqlite_sequence WHERE name='streets' 18437 18437 success! 18438 DELETE FROM "supervisors"; 18439 DELETE FROM sqlite_sequence WHERE name='supervisors' 18440 success! 18441 DELETE FROM "streets"; 18442 DELETE FROM sqlite_sequence WHERE name='streets' 18443 success! 18444 DELETE FROM "supervisors"; 18445 DELETE FROM sqlite_sequence WHERE name='supervisors' 18446 success! 18447 DELETE FROM "streets"; 18448 DELETE FROM sqlite_sequence WHERE name='streets' 18449 success! 18450 DELETE FROM "supervisors"; 18451 DELETE FROM sqlite_sequence WHERE name='supervisors' 18452 success! 18453 DELETE FROM "streets"; 18454 DELETE FROM sqlite_sequence WHERE name='streets' 18455 success! 18456 DELETE FROM "supervisors"; 18457 DELETE FROM sqlite_sequence WHERE name='supervisors' 18458 success! 18459 DELETE FROM "streets"; 18460 DELETE FROM sqlite_sequence WHERE name='streets' 18461 success! 18462 DELETE FROM "supervisors"; 18463 DELETE FROM sqlite_sequence WHERE name='supervisors' 18464 success! 18465 DELETE FROM "streets"; 18466 DELETE FROM sqlite_sequence WHERE name='streets' 18467 success! 18468 DELETE FROM "supervisors"; 18469 DELETE FROM sqlite_sequence WHERE name='supervisors' 18470 success! 18471 DELETE FROM "streets"; 18472 DELETE FROM sqlite_sequence WHERE name='streets' 18473 success! 18474 DELETE FROM "supervisors"; 18475 DELETE FROM sqlite_sequence WHERE name='supervisors' 18476 success! 18477 DELETE FROM "streets"; 18478 DELETE FROM sqlite_sequence WHERE name='streets' 18479 success! 18480 DELETE FROM "supervisors"; 18481 DELETE FROM sqlite_sequence WHERE name='supervisors' 18482 success! 18483 DELETE FROM "streets"; 18484 DELETE FROM sqlite_sequence WHERE name='streets' 18485 success! 18486 DELETE FROM "supervisors"; 18487 DELETE FROM sqlite_sequence WHERE name='supervisors' 18488 success! 18489 DELETE FROM "streets"; 18490 DELETE FROM sqlite_sequence WHERE name='streets' 18491 success! 18492 DELETE FROM "supervisors"; 18493 DELETE FROM sqlite_sequence WHERE name='supervisors' 18494 success! 18495 DELETE FROM "streets"; 18496 DELETE FROM sqlite_sequence WHERE name='streets' 18497 success! 18498 DELETE FROM "supervisors"; 18499 DELETE FROM sqlite_sequence WHERE name='supervisors' 18500 success! 18501 DELETE FROM "streets"; 18502 DELETE FROM sqlite_sequence WHERE name='streets' 18503 success! 18504 DELETE FROM "supervisors"; 18505 DELETE FROM sqlite_sequence WHERE name='supervisors' 18506 success! 18507 DELETE FROM "streets"; 18508 DELETE FROM sqlite_sequence WHERE name='streets' 18509 success! 18510 DELETE FROM "supervisors"; 18511 DELETE FROM sqlite_sequence WHERE name='supervisors' 18512 success! 18513 DELETE FROM "streets"; 18514 DELETE FROM sqlite_sequence WHERE name='streets' 18515 success! 18516 DELETE FROM "supervisors"; 18517 DELETE FROM sqlite_sequence WHERE name='supervisors' 18518 success! 18519 DELETE FROM "streets"; 18520 DELETE FROM sqlite_sequence WHERE name='streets' 18521 success! 18522 DELETE FROM "supervisors"; 18523 DELETE FROM sqlite_sequence WHERE name='supervisors' 18524 success! 18525 DELETE FROM "streets"; 18526 DELETE FROM sqlite_sequence WHERE name='streets' 18527 success! 18528 DELETE FROM "supervisors"; 18529 DELETE FROM sqlite_sequence WHERE name='supervisors' 18530 success! 18531 DELETE FROM "streets"; 18532 DELETE FROM sqlite_sequence WHERE name='streets' 18533 success! 18534 DELETE FROM "supervisors"; 18535 DELETE FROM sqlite_sequence WHERE name='supervisors' 18536 success! 18537 DELETE FROM "streets"; 18538 DELETE FROM sqlite_sequence WHERE name='streets' 18539 success! 18540 DELETE FROM "supervisors"; 18541 DELETE FROM sqlite_sequence WHERE name='supervisors' 18542 success! 18543 DELETE FROM "streets"; 18544 DELETE FROM sqlite_sequence WHERE name='streets' 18545 success! 18546 DELETE FROM "supervisors"; 18547 DELETE FROM sqlite_sequence WHERE name='supervisors' 18548 success! 18549 DELETE FROM "streets"; 18550 DELETE FROM sqlite_sequence WHERE name='streets' 18551 success! 18552 DELETE FROM "supervisors"; 18553 DELETE FROM sqlite_sequence WHERE name='supervisors' 18554 success! 18555 DELETE FROM "streets"; 18556 DELETE FROM sqlite_sequence WHERE name='streets' 18557 success! 18558 DELETE FROM "supervisors"; 18559 DELETE FROM sqlite_sequence WHERE name='supervisors' 18560 success! 18561 DELETE FROM "streets"; 18562 DELETE FROM sqlite_sequence WHERE name='streets' 18563 success! 18564 DELETE FROM "supervisors"; 18565 DELETE FROM sqlite_sequence WHERE name='supervisors' 18566 success! 18567 DELETE FROM "streets"; 18568 DELETE FROM sqlite_sequence WHERE name='streets' 18569 success! 18570 DELETE FROM "supervisors"; 18571 DELETE FROM sqlite_sequence WHERE name='supervisors' 18572 success! 18573 DELETE FROM "streets"; 18574 DELETE FROM sqlite_sequence WHERE name='streets' 18575 success! 18576 DELETE FROM "supervisors"; 18577 DELETE FROM sqlite_sequence WHERE name='supervisors' 18578 success! 18579 DELETE FROM "streets"; 18580 DELETE FROM sqlite_sequence WHERE name='streets' 18581 success! 18582 DELETE FROM "supervisors"; 18583 DELETE FROM sqlite_sequence WHERE name='supervisors' 18584 success! 18585 DELETE FROM "streets"; 18586 DELETE FROM sqlite_sequence WHERE name='streets' 18587 success! 18588 DELETE FROM "supervisors"; 18589 DELETE FROM sqlite_sequence WHERE name='supervisors' 18590 success! 18591 DELETE FROM "streets"; 18592 DELETE FROM sqlite_sequence WHERE name='streets' 18593 success! 18594 DELETE FROM "supervisors"; 18595 DELETE FROM sqlite_sequence WHERE name='supervisors' 18596 success! 18597 DELETE FROM "streets"; 18598 DELETE FROM sqlite_sequence WHERE name='streets' 18599 success! 18600 DELETE FROM "supervisors"; 18601 DELETE FROM sqlite_sequence WHERE name='supervisors' 18602 success! 18603 DELETE FROM "streets"; 18604 DELETE FROM sqlite_sequence WHERE name='streets' 18605 success! 18606 DELETE FROM "supervisors"; 18607 DELETE FROM sqlite_sequence WHERE name='supervisors' 18608 success! 18609 DELETE FROM "streets"; 18610 DELETE FROM sqlite_sequence WHERE name='streets' 18611 success! 18612 DELETE FROM "supervisors"; 18613 DELETE FROM sqlite_sequence WHERE name='supervisors' 18614 success! 18615 DELETE FROM "streets"; 18616 DELETE FROM sqlite_sequence WHERE name='streets' 18617 success! 18618 DELETE FROM "supervisors"; 18619 DELETE FROM sqlite_sequence WHERE name='supervisors' 18620 success! 18621 DELETE FROM "streets"; 18622 DELETE FROM sqlite_sequence WHERE name='streets' 18623 success! 18624 DELETE FROM "supervisors"; 18625 DELETE FROM sqlite_sequence WHERE name='supervisors' 18626 success! 18627 DELETE FROM "streets"; 18628 DELETE FROM sqlite_sequence WHERE name='streets' 18629 success! 18630 DELETE FROM "supervisors"; 18631 DELETE FROM sqlite_sequence WHERE name='supervisors' 18632 success! 18633 DELETE FROM "streets"; 18634 DELETE FROM sqlite_sequence WHERE name='streets' 18635 success! 18636 DELETE FROM "supervisors"; 18637 DELETE FROM sqlite_sequence WHERE name='supervisors' 18638 success! 18639 DELETE FROM "streets"; 18640 DELETE FROM sqlite_sequence WHERE name='streets' 18641 success! 18642 DELETE FROM "supervisors"; 18643 DELETE FROM sqlite_sequence WHERE name='supervisors' 18644 success! 18645 DELETE FROM "streets"; 18646 DELETE FROM sqlite_sequence WHERE name='streets' 18647 success! 18648 DELETE FROM "supervisors"; 18649 DELETE FROM sqlite_sequence WHERE name='supervisors' 18650 success! 18651 DELETE FROM "streets"; 18652 DELETE FROM sqlite_sequence WHERE name='streets' 18653 success! 18654 DELETE FROM "supervisors"; 18655 DELETE FROM sqlite_sequence WHERE name='supervisors' 18656 success! 18657 DELETE FROM "streets"; 18658 DELETE FROM sqlite_sequence WHERE name='streets' 18659 success! 18660 DELETE FROM "supervisors"; 18661 DELETE FROM sqlite_sequence WHERE name='supervisors' 18662 success! 18663 DELETE FROM "streets"; 18664 DELETE FROM sqlite_sequence WHERE name='streets' 18665 success! 18666 DELETE FROM "supervisors"; 18667 DELETE FROM sqlite_sequence WHERE name='supervisors' 18668 success! 18669 DELETE FROM "streets"; 18670 DELETE FROM sqlite_sequence WHERE name='streets' 18671 success! 18672 DELETE FROM "supervisors"; 18673 DELETE FROM sqlite_sequence WHERE name='supervisors' 18674 success! 18675 DELETE FROM "streets"; 18676 DELETE FROM sqlite_sequence WHERE name='streets' 18677 success! 18678 DELETE FROM "supervisors"; 18679 DELETE FROM sqlite_sequence WHERE name='supervisors' 18680 success! 18681 DELETE FROM "streets"; 18682 DELETE FROM sqlite_sequence WHERE name='streets' 18683 success! 18684 DELETE FROM "supervisors"; 18685 DELETE FROM sqlite_sequence WHERE name='supervisors' 18686 success! 18687 DELETE FROM "streets"; 18688 DELETE FROM sqlite_sequence WHERE name='streets' 18689 success! -
branches/LCSv1/static/css/lcstrain.css
r601 r602 283 283 } 284 284 285 label { 286 font-family: geneva, sans-serif; 287 font-size: 18px; 288 color: #003366; 289 font-weight: bold; 290 text-align: right; 291 margin: 0% 1% 0% 3%; 292 } 285 293 .label90 { 286 294 width: 90px; … … 509 517 background: lightblue; 510 518 } 519 th { 520 font-size: 14px; 521 } 511 522 tr:nth-child(odd).statusHistory { 512 523 background: lightgray; … … 1735 1746 margin: 4% 0% 4% 0%; 1736 1747 justify-content: center; 1737 width: 650px;1738 } 1748 width: 800px; 1749 } -
branches/LCSv1/views/default/submit.html
r593 r602 66 66 } 67 67 </script> 68 <h2>Request Emergency Closure</h2> 69 {{=form}} 68 69 <div id="main" role="main" class="mainflex"> 70 <div id="pageTitle" class="header">Request Emergency Closure</div> 71 72 <div class="searchform"> 73 {{=form}} 74 </div> 75 </div>
Note: See TracChangeset
for help on using the changeset viewer.
