PS-Store Android(v2.5) Version Released

Backend Change Logs

– Language Configuration Modified to use Database instead of language file (backend)
– Backend setting as New Feature to use Database instead of ps_config file(backend)
– Fix for shipping countries logic (api)
– Name Validation at Product Attribute Detail Edit case (backend)
– sending email with SMTP email
– when register user delete, all the related user will delete (backend)
– user id added to noti register and unregister ( Api )
– relate breadcrumb item with language ( backend )

Backend Effected Files

– application/core/API_Controller.php
– application/config/autoload.php
– application/config/config.php
– application/config/ps_config.php
– application/controllers/Main.php
– application/controllers/backend/Notis.php
– application/controllers/backend/Transactions.php
– application/controllers/rest/Commentheaders.php
– application/controllers/rest/Images.php
– application/core/BE_Controller.php
– application/core/My_Controller.php
– application/core/My_Model.php
– application/helpers/ps_helper.php
– application/helpers/ps_mail_helper.php
– application/language/english/index.html
– application/language/english/ps_lang.php
– application/libraries/PS_Mail.php
– application/models/Commentdetail.php
– application/views/backend/abouts/entry_form.php
– application/views/backend/attributedetails/entry_form.php
– application/views/backend/attributes/entry_form.php
– application/views/backend/attributes/search_form.php
– application/views/backend/blogs/entry_form.php
– application/views/backend/blogs/list.php
– application/views/backend/blogs/list_script.php
– application/views/backend/categories/entry_form.php
– application/views/backend/categories/list.php
– application/views/backend/categories/list_script.php
– application/views/backend/cities/entry_form.php
– application/views/backend/cities/list.php
– application/views/backend/cities/list_script.php
– application/views/backend/collections/entry_form.php
– application/views/backend/collections/list.php
– application/views/backend/collections/list_script.php
– application/views/backend/components/favicon_upload_modal.php
– application/views/backend/components/sidebar_logo_upload.php
– application/views/backend/countries/list.php
– application/views/backend/countries/list_script.php
– application/views/backend/coupons/list.php
– application/views/backend/coupons/list_script.php
– application/views/backend/discounts/entry_form.php
– application/views/backend/discounts/list.php
– application/views/backend/discounts/list_script.php
– application/views/backend/partials/header.php
– application/views/backend/partials/sidebar.php
– application/views/backend/products/entry_form.php
– application/views/backend/products/list.php
– application/views/backend/products/list_script.php
– application/views/backend/products/search_form.php
– application/views/backend/profile/entry_form.php
– application/views/backend/shipping_zones/entry_form.php
– application/views/backend/shipping_zones/list.php
– application/views/backend/shipping_zones/list_script.php
– application/views/backend/shippings/list.php
– application/views/backend/shippings/list_script.php
– application/views/backend/subcategories/entry_form.php
– application/views/backend/subcategories/list.php
– application/views/backend/subcategories/list_script.php
– application/views/backend/system_users/entry_form.php
– application/views/backend/tags/entry_form.php
– application/views/backend/tags/list.php
– application/views/backend/tags/list_script.php
– application/views/backend/zones/entry_form.php
– application/views/backend/zones/list.php
– application/views/backend/zones/list_script.php
– assets/backend/css/style.css
– uploads/shopping-cart.png
– application/controllers/backend/Backend_configs.php
– application/controllers/backend/Language_strings.php
– application/controllers/backend/Languages.php
– application/models/Backend_config.php
– application/models/Language.php
– application/models/Language_string.php
– application/views/backend/backend_configs/
– application/views/backend/components/delete_language_modal.php
– application/views/backend/components/warning_confirm_modal.php
– application/views/backend/language_strings/
– application/views/backend/languages/
– application/views/backend/partials/breadcrumb_language.php
– application/views/backend/partials/language_form.php
– application/views/backend/partials/language_list.php
– application/controllers/backend/Attributedetails.php
– uploads/login_background.png
– uploads/thumbnail/login_background.png
– application/controllers/backend/Backend_configs.php
– application/helpers/ps_helper.php
– application/libraries/PS_Mail.php
– application/views/backend/backend_configs/entry_form.php
– application/libraries/PS_Delete.php
– application/models/Touch.php
– application/models/Transactioncount.php
– application/models/Transactiondetail.php
– application/models/User.php
– applicationcontrollersrestNotis.php

SQL

Copy to Clipboard

CREATE TABLE mk_language ( id VARCHAR(255) NOT NULL , symbol VARCHAR(50) NOT NULL , name VARCHAR(255) NOT NULL , status TINYINT(1) NOT NULL , PRIMARY KEY (`id`)) ENGINE = InnoDB;

CREATE TABLE mk_language_string ( id VARCHAR(255) NOT NULL , language_id VARCHAR(255) NOT NULL , `key` VARCHAR(255) NOT NULL , value VARCHAR(255) NOT NULL , PRIMARY KEY (`id`)) ENGINE = InnoDB;

ALTER TABLE core_modules ADD module_lang_key VARCHAR(255) NOT NULL AFTER module_desc;

ALTER TABLE `core_menu_groups` ADD `group_lang_key` VARCHAR(255) NOT NULL AFTER `group_icon`;

INSERT INTO core_modules (`module_id`, module_name, module_desc, module_lang_key, module_icon, ordering, is_show_on_menu, `group_id`) VALUES ('38', 'languages', 'Languages', 'language_module', '', '10', '1', '6');

CREATE TABLE `core_backend_config` ( `id` varchar(255) NOT NULL,`sender_name` varchar(255) NOT NULL,`sender_email` varchar(255) NOT NULL, `receive_email` varchar(255) NOT NULL, `fcm_api_key` varchar(255) NOT NULL) ENGINE=InnoDB DEFAULT CHARSET=utf8;

ALTER TABLE `core_backend_config` ADD PRIMARY KEY (`id`);

INSERT INTO core_modules (`module_id`, module_name, module_desc, module_lang_key, module_icon, ordering, is_show_on_menu, `group_id`) VALUES ('39', 'backend_configs', 'Backend Setting','backend_setting_module', '', '10', '1', '6');

INSERT INTO `core_backend_config` (`id`, `sender_name`, `sender_email`, `receive_email`, `fcm_api_key`) VALUES ('be1', 'Team PS', 'admin@panacea-soft.com', 'teamps.is.cool@gmail.com', 'AIzaSyBSVKk7S3AIO20az0CzX9wkmb8Z_DCJ7Wo');

UPDATE `core_modules` SET `module_lang_key` = 'cat_module' WHERE `core_modules`.`module_id` = 1;
UPDATE `core_modules` SET `module_lang_key` = 'contact_module' WHERE `core_modules`.`module_id` = 3;
UPDATE `core_modules` SET `module_lang_key` = 'system_user_module' WHERE `core_modules`.`module_id` = 4;
UPDATE `core_modules` SET `module_lang_key` = 'export_database_module' WHERE `core_modules`.`module_id` = 9;
UPDATE `core_modules` SET `module_lang_key` = 'subcat_module' WHERE `core_modules`.`module_id` = 10;
UPDATE `core_modules` SET `module_lang_key` = 'discount_module' WHERE `core_modules`.`module_id` = 11;
UPDATE `core_modules` SET `module_lang_key` = 'blog_module' WHERE `core_modules`.`module_id` = 12;
UPDATE `core_modules` SET `module_lang_key` = 'product_module' WHERE `core_modules`.`module_id` = 13;
UPDATE `core_modules` SET `module_lang_key` = 'collection_module' WHERE `core_modules`.`module_id` = 14;
UPDATE `core_modules` SET `module_lang_key` = 'noti_module' WHERE `core_modules`.`module_id` = 15;
UPDATE `core_modules` SET `module_lang_key` = 'version_module' WHERE `core_modules`.`module_id` = 16;
UPDATE `core_modules` SET `module_lang_key` = 'comments_module' WHERE `core_modules`.`module_id` = 18;
UPDATE `core_modules` SET `module_lang_key` = 'like_module' WHERE `core_modules`.`module_id` = 19;
UPDATE `core_modules` SET `module_lang_key` = 'favourites_module' WHERE `core_modules`.`module_id` = 21;
UPDATE `core_modules` SET `module_lang_key` = 'transaction_module' WHERE `core_modules`.`module_id` = 22;
UPDATE `core_modules` SET `module_lang_key` = 'popular_prd_module' WHERE `core_modules`.`module_id` = 23;
UPDATE `core_modules` SET `module_lang_key` = 'popular_cat_module' WHERE `core_modules`.`module_id` = 25;
UPDATE `core_modules` SET `module_lang_key` = 'purchase_cat_module' WHERE `core_modules`.`module_id` = 26;
UPDATE `core_modules` SET `module_lang_key` = 'rate_prd_module' WHERE `core_modules`.`module_id` = 27;
UPDATE `core_modules` SET `module_lang_key` = 'coupon_dis_module' WHERE `core_modules`.`module_id` = 28;
UPDATE `core_modules` SET `module_lang_key` = 'shipping_module' WHERE `core_modules`.`module_id` = 29;
UPDATE `core_modules` SET `module_lang_key` = 'app_module' WHERE `core_modules`.`module_id` = 30;
UPDATE `core_modules` SET `module_lang_key` = 'shop_module' WHERE `core_modules`.`module_id` = 31;
UPDATE `core_modules` SET `module_lang_key` = 'register_user_module' WHERE `core_modules`.`module_id` = 32;
UPDATE `core_modules` SET `module_lang_key` = 'api_key_module' WHERE `core_modules`.`module_id` = 33;
UPDATE `core_modules` SET `module_lang_key` = 'countries_module' WHERE `core_modules`.`module_id` = 34;
UPDATE `core_modules` SET `module_lang_key` = 'cities_module' WHERE `core_modules`.`module_id` = 35;
UPDATE `core_modules` SET `module_lang_key` = 'zone_module' WHERE `core_modules`.`module_id` = 36;
UPDATE `core_modules` SET `module_lang_key` = 'shipping_zone_module' WHERE `core_modules`.`module_id` = 37;
UPDATE `core_modules` SET `module_lang_key` = 'language_module' WHERE `core_modules`.`module_id` = 38;
UPDATE `core_modules` SET `module_lang_key` = 'backend_setting_module' WHERE `core_modules`.`module_id` = 39;

UPDATE `core_menu_groups` SET `group_lang_key` = 'entry_group' WHERE `core_menu_groups`.`group_id` = 1;
UPDATE `core_menu_groups` SET `group_lang_key` = 'user_feedback_group' WHERE `core_menu_groups`.`group_id` = 2;
UPDATE `core_menu_groups` SET `group_lang_key` = 'user_mang_groups' WHERE `core_menu_groups`.`group_id` = 3;
UPDATE `core_menu_groups` SET `group_lang_key` = 'reports_group' WHERE `core_menu_groups`.`group_id` = 4;
UPDATE `core_menu_groups` SET `group_lang_key` = 'miscellaneous_group' WHERE `core_menu_groups`.`group_id` = 5;
UPDATE `core_menu_groups` SET `group_lang_key` = 'setting_group' WHERE `core_menu_groups`.`group_id` = 6;

ALTER TABLE `core_backend_config` ADD `smtp_enable` TINYINT(1) NOT NULL AFTER `fcm_api_key`;
ALTER TABLE `core_backend_config` ADD `smtp_host` VARCHAR(255) NOT NULL AFTER `smtp_enable`;
ALTER TABLE `core_backend_config` ADD `smtp_port` VARCHAR(255) NOT NULL AFTER `smtp_host`;
ALTER TABLE `core_backend_config` ADD `smtp_user` VARCHAR(255) NOT NULL AFTER `smtp_port`;
ALTER TABLE `core_backend_config` ADD `smtp_pass` VARCHAR(255) NOT NULL AFTER `smtp_user`;
ALTER TABLE `core_backend_config` ADD `topics` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL AFTER `fcm_api_key`;

UPDATE `core_backend_config` SET `smtp_enable` = '0', `smtp_host` = 'ssl://smtp.dreamhost.com', `smtp_port` = '587', `smtp_user` = 'sender@blog.panacea-soft.com', `smtp_pass` = '12345678' WHERE `core_backend_config`.`id` = 'be1';

ALTER TABLE mk_push_notification_tokens ADD user_id VARCHAR(255) NOT NULL AFTER os_type;

Android Change Logs

– Fixed notification on/off issue

Android Effected Files

updated : app/build.gradle
updated : app/src/main/java/com/panaceasoft/psstore/Config.java
updated : app/src/main/java/com/panaceasoft/psstore/MainActivity.java
updated : app/src/main/java/com/panaceasoft/psstore/api/PSApiService.java
updated : app/src/main/java/com/panaceasoft/psstore/repository/aboutus/AboutUsRepository.java
updated : app/src/main/java/com/panaceasoft/psstore/repository/common/NotificationTask.java
updated : app/src/main/java/com/panaceasoft/psstore/ui/common/NotificationTaskHandler.java
updated : app/src/main/java/com/panaceasoft/psstore/ui/notification/setting/NotificationSettingFragment.java
updated : app/src/main/java/com/panaceasoft/psstore/viewmodel/common/NotificationViewModel.java

Additional Files for Small Bug Fix

– application/controllers/rest/Users.php
– application/libraries/PS_Delete.php
– application/models/Notitoken.php