Repairer – Repair Shop Management System With Point Of Sale 3.8

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: [email protected]
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:

1. Point Of Sale
2. Dashboard (graphical report)
3. General settings (system customization)
4. Client management
5. Reparation management
6. Inventory Management
7. Purchases Management
8. Taxes, Models, Categories etc.
9. Graphical Reports ( Stock & Finance )
10. Sales Reports
11. Drawer Reports
12. 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

1. Download v3.7
2. Take Database & Files Backup.
3. Extract 3.7 files in place of 3.6
4. Copy application/config/database.php from 3.6 backup to 3.7
5. Copy application/config/config.php from 3.6 backup to 3.7
6. Copy assets/uploads from 3.6 to 3.7
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

1. Download v3.6
2. Take Database & Files Backup.
3. Extract 3.6 files in place of 3.5
4. Copy application/config/database.php from 3.5 backup to 3.6
5. Copy application/config/config.php from 3.5 backup to 3.6
6. Copy assets/uploads from 3.5 to 3.6
7. 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

1. Download v3.5
2. Take Database & Files Backup.
3. Extract 3.5 files in place of 3.2
4. Copy application/config/database.php from 3.2 backup to 3.5
5. Copy application/config/config.php from 3.2 backup to 3.5
6. Copy assets/uploads from 3.2 to 3.5
7. 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

1. Download v3.2
2. Take Database & Files Backup.
3. Extract 3.2 files in place of 3.1
4. Copy application/config/database.php from 3.1 backup to 3.2
5. Copy application/config/config.php from 3.1 backup to 3.2
6. Copy assets/uploads from 3.1 to 3.2
7. 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

1. Download v3.1
2. Take Database & Files Backup.
3. Extract 3.1 files in place of 3.0
4. Copy application/config/database.php from 3.0 backup to 3.1
5. Copy application/config/config.php from 3.0 backup to 3.1
6. Copy assets/uploads from 3.0 to 3.1
7. 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

1. Download v3.0
2. Take Database & Files Backup.
3. Extract 3.0 files in place of 2.2
4. Copy application/config/database.php from 2.2 backup to 3.0
5. Copy application/config/config.php from 2.2 backup to 3.0
6. Copy assets/uploads from 2.2 to 3.0
7. Create a folder named “signs” in assets/uploads
8. 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

1. Download v2.2
2. Take Database & Files Backup.
3. Extract 2.2 files in place of 1.1
4. Copy application/config/database.php from 1.1 backup to 2.2
5. Copy application/config/config.php from 1.1 backup to 2.2
6. Copy assets/uploads from 1.1 to 2.2
7. Create a folder named “backgrounds” in assets/uploads
8. 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

1. Download v1.1
2. Backup your current rms_application files (v1.0) and export current database as sql (as pre-caution).
3. Delete v1.0 rms_application files and extract v1.1 as replacement
4. Restore rms_application/assets/uploads/logos & rms_application/assets/uploads/members folder from v1.0
5. Restore rms_application/application/config/config.php, rms_application/application/config/database.php files from v1.0
6. 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

1. Download v1.11
2. Replace downloaded 1.11 application/languages folder in your server rms_folder (1.1)
3. Replace downloaded 1.11 application/views/_base/foot.php in your server rms_folder (1.1)

Counter