Repairer – Repair Shop Management System With Point Of Sale 3 8

Description

Repairer Repair Workshop Management System is carefully developed for easy management of any type of repairshop workshop It s actually an innovative simple and powerful management tool designed and developed for you It s just your trusty employee It s a web based system where you can manage reparations clients inventory purchases etc Now it comes with a Point of Sale System Demo URL preview otsglobal org rms_pos Email admin admin com Password password Quick Installation Guide Download zip package Upload it to your server Extract the package Run the uploaded url via browser EXAMPLE COM RMS INSTALL Here you have to provide the settings for RMS Hostname database host name IP Database Name create a mysql database for RMS on your host and write that name here Database username username of the created database if applicable Database password password of the created database Backend Admin Point Of Sale Dashboard graphical report General settings system customization Client management Reparation management Inventory Management Purchases Management Taxes Models Categories etc Graphical Reports Stock Finance Sales Reports Drawer Reports Report table export to XLS PDF Frontend Reparation Status Login Notification Alert System Notify clients with their reparation status via E-Mail or SMS Documentation Want to know more about Repairer Please read our Documentation How to Update 2 Change Log 3 7 to 3 8 Download v3 8 Take Database Files Backup Extract 3 8 files in place of 3 7 Copy application config database php from 3 7 backup to 3 8 Copy application config config php from 3 7 backup to 3 8 Copy assets uploads from 3 7 to 3 8 Run following in phpMyAdmin UPDATE settings SET version 3 8 Change Log 3 6 to 3 7 Download v3 7 Take Database Files Backup Extract 3 7 files in place of 3 6 Copy application config database php from 3 6 backup to 3 7 Copy application config config php from 3 6 backup to 3 7 Copy assets uploads from 3 6 to 3 7 Run following in PhpMyAdmin ALTER TABLE settings ADD nexmo_number VARCHAR 50 NOT NULL ALTER TABLE permissions ADD settings-general tinyint 1 NOT NULL DEFAULT 0 ADD settings-orders tinyint 1 NOT NULL DEFAULT 0 ADD settings-invoice tinyint 1 NOT NULL DEFAULT 0 ADD settings-sms tinyint 1 NOT NULL DEFAULT 0 ADD settings-appearance tinyint 1 NOT NULL DEFAULT 0 ADD repair_statuses-add tinyint 1 NOT NULL DEFAULT 0 ADD repair_statuses-edit tinyint 1 NOT NULL DEFAULT 0 ADD repair_statuses-delete tinyint 1 NOT NULL DEFAULT 0 ADD repair_statuses-sort tinyint 1 NOT NULL DEFAULT 0 ADD settings-upload_logo tinyint 1 NOT NULL DEFAULT 0 ADD settings-upload_background tinyint 1 NOT NULL DEFAULT 0 ALTER TABLE reparation ADD order_discount decimal 24 2 NOT NULL ALTER TABLE settings ADD message_bird_access_key varchar 255 CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL ADD protocol varchar 100 CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT mail ADD mailchimp_api_key varchar 255 CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL ADD mailpath varchar 255 CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT usr sbin sendmail ADD smtp_service int 11 NOT NULL DEFAULT 1 UPDATE settings SET version 3 7 Change Log 3 5 to 3 6 Download v3 6 Take Database Files Backup Extract 3 6 files in place of 3 5 Copy application config database php from 3 5 backup to 3 6 Copy application config config php from 3 5 backup to 3 6 Copy assets uploads from 3 5 to 3 6 Run following in PhpMyAdmin ALTER TABLE settings ADD open_report_on_repair_add BOOLEAN NOT NULL ALTER TABLE settings ADD hide_repair_fields LONGTEXT NULL AFTER open_report_on_repair_add ALTER TABLE purchases ADD return_id INT NULL AFTER attachment ADD surcharge DECIMAL 24 2 NULL AFTER return_id ADD return_purchase_ref VARCHAR 255 NULL AFTER surcharge ADD purchase_id INT NULL AFTER return_purchase_ref ADD return_purchase_total DECIMAL 24 2 NULL AFTER purchase_id ALTER TABLE purchases ADD rma_number VARCHAR 255 NULL AFTER return_purchase_total ADD return_status VARCHAR 255 NULL AFTER rma_number ADD provider VARCHAR 255 NULL AFTER return_status ALTER TABLE purchases ADD track_code VARCHAR 255 NULL ALTER TABLE order_ref ADD rep INT NOT NULL DEFAULT 1 AFTER re ALTER TABLE purchase_items ADD purchase_item_id INT NULL AFTER unit_cost UPDATE settings SET version 3 6 UPDATE settings SET hide_repair_fields expected_close_date 1 error_code 1 date_of_purchase 1 has_warranty 1 warranty 1 warranty_card_number 1 repair_type 1 client_date 1 WHERE settings id 1 UPDATE date_format SET js UPPER js Change Log 3 2 to 3 5 Download v3 5 Take Database Files Backup Extract 3 5 files in place of 3 2 Copy application config database php from 3 2 backup to 3 5 Copy application config config php from 3 2 backup to 3 5 Copy assets uploads from 3 2 to 3 5 Run the Update35 sql in PhpMyAdmin Download here otsglobal org cc_updates rms_pos Update35 sql Change Log 3 1 to 3 2 – Bugs Fixed – added PHP Mailer Download v3 2 Take Database Files Backup Extract 3 2 files in place of 3 1 Copy application config database php from 3 1 backup to 3 2 Copy application config config php from 3 1 backup to 3 2 Copy assets uploads from 3 1 to 3 2 Run the following sql in PhpMyAdmin ALTER TABLE settings ADD smtp_crypto VARCHAR 100 NOT NULL AFTER smtp_port ALTER TABLE settings ADD enable_overselling BOOLEAN NOT NULL AFTER invoice_email_text ALTER TABLE settings ADD sms_caller_id VARCHAR 255 NOT NULL AFTER enable_overselling UPDATE settings SET version 3 2 WHERE settings id 1 Change Log 3 1 to 3 2 – Bugs Fixed Download v3 1 Take Database Files Backup Extract 3 1 files in place of 3 0 Copy application config database php from 3 0 backup to 3 1 Copy application config config php from 3 0 backup to 3 1 Copy assets uploads from 3 0 to 3 1 Run the following sql in PhpMyAdmin ALTER TABLE inventory CHANGE model_id model_id INT 11 NULL CHANGE model_name model_name VARCHAR 40 CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL ALTER TABLE clients ADD where_you_hear_about_us VARCHAR 250 NOT NULL AFTER image ALTER TABLE settings ADD sale_email_text TEXT NOT NULL AFTER default_http_api ALTER TABLE settings ADD email_footer TEXT NOT NULL AFTER sale_email_text ALTER TABLE settings ADD invoice_email_text TEXT NOT NULL AFTER email_footer Change Log 2 2 to 3 0 – Add Image in Inventory Table – Fix Barcode Problem in Print Barcodes Inventory – Update Repair Statuses Completed checkbox thing – Fix any calculation issue for repairs with tax – Settings – order reparation – categories can add category but disappears after saving – Purchases – download pdf rounds up numbers 2 decimals would be needed – editing purchases When it was set up as ordered and I go back editing to mark it as arrived or trying to do any modifications to it its not possible – POS Open Close Drawer different coins in settings – Add SMSInfo API android Gateway – Add Original Nexmo API – Add Pattern Pin Lock System – Warranty System – Document Sign – Calendar Widget show repairs too – Add Reparation ITEMS change quantity and price – Add Reparation Payments – Add Sales Payments – Remove Advance Scene – Add Paid System – Import Export Systems Customers – Forgot password email system – Activity Log – Add Table State Save based on users – custom sms api function – Permission Lang – And the tax is not appearing in POS invoice – Change status directly from table – And Much More Download v3 0 Take Database Files Backup Extract 3 0 files in place of 2 2 Copy application config database php from 2 2 backup to 3 0 Copy application config config php from 2 2 backup to 3 0 Copy assets uploads from 2 2 to 3 0 Create a folder named signs in assets uploads Run the Update30 sql in PhpMyAdmin Download here otsglobal org cc_updates rms_pos Update30 sql Change Log 1 1 to 2 2 – Added composer – Replaced phpexcel with phpSpreadsheet – Added Reparation in Client view modal – Added Links on Client Name And Reparation code – Remove Tax Rate Required Attribute – Add Assigned To field – Added Manufacturer field – Added 3 Reports And Invoice Templates – Add Barcode Generator for reparations – Added different views for completed pending repairs – Add autocompletion to defect category – Add expected close date – Add Imei to autofill repair details – Add numeric codes for repairs – And Much More Download v2 2 Take Database Files Backup Extract 2 2 files in place of 1 1 Copy application config database php from 1 1 backup to 2 2 Copy application config config php from 1 1 backup to 2 2 Copy assets uploads from 1 1 to 2 2 Create a folder named backgrounds in assets uploads Run the Update sql in PhpMyAdmin Download here otsglobal org cc_updates rms_pos Update 2 2 sql Change Log 1 1 Added Inventory Images Added Quick Add by Barcode in POS Added Categories Filter in POS Added Products Show with Pagination Bugs Removed Fixed Translations Home Page Permissions Added Postal Code Field for clients Added Parsley JS Form Validation Updated Codeigniter and AdminLTE Download v1 1 Backup your current rms_application files v1 0 and export current database as sql as pre-caution Delete v1 0 rms_application files and extract v1 1 as replacement Restore rms_application assets uploads logos rms_application assets uploads members folder from v1 0 Restore rms_application application config config php rms_application application config database php files from v1 0 Go to phpMyAdmin select your database and run the following SQL ALTER TABLE inventory ADD image TEXT NOT NULL AFTER isDeleted UPDATE inventory SET image no_image png WHERE 1 ALTER TABLE permissions ADD dashboard-qemail BOOLEAN NOT NULL AFTER categories-delete ADD dashboard-qsms BOOLEAN NOT NULL AFTER dashboard-qemail ALTER TABLE clients ADD postal_code VARCHAR 50 NOT NULL AFTER city UPDATE settings SET version 1 1 WHERE settings id 1 CREATE TABLE pos_settings id int 11 NOT NULL products_per_page int 11 NOT NULL product_button_color varchar 50 NOT NULL ENGINE InnoDB DEFAULT CHARSET latin1 INSERT INTO pos_settings id products_per_page product_button_color VALUES 1 10 default ALTER TABLE pos_settings ADD PRIMARY KEY id ALTER TABLE pos_settings MODIFY id int 11 NOT NULL AUTO_INCREMENT AUTO_INCREMENT 2 Change Log 1 1 to 1 11 Added Translations Download v1 11 Replace downloaded 1 11 application languages folder in your server rms_folder 1 1 Replace downloaded 1 11 application views _base foot php in your server rms_folder 1 1 Counter