Find Jobs
Hire Freelancers

306374 Tire Maint

N/A

Đang triển khai
Đã đăng vào gần 15 năm trước

N/A

Thanh toán khi bàn giao
The forms address are in the attach pic These are maintenance forms for vehicles. The forms currently posts all data and the dbase has been created. The forma have two areas that need to be addressed “Tire Needs Replacement” “Tire changed” The vehicle has tires that need to be periodically replaced due to damage as well as replaced on or before the recommended tire manufacture mileage. In addition to extend the life of the tires they need to be rotated at a specified mileage. The form has select buttons which allowing a user to set the button marking the need to be replaced setting a boolan to 1 in the EQUIP_MAINT table. From that point every time the form is opened the tire button shall remain on until the same tire is marked as changed. Also based on manufacture recommend mileage the button can be set to change without user input. When the mileage gets within 5000 miles from the TRUCKS table in the blank area at the bottom left the user should receive a message in black counting down the mfg mileage. If the mileage is exceeded the message will appear in red. The message should read “The (tire_variable) needs to be replaced” This will occur for each of the 6 tires When the tire is marked as changed the boolan from the EQUIP_MAINT will be set to 0 and the mileage will start to count down again based on the tire change mileage in the TRUCKS table. Also when the tire is marked as changed the message above will no longer display. As mentioned the tires also need to be on a rotation schedule. This schedule shall be based on fields in the TRUCKS table. When the mileage gets within 3000 miles from the TRUCKS table in the blank area at the bottom left the user should receive a message in black counting down the rotation mileage. If the mileage is exceeded the message will appear in red. The message should read “The (tire_variable) needs to be rotated” This will occur for each of the 6 tires When the tire has be marked as rotated the Boolan in the EQUIP_MAINT table will be set to 1 and the message will no longer appear as well as the mileage count down will begin again based on the field in the TRUCKS table. On the form there is also a place for trailer tires that will need to be changed and replaced as well. The form has select buttons which allowing a user to set the button marking the trailer tires that need to be replaced setting a boolan to 1 in the EQUIP_MAINT table. From that point every time the form is opened the tire button shall remain on until the same tire is marked as changed. When the tire is marked as changed the boolan from the EQUIP_MAINT will be set to 0 and the mileage will start to count down again based on the tire change mileage in the TRAILERS table. Also when the tire is marked as changed the message above will no longer display. The message should read “The (tire_variable) needs to be changed” This will occur for each of the 4 tires When the tire has be marked as changed the Boolan in the EQUIP_MAINT table will be set to 1 and the message will no longer appear as well as the mileage count down will begin again based on the field mfg_milage in the TRAILERS table. The following are a Boolan in EQUIP_MAINT table trailer_drv_front_replace trailer_drv_rear_replace trailer_pass_front_replace trailer_pass_rear_replace trailer_drv_front_changed trailer_drv_rear_changed trailer_pass_front_changed trailer_pass_rear_changed The following are varchar in the TRAILERS table trailer_drv_front_mfg_milage trailer_drv_rear_mfg_milage trailer_pass_front_mfg_milage trailer_pass_rear_mfg_milage Below are the fields all ready created in the dbase and their type Tire Needs Replacement – the following are Boolan in the EQUIP_MAINT table drv_front_replace drv_rear_replace drv_rear_inner_replace pass_front_replace pass_rear_replace pass_rear_inner_replace Tire has been Changed – the following are Boolan in the EQUIP_MAINT table drv_front_changed drv_rear_changed drv_rear_inner_changed pass_front_changed pass_rear_changed pass_rear_inner_changed Tire Change Schedule – the following are varchar in TRUCKS table drv_front_tire_change_milage drv_rear_tire_change_milage drv_inner_tire_change_milage pass_front_tire_change_milage pass_rear_tire_change_milage pass_inner_tire_change_milage Tire Rotation– the following are varchar in the TRUCKS table drv_front_tire_rotation drv_rear_tire_rotation drv_rear_inner_tire_rotation pass_front_tire_rotation pass_rear_tire_rotation pass_rear_inner_tire_rotation The following are Boolans in the EQUIP_MAINT table drv_front_tire_rotated drv_rear_tire_rotated drv_inner_tire_rotated pass_front_tire_rotated pass_rear_tire_rotated pass_inner_tire_rotated
Mã dự án: 2052167

Về dự án

Dự án từ xa
Hoạt động 12 năm trước

Bạn muốn kiếm tiền?

Lợi ích khi chào giá trên Freelancer

Thiết lập ngân sách và thời gian
Nhận thanh toán cho công việc
Phác thảo đề xuất của bạn
Miễn phí đăng ký và cháo giá cho công việc

Về khách hàng

Cờ của UNITED STATES
Tucson, United States
5,0
107
Phương thức thanh toán đã xác thực
Thành viên từ thg 8 8, 2004

Xác thực khách hàng

Cảm ơn bạn! Chúng tôi đã gửi email chứa đường link để bạn lấy tín dụng miễn phí.
Đã xảy ra lỗi trong khi gửi email của bạn. Hãy thử lại.
Người Dùng Đã Đăng Ký Tổng Số Việc Đã Đăng
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Đang tải xem trước
Đã cấp quyền truy cập vị trí.
Phiên đăng nhập của bạn đã hết hạn và bạn đã bị đăng xuất. Hãy đăng nhập lại.