Repairer – 维修店管理系统 3.8

维修商 – 维修/车间管理系统经过精心开发，可轻松管理任何类型的维修店/车间。它实际上是一个创新、简单而强大的管理工具，专为您设计和开发。这只是您值得信赖的员工。这是一个基于 Web 的系统，您可以在其中管理赔偿、客户、库存、购买等。

演示

演示 URL：演示
电子邮件： admin@admin.com
Password：密码
支持：支持

快速安装指南

下载 .zip 包
将其上传到您的服务器
解压缩包
通过浏览器运行上传的 URL （EXAMPLE.COM/RMS/INSTALL）。在这里，您必须提供 RMS 的设置：

主机名：数据库主机名 / IP
数据库名称：在主机上为 RMS 创建一个 mysql 数据库，并在此处写入该名称
Database username ：已创建数据库的用户名（如果适用）
Database password ：创建的数据库的密码

后端 – 管理员：

仪表板（图形报告）
常规设置（系统自定义）
客户端管理
赔偿管理
库存管理
采购管理
税金、型号、类别等。
图形报告（股票和财务）

前端：

赔偿状态
登录

通知/警报系统

通过电子邮件或短信通知客户他们的赔偿状态

文档

想了解更多关于 Repairer 的信息？请阅读我们的文档

如何更新

将日志 3.6 改为 3.8

下载 v3.8
进行数据库和文件备份。
提取 3.8 文件代替 3.6
将 application/config/database.php 从 3.6 备份复制到 3.8
将 application/config/config.php 从 3.6 备份复制到 3.8
将资产/上传从 3.6 复制到 3.8
在 phpMyAdmin 中运行以下内容：

UPDATE `settings` SET `version` = '3.8';

将日志 3.5 改为 3.6

下载 v3.6
进行数据库和文件备份。
提取 3.6 文件代替 3.5
将 application/config/database.php 从 3.5 备份复制到 3.6
将 application/config/config.php 从 3.5 备份复制到 3.6
将资产/上传从 3.5 复制到 3.6
在 PhpMyAdmin 中运行 following。

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`)

将日志 3.0 更改为 3.5

下载 v3.5
进行数据库和文件备份。
提取 3.5 文件代替 3.0
将 application/config/database.php 从 3.0 备份复制到 3.5
将 application/config/config.php 从 3.0 备份复制到 3.5
将资产/上传从 3.0 复制到 3.5
在 PhpMyAdmin 中运行 Update35.sql。在此处下载：otsglobal.org/cc_updates/rms/Update35.sql

将日志 2.2 改为 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

下载 v3.0
进行数据库和文件备份。
提取 3.0 文件代替 2.2
将 application/config/database.php 从 2.2 备份复制到 3.0
将 application/config/config.php 从 2.2 备份复制到 3.0
将资产/上传从 2.2 复制到 3.0
在 assets/uploads 中创建名为 “signs” 的文件夹
在 PhpMyAdmin 中运行 Update30.sql。在此处下载：otsglobal.org/cc_updates/rms/Update30.sql

将日志 2.2 更改为 2.3

- Fixed some bugs

下载 v2.3
进行数据库和文件备份。
提取 2.3 文件代替 2.2
将 application/config/database.php 从 2.2 备份复制到 2.3
将 application/config/config.php 从 2.2 备份复制到 2.3
将资产/上传从 2.2 复制到 2.3

打开 application/config/config.php 并将

$config['composer_autoload'] = TRUE;

跟

$config['composer_autoload'] = FCPATH.'vendor/autoload.php';

在线 140

在 PhpMyAdmin 中运行以下 SQL：

UPDATE `settings` SET `version` = '2.3' WHERE `settings`.`id` = 1;

将记录 2.1 改为 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

下载 v2.2
进行数据库和文件备份。
提取 2.2 文件代替 2.1
将 application/config/database.php 从 2.1 备份复制到 2.2
将 application/config/config.php 从 2.1 备份复制到 2.2
将资产/上传从 2.1 复制到 2.2
在 assets/uploads 中创建名为 “backgrounds” 的文件夹
在 PhpMyAdmin 中运行 Update.sql。在此处下载：otsglobal.org/cc_updates/rms/Update 2.2.sql

将日志 2.0 改为 2.1

- Fix jQuery in templates
- Tax on Total + Service Charge in Repair
- Add Theme Module
- And Bug Fixes

下载 v2.1
进行数据库和文件备份。
提取 2.1 文件代替 2.0
将 application/config/database.php 从 2.0 备份复制到 2.1
将 application/config/config.php 从 2.0 备份复制到 2.1
将资产/上传从 2.0 复制到 2.1
打开 index.php 更改 $view_folder = ''; 将其更改为$view_folder = 'themes';
在 PhpMyAdmin 中运行 SQL

ALTER TABLE `settings` ADD `theme` VARCHAR(100) NOT NULL AFTER `use_topbar`; UPDATE `settings` SET `theme` = 'adminlte'; UPDATE `settings` SET `version` = ‘2.1’;

将日志 1.71 更改为 2.0

- Add Dark Theme
- Add Image for client
- ADD Google GEOLOCATE
- Add Google RECAPTCHA
- MPDF PDF CREATION FIX for PHP 7
- Add Actions Button other than simple 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 field in repairer
- Add Date Adder for comments
- ADD SETTINGS LINKS IN TOP NAVIGATION - Like JR
- ADD QUICK ADD ETC in top nav
- Fix Barcode - print Label

下载 v2.0
进行数据库和文件备份。
提取 2.0 文件代替 1.71
将 application/config/database.php 从 1.71 备份复制到 2.0
将 application/config/config.php 从 1.71 备份复制到 2.0
现在打开 application/config/config.php 并将第 140 行从

 
  $config['composer_autoload'] = FALSE;

自

 
  $config['composer_autoload'] = TRUE;

将资产/上传从 1.71 复制到 2.0
在 /assets/uploads 中创建名为“images”的文件夹
在 PhpMyAdmin 中运行 Update.sql。在此处下载：otsglobal.org/cc_updates/rms/Update 2.0.sql

将日志 1.7 改为 1.71

— Added Translations

下载 v1.71
替换服务器中下载的 1.71 application/languages 文件夹 rms_folder （1.7）
将下载的 1.71 application/views/_base/foot.php 替换为服务器 rms_folder （1.7）

将日志 1.6 更改为 1.71

— Added Inventory Images

下载 v1.7
备份您当前的 rms_application 文件（v1.6）并将当前数据库导出为 sql（作为预防措施）。
删除 v1.6 rms_application 文件并提取 v1.7 作为替换文件
从v1.6恢复rms_application/assets/uploads/logos和rms_application/assets/uploads/members文件夹
从 v1.6 恢复 rms_application/application/config/config.php， rms_application/application/config/database.php 文件
转到 phpMyAdmin ，选择您的数据库并运行以下 SQL：

ALTER TABLE `inventory` ADD `image` TEXT NOT NULL AFTER `isDeleted`; UPDATE `inventory` SET `image`="no_image.png" WHERE 1; UPDATE `settings` SET `version` = '1.7' WHERE `settings`.`id` = 1;

更新日志 1.6

— Bugs Removed
— Fixed Translations
— Home Page Permissions
— Added Postal Code Field for clients
— Added Parsley.JS Form Validation
— Updated Codeigniter and AdminLTE

下载 v1.6
备份您当前的 rms_application 文件（v1.5）并将当前数据库导出为 sql（作为预防措施）。
删除 v1.5 rms_application 文件并提取 v1.6 作为替换文件
从v1.5恢复rms_application/assets/uploads/logos和rms_application/assets/uploads/members文件夹
从 v1.5 恢复 rms_application/application/config/config.php， rms_application/application/config/database.php 文件
转到 phpMyAdmin ，选择您的数据库并运行以下 SQL：

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.60' WHERE `settings`.`id` = 1;

更新 – v1.3 到 v1.4

更新日志 1.40

— Added USER Permissions 
— Added email notifications  - add for every status;
— Added field - by from supplier - Inventory product
— Updated SMS Library
— fixed dataTables search
— Added categories
And Much More.

下载 v1.4
备份当前 rms_application 文件（v1.3）并将当前数据库导出为 sql（作为预防措施）。
删除 v1.3 rms_application 文件并提取 v1.4 作为替换
从v1.3恢复rms_application/assets/uploads/logos和rms_application/assets/uploads/members文件夹
从 v1.3 恢复 rms_application/application/config/config.php， rms_application/application/config/database.php 文件
转到 phpMyAdmin ，选择您的数据库并运行以下 SQL：

CREATE TABLE `categories` ( `id` int(11) NOT NULL, `code` varchar(55) NOT NULL, `name` varchar(55) NOT NULL, `image` varchar(55) DEFAULT NULL, `parent_id` int(11) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8;


ALTER TABLE `inventory` DROP `category`;

ALTER TABLE `inventory` ADD `category_id` INT NOT NULL AFTER `model_name`, ADD `category` VARCHAR(250) NOT NULL AFTER `category_id`, ADD `subcategory_id` INT NULL AFTER `category`, ADD `subcategory` VARCHAR(250) NULL AFTER `subcategory_id`;

ALTER TABLE `inventory` ADD `supplier` VARCHAR(250) NOT NULL AFTER `subcategory`, ADD `supplier_id` INT NOT NULL AFTER `supplier`;
CREATE TABLE `permissions` (

  `id` int(11) NOT NULL,

  `group_id` int(11) NOT NULL,

  `repair-index` tinyint(1) NOT NULL,

  `repair-add` tinyint(1) NOT NULL,

  `repair-edit` tinyint(1) NOT NULL,

  `repair-delete` tinyint(1) NOT NULL,

  `repair-view_repair` tinyint(1) NOT NULL,

  `customers-delete` tinyint(1) NOT NULL,

  `customers-view_customer` tinyint(1) NOT NULL,

  `customers-index` tinyint(1) NOT NULL,

  `customers-add` tinyint(1) NOT NULL,

  `customers-edit` tinyint(1) NOT NULL,

  `inventory-index` tinyint(1) NOT NULL,

  `inventory-add` tinyint(1) NOT NULL,

  `inventory-edit` tinyint(1) NOT NULL,

  `inventory-delete` tinyint(1) NOT NULL,

  `inventory-print_barcodes` tinyint(1) NOT NULL,

  `inventory-product_actions` tinyint(1) NOT NULL,

  `inventory-suppliers` tinyint(1) NOT NULL,

  `inventory-add_supplier` tinyint(1) NOT NULL,

  `inventory-edit_supplier` tinyint(1) NOT NULL,

  `inventory-delete_supplier` tinyint(1) NOT NULL,

  `inventory-models` tinyint(1) NOT NULL,

  `inventory-add_model` tinyint(1) NOT NULL,

  `inventory-edit_model` tinyint(1) NOT NULL,

  `inventory-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,

  `reports-stock` tinyint(1) NOT NULL,

  `reports-finance` tinyint(1) NOT NULL,

  `reports-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,

  `categories-index` tinyint(1) NOT NULL,

  `categories-add` tinyint(1) NOT NULL,

  `categories-edit` tinyint(1) NOT NULL,

  `categories-delete` tinyint(1) NOT NULL

) ENGINE=InnoDB DEFAULT CHARSET=utf8;
INSERT INTO `permissions` (`id`, `group_id`, `repair-index`, `repair-add`, `repair-edit`, `repair-delete`, `repair-view_repair`, `customers-delete`, `customers-view_customer`, `customers-index`, `customers-add`, `customers-edit`, `inventory-index`, `inventory-add`, `inventory-edit`, `inventory-delete`, `inventory-print_barcodes`, `inventory-product_actions`, `inventory-suppliers`, `inventory-add_supplier`, `inventory-edit_supplier`, `inventory-delete_supplier`, `inventory-models`, `inventory-add_model`, `inventory-edit_model`, `inventory-delete_model`, `purchases-index`, `purchases-add`, `purchases-edit`, `purchases-delete`, `auth-index`, `auth-create_user`, `auth-edit_user`, `auth-delete_user`, `reports-stock`, `reports-finance`, `reports-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`, `categories-index`, `categories-add`, `categories-edit`, `categories-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 `categories`

  ADD PRIMARY KEY (`id`),

  ADD KEY `id` (`id`);

ALTER TABLE `permissions`

  ADD PRIMARY KEY (`id`),

  ADD KEY `id` (`id`);

ALTER TABLE `categories`

  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 %customer%, your order/repair for %model% was opened by %businessname%. Check the state of repair anytime on %site_url%.' WHERE `settings`.`id` =1; UPDATE `settings` SET `r_approved` = 'Hello %customer%, your order/repair for %model% was approved. ' WHERE `settings`.`id` =1; UPDATE `settings` SET `r_tobedeliver` = 'Hello %customer%, your order/repair for %model% was opened by %businessname%. Check the state of repair anytime on %site_url%.' WHERE `settings`.`id` =1; UPDATE `settings` SET `r_delivered` = 'Hello %customer%, your order/repair for %model% was delivered by %businessname%. ' WHERE `settings`.`id` =1; UPDATE `settings` SET `r_cancelled` = 'Hello %customer%, your order/repair for %model% was cancelled. ' WHERE `settings`.`id` =1; UPDATE `settings` SET `r_tobeapproved` = 'Hello %customer%, your order/repair for %model% need to be approved ' WHERE `settings`.`id` =1;

更新 – v1.3 到 v1.4

更新日志 1.40

— Added Unlimited Repair Statuses

下载 v1.41
备份您当前的 rms_application 文件（v1.4）并将当前数据库导出为 sql（作为预防措施）。
删除 v1.4 rms_application 文件并提取 v1.41 作为替换文件
从v1.4恢复rms_application/assets/uploads/logos和rms_application/assets/uploads/members文件夹
从 v1.4 恢复 rms_application/application/config/config.php， rms_application/application/config/database.php 文件
转到 phpMyAdmin ，选择您的数据库并运行以下 SQL：

UPDATE reparation SET status = 10 WHERE status = 3; UPDATE reparation SET status = 11 WHERE status = 2; UPDATE reparation SET status = 12 WHERE status = 0; UPDATE reparation SET status = 13 WHERE status = 5; UPDATE reparation SET status = 2 WHERE status = 10; UPDATE reparation SET status = 3 WHERE status = 11; UPDATE reparation SET status = 4 WHERE status = 12; UPDATE reparation SET status = 0 WHERE status = 13; CREATE TABLE IF NOT EXISTS `status` ( `id` int(11) NOT NULL AUTO_INCREMENT, `label` varchar(150) NOT NULL, `bg_color` varchar(50) NOT NULL, `fg_color` varchar(50) NOT NULL, `position` int(11) NOT NULL, `send_sms` tinyint(1) NOT NULL, `send_email` tinyint(1) NOT NULL, `sms_text` text, `email_text` text, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;

INSERT INTO `status` (`id`, `label`, `bg_color`, `fg_color`, `position`, `send_sms`, `send_email`, `sms_text`, `email_text`) VALUES (1, 'In Progress', '#000000', '#ffffff', 1, 0, 1, NULL, 'Hello %customer%, your order/repair for %model% was opened by %businessname%. Check the state of repair anytime on %site_url%.'), (2, 'To Be Approved', '#ff0000', '#ffffff', 2, 0, 1, NULL, 'Hello %customer%, your order/repair for %model% need to be approved '), (3, 'Job done! ready to deliver', '#692121', '#ffffff', 3, 0, 1, NULL, 'Hello %customer%, your order/repair for %model% was opened by %businessname%. Check the state of repair anytime on %site_url%.'), (4, 'Delivered', '#1be323', '#000000', 4, 0, 1, NULL, 'Hello %customer%, your order/repair for %model% was delivered by %businessname%. ');
更新 – v1.2 到 v1.3

下载 v1.3
备份您当前的 rms_application 文件（v1.2）并将当前数据库导出为 sql（作为预防措施）。
删除 v1.2 rms_application 文件并提取 v1.3 作为替换文件
从 v1.2 恢复 rms_application/assets/uploads 文件夹
（删除当前的 rms_application/assets/uploads 文件夹，并粘贴 v1.2 的 rms_application/assets/uploads 作为备份中的替换。
从 v1.2 恢复 rms_application/application/config/config.php， rms_application/application/config/database.php 文件
转到 phpMyAdmin ，选择您的数据库并运行以下 SQL：

ALTER TABLE `reparation` ADD `imei` TEXT NOT NULL AFTER `date_closing`; ALTER TABLE `settings` ADD `model_based_search` BOOLEAN NOT NULL AFTER `version`; UPDATE `settings` SET `version` = '1.30' WHERE `settings`.`id` = 1;

更新日志 1.30

Quantity Increase Bug Fixed
delete confirmation added
added IMEI field
fixed Responsive Tables 
Front Page Translation added
Russian Translation added
Menu Translation added
Import/Export Feature added
Repair create without adding defective items 
Alert Quantity added
And Much More.