Repairer – Repair Shop Management System 3.8
Repairer – Repair/Workshop Management System is rigorously developed for straightforward administration of any kind of repairshop/workshop. It’s really an progressive, easy and highly effective administration instrument, designed and developed for you. It’s simply your trusty worker. It’s an internet based mostly system the place you’ll be able to handle reparations, purchasers, stock, purchases and so on.
Demo
Demo URL: Demo
Email: admin@admin.com
Password: password
SUPPORT: Support
Quick Installation Guide
Download .zip package deal
Upload it to your server
Extract the package deal
Run the uploaded url by way of browser (EXAMPLE.COM/RMS/INSTALL). Here it’s a must to present the settings for RMS:
- Hostname : database host identify / IP
- Database Name : create a mysql database for RMS in your host and write that identify right here
- Database username : username of the created database (if relevant)
- Database password : password of the created database
Backend – Admin:
- Dashboard (graphical report)
- General settings (system customization)
- Client administration
- Reparation administration
- Inventory Management
- Purchases Managment
- Taxes, Models, Categories and so on.
- Graphical Reports ( Stock & Finance )
Frontend:
- Reparation Status
- Login
Notification/ Alert System
Notify purchasers with their reparation standing by way of E-Mail or SMS
Documentation
Want to know extra about Repairer? Please learn our Documentation
How to Update
Change Log 3.6 to 3.8
- Download v3.8
- Take Database & Files Backup.
- Extract 3.8 recordsdata rather than 3.6
- Copy software/config/database.php from 3.6 backup to 3.8
- Copy software/config/config.php from 3.6 backup to 3.8
- Copy belongings/uploads from 3.6 to 3.8
- Run following in phpMyAdmin:
UPDATE `settings` SET `model` = '3.8';
Change Log 3.5 to three.6
- Download v3.6
- Take Database & Files Backup.
- Extract 3.6 recordsdata rather than 3.5
- Copy software/config/database.php from 3.5 backup to three.6
- Copy software/config/config.php from 3.5 backup to three.6
- Copy belongings/uploads from 3.5 to three.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 `supplier` 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 `model` = '3.6'; UPDATE `settings` SET `hide_repair_fields` = '{"expected_close_date":"1","error_code":"1","date_of_purchase":"1","has_warranty":"1","guarantee":"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.0 to three.5
- Download v3.5
- Take Database & Files Backup.
- Extract 3.5 recordsdata rather than 3.0
- Copy software/config/database.php from 3.0 backup to three.5
- Copy software/config/config.php from 3.0 backup to three.5
- Copy belongings/uploads from 3.0 to three.5
- Run the Update35.sql in PhpMyAdmin. Download right here: otsglobal.org/cc_updates/rms/Update35.sql
Change Log 2.2 to three.0
- Add Image in Inventory Table - Fix Barcode Problem in Print Barcodes Inventory - Update Repair Statuses (Completed checkbox factor) - Fix any calculation challenge for repairs with tax - Settings -> order & reparation -> classes: can add class however disappears after saving - Purchases -> obtain pdf : rounds up numbers, 2 decimals can be wanted - modifying purchases: When it was arrange as ordered and I'm going again modifying to mark it as arrived or making an attempt to do any modifications to it its not attainable - POS Open/Close Drawer completely different cash in settings - Add SMSInfo.API android Gateway - Add Original Nexmo API - Add Pattern/Pin Lock System - Warranty System - Document Sign - Calendar Widget present repairs too - Add Reparation ITEMS change amount and worth - Add Reparation Payments - Add Sales Payments. - Remove Advance Scene - Add Paid System - Import/Export Systems Customers - Forgot password e-mail system - Activity Log - Add Table State Save based mostly on customers - customized sms api operate. - Permission Lang - And the tax just isn't showing in POS bill. - Change standing instantly from desk - And Much More
- Download v3.0
- Take Database & Files Backup.
- Extract 3.0 recordsdata rather than 2.2
- Copy software/config/database.php from 2.2 backup to three.0
- Copy software/config/config.php from 2.2 backup to three.0
- Copy belongings/uploads from 2.2 to three.0
- Create a folder named “indicators” in belongings/uploads
- Run the Update30.sql in PhpMyAdmin. Download right here: otsglobal.org/cc_updates/rms/Update30.sql
Change Log 2.2 to 2.3
- Fixed some bugs
- Download v2.3
- Take Database & Files Backup.
- Extract 2.3 recordsdata rather than 2.2
- Copy software/config/database.php from 2.2 backup to 2.3
- Copy software/config/config.php from 2.2 backup to 2.3
- Copy belongings/uploads from 2.2 to 2.3
- open software/config/config.php and change
$config['composer_autoload'] = TRUE;
with
$config['composer_autoload'] = FCPATH.'vendor/autoload.php';
on line 140
- Run the next SQL in PhpMyAdmin:
UPDATE `settings` SET `model` = '2.3' WHERE `settings`.`id` = 1;
Change Log 2.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 area - Added Manufacturer area - Added 3 Reports And Invoice Templates - Add Barcode Generator for reparations - Added completely different views for accomplished & pending repairs - Add autocompletion to defect & class - Add anticipated shut date - Add Imei to autofill restore particulars - Add numeric codes for repairs - And Much More
- Download v2.2
- Take Database & Files Backup.
- Extract 2.2 recordsdata rather than 2.1
- Copy software/config/database.php from 2.1 backup to 2.2
- Copy software/config/config.php from 2.1 backup to 2.2
- Copy belongings/uploads from 2.1 to 2.2
- Create a folder named “backgrounds” in belongings/uploads
- Run the Update.sql in PhpMyAdmin. Download right here: otsglobal.org/cc_updates/rms/Update 2.2.sql
Change Log 2.0 to 2.1
- Fix jQuery in templates - Tax on Total + Service Charge in Repair - Add Theme Module - And Bug Fixes
- Download v2.1
- Take Database & Files Backup.
- Extract 2.1 recordsdata rather than 2.0
- Copy software/config/database.php from 2.0 backup to 2.1
- Copy software/config/config.php from 2.0 backup to 2.1
- Copy belongings/uploads from 2.0 to 2.1
- open index.php change
$view_folder = '';
change it to$view_folder = 'themes';
- Run SQLs in PhpMyAdmin
ALTER TABLE `settings` ADD `theme` VARCHAR(100) NOT NULL AFTER `use_topbar`;
UPDATE `settings` SET `theme` = 'adminlte';
UPDATE `settings` SET `model` = ‘2.1’;
Change Log 1.71 to 2.0
- Add Dark Theme - Add Image for shopper - ADD Google GEOLOCATE - Add Google RECAPTCHA - MPDF PDF CREATION FIX for PHP 7 - Add Actions Button apart from easy buttons - Reparation Log - Add Calendar - Add Diagnostics Field - Add Excel, PDF Export And Column VISIBILITY - Add Logo in Invoice, Report - CSS FIXES and Body Font - Appearance Tab — like JR - Add Search Reparation in Side Menu - CHANGE SMS/EMAIL SEND BTN Location - Add Gallery for Repair - Like JR - Add Assigned To area in repairer - Add Date Adder for feedback - ADD SETTINGS LINKS IN TOP NAVIGATION - Like JR - ADD QUICK ADD ETC in prime nav - Fix Barcode - print Label
- Download v2.0
- Take Database & Files Backup.
- Extract 2.0 recordsdata rather than 1.71
- Copy software/config/database.php from 1.71 backup to 2.0
- Copy software/config/config.php from 1.71 backup to 2.0
- now open software/config/config.php and alter line 140 from
- Copy belongings/uploads from 1.71 to 2.0
- Create folder named “photographs” in /belongings/uploads
- Run the Update.sql in PhpMyAdmin. Download right here: otsglobal.org/cc_updates/rms/Update 2.0.sql
$config['composer_autoload'] = FALSE;
TO
$config['composer_autoload'] = TRUE;
Change Log 1.7 to 1.71
— Added Translations
- Download v1.71
- Replace downloaded 1.71 software/languages folder in your server rms_folder (1.7)
- Replace downloaded 1.71 software/views/_base/foot.php in your server rms_folder (1.7)
Change Log 1.6 to 1.71
— Added Inventory Images
- Download v1.7
- Backup your present rms_application recordsdata (v1.6) and export present database as sql (as pre-warning).
- Delete v1.6 rms_application recordsdata and extract v1.7 as substitute
- Restore rms_application/belongings/uploads/logos & rms_application/belongings/uploads/members folder from v1.6
- Restore rms_application/software/config/config.php, rms_application/software/config/database.php recordsdata from v1.6
- Go to phpMyAdmin , choose your database and run the next SQL:
ALTER TABLE `stock` ADD `picture` TEXT NOT NULL AFTER `isDeleted`;
UPDATE `stock` SET `picture`="no_image.png" WHERE 1;
UPDATE `settings` SET `model` = '1.7' WHERE `settings`.`id` = 1;
Change Log 1.6
— Bugs Removed — Fixed Translations — Home Page Permissions — Added Postal Code Field for purchasers — Added Parsley.JS Form Validation — Updated Codeigniter and AdminLTE
- Download v1.6
- Backup your present rms_application recordsdata (v1.5) and export present database as sql (as pre-warning).
- Delete v1.5 rms_application recordsdata and extract v1.6 as substitute
- Restore rms_application/belongings/uploads/logos & rms_application/belongings/uploads/members folder from v1.5
- Restore rms_application/software/config/config.php, rms_application/software/config/database.php recordsdata from v1.5
- Go to phpMyAdmin , choose your database and run the next SQL:
ALTER TABLE `permissions` ADD `dashboard-qemail` BOOLEAN NOT NULL AFTER `classes-delete`, ADD `dashboard-qsms` BOOLEAN NOT NULL AFTER `dashboard-qemail`;
ALTER TABLE `purchasers` ADD `postal_code` VARCHAR(50) NOT NULL AFTER `metropolis`;
UPDATE `settings` SET `model` = '1.60' WHERE `settings`.`id` = 1;
Update – v1.3 to v1.4
Change Log 1.40
— Added USER Permissions — Added e-mail notifications - add for each standing; — Added area - by from provider - Inventory product — Updated SMS Library — fastened informationTables search — Added classes And Much More.
- Download v1.4
- Backup your present rms_application recordsdata (v1.3) and export present database as sql (as pre-warning).
- Delete v1.3 rms_application recordsdata and extract v1.4 as substitute
- Restore rms_application/belongings/uploads/logos & rms_application/belongings/uploads/members folder from v1.3
- Restore rms_application/software/config/config.php, rms_application/software/config/database.php recordsdata from v1.3
- Go to phpMyAdmin , choose your database and run the next SQL:
CREATE TABLE `classes` (
`id` int(11) NOT NULL,
`code` varchar(55) NOT NULL,
`identify` varchar(55) NOT NULL,
`picture` varchar(55) DEFAULT NULL,
`parent_id` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
ALTER TABLE `stock` DROP `class`;
ALTER TABLE `stock` ADD `category_id` INT NOT NULL AFTER `model_name`, ADD `class` VARCHAR(250) NOT NULL AFTER `category_id`, ADD `subcategory_id` INT NULL AFTER `class`, ADD `subcategory` VARCHAR(250) NULL AFTER `subcategory_id`;
ALTER TABLE `stock` ADD `provider` VARCHAR(250) NOT NULL AFTER `subcategory`, ADD `supplier_id` INT NOT NULL AFTER `provider`;
CREATE TABLE `permissions` (
`id` int(11) NOT NULL,
`group_id` int(11) NOT NULL,
`restore-index` tinyint(1) NOT NULL,
`restore-add` tinyint(1) NOT NULL,
`restore-edit` tinyint(1) NOT NULL,
`restore-delete` tinyint(1) NOT NULL,
`restore-view_repair` tinyint(1) NOT NULL,
`clients-delete` tinyint(1) NOT NULL,
`clients-view_customer` tinyint(1) NOT NULL,
`clients-index` tinyint(1) NOT NULL,
`clients-add` tinyint(1) NOT NULL,
`clients-edit` tinyint(1) NOT NULL,
`stock-index` tinyint(1) NOT NULL,
`stock-add` tinyint(1) NOT NULL,
`stock-edit` tinyint(1) NOT NULL,
`stock-delete` tinyint(1) NOT NULL,
`stock-print_barcodes` tinyint(1) NOT NULL,
`stock-product_actions` tinyint(1) NOT NULL,
`stock-suppliers` tinyint(1) NOT NULL,
`stock-add_supplier` tinyint(1) NOT NULL,
`stock-edit_supplier` tinyint(1) NOT NULL,
`stock-delete_supplier` tinyint(1) NOT NULL,
`stock-fashions` tinyint(1) NOT NULL,
`stock-add_model` tinyint(1) NOT NULL,
`stock-edit_model` tinyint(1) NOT NULL,
`stock-delete_model` tinyint(1) NOT NULL,
`purchases-index` tinyint(1) NOT NULL,
`purchases-add` tinyint(1) NOT NULL,
`purchases-edit` tinyint(1) NOT NULL,
`purchases-delete` tinyint(1) NOT NULL,
`auth-index` tinyint(1) NOT NULL,
`auth-create_user` tinyint(1) NOT NULL,
`auth-edit_user` tinyint(1) NOT NULL,
`auth-delete_user` tinyint(1) NOT NULL,
`stories-inventory` tinyint(1) NOT NULL,
`stories-finance` tinyint(1) NOT NULL,
`stories-quantity_alerts` tinyint(1) NOT NULL,
`auth-user_groups` tinyint(1) NOT NULL,
`auth-delete_group` tinyint(1) NOT NULL,
`auth-create_group` tinyint(1) NOT NULL,
`auth-edit_group` tinyint(1) NOT NULL,
`auth-permissions` tinyint(1) NOT NULL,
`utilities-index` tinyint(1) NOT NULL,
`utilities-backup_db` tinyint(1) NOT NULL,
`utilities-restore_db` tinyint(1) NOT NULL,
`utilities-remove_db` tinyint(1) NOT NULL,
`tax_rates-index` tinyint(1) NOT NULL,
`tax_rates-add` tinyint(1) NOT NULL,
`tax_rates-edit` tinyint(1) NOT NULL,
`tax_rates-delete` tinyint(1) NOT NULL,
`classes-index` tinyint(1) NOT NULL,
`classes-add` tinyint(1) NOT NULL,
`classes-edit` tinyint(1) NOT NULL,
`classes-delete` tinyint(1) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
INSERT INTO `permissions` (`id`, `group_id`, `restore-index`, `restore-add`, `restore-edit`, `restore-delete`, `restore-view_repair`, `clients-delete`, `clients-view_customer`, `clients-index`, `clients-add`, `clients-edit`, `stock-index`, `stock-add`, `stock-edit`, `stock-delete`, `stock-print_barcodes`, `stock-product_actions`, `stock-suppliers`, `stock-add_supplier`, `stock-edit_supplier`, `stock-delete_supplier`, `stock-fashions`, `stock-add_model`, `stock-edit_model`, `stock-delete_model`, `purchases-index`, `purchases-add`, `purchases-edit`, `purchases-delete`, `auth-index`, `auth-create_user`, `auth-edit_user`, `auth-delete_user`, `stories-inventory`, `stories-finance`, `stories-quantity_alerts`, `auth-user_groups`, `auth-delete_group`, `auth-create_group`, `auth-edit_group`, `auth-permissions`, `utilities-index`, `utilities-backup_db`, `utilities-restore_db`, `utilities-remove_db`, `tax_rates-index`, `tax_rates-add`, `tax_rates-edit`, `tax_rates-delete`, `classes-index`, `classes-add`, `classes-edit`, `classes-delete`) VALUES
(2, 4, 1, 1, 1, 1, 1, 1, 1, 0, 0, 1, 1, 1, 1, 1, 1, 0, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 0, 0, 1, 1, 1, 0, 0, 1, 0, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1);
ALTER TABLE settings ADD `r_inprogress` longtext COLLATE utf8_unicode_ci NOT NULL;
ALTER TABLE settings ADD `r_approved` longtext COLLATE utf8_unicode_ci NOT NULL;
ALTER TABLE settings ADD `r_tobedeliver` longtext COLLATE utf8_unicode_ci NOT NULL;
ALTER TABLE settings ADD `r_delivered` longtext COLLATE utf8_unicode_ci NOT NULL;
ALTER TABLE settings ADD `r_cancelled` longtext COLLATE utf8_unicode_ci NOT NULL;
ALTER TABLE settings ADD `r_tobeapproved` longtext COLLATE utf8_unicode_ci NOT NULL;
ALTER TABLE `settings` ADD `rows_per_page` INT NOT NULL AFTER `model_based_search`;
UPDATE `settings` SET `rows_per_page` = '10' WHERE `settings`.`id` = 1;
ALTER TABLE `settings` ADD `iwidth` INT NOT NULL AFTER `rows_per_page`, ADD `iheight` INT NOT NULL AFTER `iwidth`, ADD `twidth` INT NOT NULL AFTER `iheight`, ADD `theight` INT NOT NULL AFTER `twidth`, ADD `watermark` BOOLEAN NOT NULL AFTER `theight`;
UPDATE `settings` SET `iwidth` = '800', `iheight` = '800', `twidth` = '150', `theight` = '150' WHERE `settings`.`id` = 1;
ALTER TABLE `classes`
ADD PRIMARY KEY (`id`),
ADD KEY `id` (`id`);
ALTER TABLE `permissions`
ADD PRIMARY KEY (`id`),
ADD KEY `id` (`id`);
ALTER TABLE `classes`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
ALTER TABLE `permissions`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
UPDATE `settings` SET `r_inprogress` = 'Hello %buyer%, your order/restore for %mannequin% was opened by %businessname%. Check the state of restore anytime on %site_url%.' WHERE `settings`.`id` =1;
UPDATE `settings` SET `r_approved` = 'Hello %buyer%, your order/restore for %mannequin% was accredited. ' WHERE `settings`.`id` =1;
UPDATE `settings` SET `r_tobedeliver` = 'Hello %buyer%, your order/restore for %mannequin% was opened by %businessname%. Check the state of restore anytime on %site_url%.' WHERE `settings`.`id` =1;
UPDATE `settings` SET `r_delivered` = 'Hello %buyer%, your order/restore for %mannequin% was delivered by %businessname%. ' WHERE `settings`.`id` =1;
UPDATE `settings` SET `r_cancelled` = 'Hello %buyer%, your order/restore for %mannequin% was cancelled. ' WHERE `settings`.`id` =1;
UPDATE `settings` SET `r_tobeapproved` = 'Hello %buyer%, your order/restore for %mannequin% have to be accredited ' WHERE `settings`.`id` =1;
Update – v1.3 to v1.4
Change Log 1.40
— Added Unlimited Repair Statuses
- Download v1.41
- Backup your present rms_application recordsdata (v1.4) and export present database as sql (as pre-warning).
- Delete v1.4 rms_application recordsdata and extract v1.41 as substitute
- Restore rms_application/belongings/uploads/logos & rms_application/belongings/uploads/members folder from v1.4
- Restore rms_application/software/config/config.php, rms_application/software/config/database.php recordsdata from v1.4
- Go to phpMyAdmin , choose your database and run the next SQL:
UPDATE reparation SET standing = 10 WHERE standing = 3;
UPDATE reparation SET standing = 11 WHERE standing = 2;
UPDATE reparation SET standing = 12 WHERE standing = 0;
UPDATE reparation SET standing = 13 WHERE standing = 5;
UPDATE reparation SET standing = 2 WHERE standing = 10;
UPDATE reparation SET standing = 3 WHERE standing = 11;
UPDATE reparation SET standing = 4 WHERE standing = 12;
UPDATE reparation SET standing = 0 WHERE standing = 13;
CREATE TABLE IF NOT EXISTS `standing` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`label` varchar(150) NOT NULL,
`bg_color` varchar(50) NOT NULL,
`fg_color` varchar(50) NOT NULL,
`place` int(11) NOT NULL,
`send_sms` tinyint(1) NOT NULL,
`send_email` tinyint(1) NOT NULL,
`sms_text` textual content,
`email_text` textual content,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;
INSERT INTO `standing` (`id`, `label`, `bg_color`, `fg_color`, `place`, `send_sms`, `send_email`, `sms_text`, `email_text`) VALUES
(1, 'In Progress', '#000000', '#ffffff', 1, 0, 1, NULL, 'Hello %buyer%, your order/restore for %mannequin% was opened by %businessname%. Check the state of restore anytime on %site_url%.'),
(2, 'To Be Approved', '#ff0000', '#ffffff', 2, 0, 1, NULL, 'Hello %buyer%, your order/restore for %mannequin% have to be accredited '),
(3, 'Job performed! able to ship', '#692121', '#ffffff', 3, 0, 1, NULL, 'Hello %buyer%, your order/restore for %mannequin% was opened by %businessname%. Check the state of restore anytime on %site_url%.'),
(4, 'Delivered', '#1be323', '#000000', 4, 0, 1, NULL, 'Hello %buyer%, your order/restore for %mannequin% was delivered by %businessname%. ');
Update – v1.2 to v1.3
- Download v1.3
- Backup your present rms_application recordsdata (v1.2) and export present database as sql (as pre-warning).
- Delete v1.2 rms_application recordsdata and extract v1.3 as substitute
- Restore rms_application/belongings/uploads folder from v1.2
(Delete present rms_application/belongings/uploads folder and paste v1.2’s rms_application/belongings/uploads as substitute from backup.) - Restore rms_application/software/config/config.php, rms_application/software/config/database.php recordsdata from v1.2
- Go to phpMyAdmin , choose your database and run the next SQL:
ALTER TABLE `reparation` ADD `imei` TEXT NOT NULL AFTER `date_closing`;
ALTER TABLE `settings` ADD `model_based_search` BOOLEAN NOT NULL AFTER `model`;
UPDATE `settings` SET `model` = '1.30' WHERE `settings`.`id` = 1;
Change Log 1.30
Quantity Increase Bug Fixed delete affirmation added added IMEI area fastened Responsive Tables Front Page Translation added Russian Translation added Menu Translation added Import/Export Feature added Repair create with out including faulty gadgets Alert Quantity added And Much More.