PS-Store Android (v1.5) Released Note

Backend Change Log

– Product Search by is_discount (backend)
– if product is in discount, show discount percent at product entry (backend)
– Add Terms & Conditions at About App (backend)
– Transaction Email send to shop admin and user (api)
– Sending code to user when new user register (api)
– User Request Verification code (api)
– User Email Verification (api)
– Countries CRUD (backend)
– Cities CRUD (backend)
– Zones CRUD (backend)
– Shipping With Zones CRUD (backend)
– Shipping Country By Shop id (api)
– Shipping City By Shop & Selected Country Id (api)
– Shipping Cost Calculation By Country and City (api)
– Discount Logic Changed (backend)

Mobile Change Log

– Added Setting to enable Facebook login
– Added Setting to enable Google login
– Added Contact Us
– Updated Language Selection UI
– Added T&C checkbox at register, facebook login and google login
– Added Count Badge in Basket Menu
– Fixed Blog Detail Scroll Issue
– Added Email Verification
– Added Phone Call Button on Shop Page
– Added Phone Call Button on Detail page
– Added App Version No at Setting
– Added 13 More Languages ( Hindi- India, Indonesian, Chinese, Portuguese, Turkish, Italian, Malay, German, Russian, Korean, Japanese, Thai )
– Added Terms & Policy Screen
– Added 3 more shipping method (cost per item, per order, no shipping)
– Added country and city selection
– Added product unit
– Added product minimum order value and checking at checkout
– Added shipping cost and tax in transaction detail

Effected Files For Android

– updated : app/build.gradle
– updated : app/src/main/AndroidManifest.xml
– 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/binding/FragmentBindingAdapters.java
– updated : app/src/main/java/com/panaceasoft/psstore/db/PSCoreDb.java
– updated : app/src/main/java/com/panaceasoft/psstore/di/AppComponent.java
– updated : app/src/main/java/com/panaceasoft/psstore/di/AppInjector.java
– updated : app/src/main/java/com/panaceasoft/psstore/di/AppModule.java
– updated : app/src/main/java/com/panaceasoft/psstore/di/MainActivityModule.java
– updated : app/src/main/java/com/panaceasoft/psstore/di/ViewModelModule.java
– updated : app/src/main/java/com/panaceasoft/psstore/repository/shippingmethod/ShippingMethodRepository.java
– updated : app/src/main/java/com/panaceasoft/psstore/repository/subcategory/SubCategoryRepository.java
– updated : app/src/main/java/com/panaceasoft/psstore/repository/user/UserRepository.java
– updated : app/src/main/java/com/panaceasoft/psstore/ui/basket/adapter/BasketAdapter.java
– updated : app/src/main/java/com/panaceasoft/psstore/ui/checkout/CheckoutActivity.java
– updated : app/src/main/java/com/panaceasoft/psstore/ui/checkout/CheckoutFragment1.java
– updated : app/src/main/java/com/panaceasoft/psstore/ui/checkout/CheckoutFragment2.java
– updated : app/src/main/java/com/panaceasoft/psstore/ui/checkout/CheckoutFragment3.java
– updated : app/src/main/java/com/panaceasoft/psstore/ui/checkout/CheckoutStatusFragment.java
– updated : app/src/main/java/com/panaceasoft/psstore/ui/checkout/adapter/ShippingMethodsAdapter.java
– updated : app/src/main/java/com/panaceasoft/psstore/ui/common/NavigationController.java
– updated : app/src/main/java/com/panaceasoft/psstore/ui/common/PSFragment.java
– updated : app/src/main/java/com/panaceasoft/psstore/ui/product/MainFragment.java
– updated : app/src/main/java/com/panaceasoft/psstore/ui/product/detail/ProductDetailFragment.java
– updated : app/src/main/java/com/panaceasoft/psstore/ui/product/filtering/FilterFragment.java
– updated : app/src/main/java/com/panaceasoft/psstore/ui/product/search/SearchByCategoryActivity.java
– updated : app/src/main/java/com/panaceasoft/psstore/ui/product/search/SearchFragment.java
– updated : app/src/main/java/com/panaceasoft/psstore/ui/transaction/detail/TransactionFragment.java
– updated : app/src/main/java/com/panaceasoft/psstore/ui/transaction/detail/adapter/TransactionAdapter.java
– updated : app/src/main/java/com/panaceasoft/psstore/ui/transaction/list/adapter/TransactionListAdapter.java
– updated : app/src/main/java/com/panaceasoft/psstore/ui/user/ProfileEditFragment.java
– updated : app/src/main/java/com/panaceasoft/psstore/ui/user/UserFBRegisterFragment.java
– updated : app/src/main/java/com/panaceasoft/psstore/ui/user/UserLoginFragment.java
– updated : app/src/main/java/com/panaceasoft/psstore/ui/user/UserRegisterFragment.java
– updated : app/src/main/java/com/panaceasoft/psstore/utils/Constants.java
– updated : app/src/main/java/com/panaceasoft/psstore/utils/FirebaseMessagingService.java
– updated : app/src/main/java/com/panaceasoft/psstore/viewmodel/category/CategoryViewModel.java
– updated : app/src/main/java/com/panaceasoft/psstore/viewmodel/shippingmethod/ShippingMethodViewModel.java
– updated : app/src/main/java/com/panaceasoft/psstore/viewmodel/subcategory/SubCategoryViewModel.java
– updated : app/src/main/java/com/panaceasoft/psstore/viewmodel/user/UserViewModel.java
– updated : app/src/main/java/com/panaceasoft/psstore/viewobject/Product.java
– updated : app/src/main/java/com/panaceasoft/psstore/viewobject/Shop.java
– updated : app/src/main/java/com/panaceasoft/psstore/viewobject/User.java
–
– created : app/src/main/java/com/panaceasoft/psstore/viewobject/ShippingCost.java
– created : app/src/main/java/com/panaceasoft/psstore/viewobject/ShippingCostContainer.java
– created : app/src/main/java/com/panaceasoft/psstore/viewobject/ShippingProductContainer.java
– created : app/src/main/java/com/panaceasoft/psstore/viewobject/ShippingZone.java
– created : app/src/main/java/com/panaceasoft/psstore/viewobject/City.java
– created : app/src/main/java/com/panaceasoft/psstore/viewobject/Country.java
– created : app/src/main/java/com/panaceasoft/psstore/ui/product/search/adapter/SearchCityAdapter.java
– created : app/src/main/java/com/panaceasoft/psstore/ui/product/search/adapter/SearchCountryAdapter.java
– created : app/src/main/java/com/panaceasoft/psstore/ui/product/search/SearchCityListFragment.java
– created : app/src/main/java/com/panaceasoft/psstore/ui/product/search/SearchCountryListFragment.java
– created : app/src/main/java/com/panaceasoft/psstore/repository/city/CityRepository.java
– created : app/src/main/java/com/panaceasoft/psstore/repository/country/CountryRepository.java
– created : app/src/main/java/com/panaceasoft/psstore/db/CityDao.java
– created : app/src/main/java/com/panaceasoft/psstore/db/CountryDao.java
– created : app/src/main/java/com/panaceasoft/psstore/viewmodel/city/CityViewModel.java
– created : app/src/main/java/com/panaceasoft/psstore/viewmodel/country/CountryViewModel.java
–
– rename : /src/main/java/com/panaceasoft/psstore/{Mokets.java=>PSApp.java}
–
– created : app/src/main/res/layout/item_search_city.xml
– created : app/src/main/res/layout/item_search_country.xml
– created : app/src/main/res/layout/fragment_search_city_list.xml
– created : app/src/main/res/layout/fragment_search_country_list.xml
– created : app/src/main/res/drawable-hdpi/app_icon.png
– created : app/src/main/res/drawable-mdpi/app_icon.png
– created : app/src/main/res/drawable-xhdpi/app_icon.png
– created : app/src/main/res/drawable-xxhdpi/app_icon.png
– created : app/src/main/res/drawable-xxxhdpi/app_icon.png
–
– updated : app/src/main/res/layout/activity_main.xml
– updated : app/src/main/res/layout/checkout_fragment_1.xml
– updated : app/src/main/res/layout/checkout_fragment_2.xml
– updated : app/src/main/res/layout/fragment_product_detail.xml
– updated : app/src/main/res/layout/fragment_profile_edit.xml
– updated : app/src/main/res/layout/fragment_search.xml
– updated : app/src/main/res/layout/fragment_shop_profile.xml
– updated : app/src/main/res/layout/fragment_transaction.xml
– updated : app/src/main/res/layout/fragment_user_forgot_password.xml
– updated : app/src/main/res/layout/fragment_user_login.xml
– updated : app/src/main/res/layout/fragment_user_register.xml
– updated : app/src/main/res/layout/item_search_category_adapter.xml
–
– created : app/src/main/res/layout/item_shipping_method.xml
– updated : app/src/main/res/values-ar/strings.xml
– created : app/src/main/res/values-de/strings.xml
– updated : app/src/main/res/values-es/strings.xml
– created : app/src/main/res/values-fr/strings.xml
– created : app/src/main/res/values-hi-rIN/strings.xml
– created : app/src/main/res/values-in/strings.xml
– created : app/src/main/res/values-it/strings.xml
– created : app/src/main/res/values-ja/strings.xml
– created : app/src/main/res/values-ko/strings.xml
– created : app/src/main/res/values-ms/strings.xml
– created : app/src/main/res/values-pt/strings.xml
– created : app/src/main/res/values-ru/strings.xml
– created : app/src/main/res/values-th/strings.xml
– created : app/src/main/res/values-tr/strings.xml
– created : app/src/main/res/values-zh/strings.xml
– updated : app/src/main/res/values/strings.xml
–
– updated : app/src/main/res/drawable-hdpi/baseline_circle_line_check_24.png
– updated : app/src/main/res/drawable-hdpi/baseline_circle_line_uncheck_24.png
– updated : app/src/main/res/drawable-mdpi/baseline_circle_line_check_24.png
– updated : app/src/main/res/drawable-mdpi/baseline_circle_line_uncheck_24.png
– updated : app/src/main/res/drawable-xhdpi/baseline_circle_line_check_24.png
– updated : app/src/main/res/drawable-xhdpi/baseline_circle_line_uncheck_24.png
– updated : app/src/main/res/drawable-xxhdpi/baseline_circle_line_check_24.png
– updated : app/src/main/res/drawable-xxhdpi/baseline_circle_line_uncheck_24.png
– updated : app/src/main/res/drawable-xxxhdpi/baseline_circle_line_check_24.png
– updated : app/src/main/res/drawable-xxxhdpi/baseline_circle_line_uncheck_24.png

Effected Files For Backend

– application/controllers/backend/Abouts.php
– application/controllers/backend/Products.php
– application/controllers/rest/Transactionheaders.php
– application/controllers/rest/Users.php
– application/core/My_Model.php
– application/helpers/ps_helper.php
– application/helpers/ps_mail_helper.php
– application/models/User.php
– application/views/backend/abouts/entry_form.php
– application/views/backend/products/entry_form.php
– application/views/backend/products/search_form.php
– application/config/autoload.php
– application/controllers/backend/Cities.php
– application/controllers/backend/Countries.php
– application/controllers/backend/Zones.php
– application/core/BE_Controller.php
– application/language/english/ps_lang.php
– application/libraries/PS_Delete.php
– application/models/City.php
– application/models/Country.php
– application/models/Zone.php
– application/models/Zone_junction.php
– application/views/backend/categories/entry_form.php
– application/views/backend/cities/entry_form.php
– application/views/backend/cities/entry_form_script.php
– application/views/backend/cities/list.php
– application/views/backend/cities/list_script.php
– application/views/backend/cities/search_form.php
– application/views/backend/countries/entry_form.php
– application/views/backend/countries/entry_form_script.php
– application/views/backend/countries/list.php
– application/views/backend/countries/list_script.php
– application/views/backend/countries/search_form.php
– application/views/backend/coupons/entry_form.php
– application/views/backend/zones/entry_form.php
– application/views/backend/zones/entry_form_script.php
– application/views/backend/zones/list.php
– application/views/backend/zones/list_script.php
– application/views/backend/zones/search_form.php
– application/controllers/backend/Shipping_zones.php
– application/models/Shipping_zone.php
– application/views/backend/shipping_zones/entry_form.php
– application/views/backend/shipping_zones/entry_form_script.php
– application/views/backend/shipping_zones/list.php
– application/views/backend/shipping_zones/list_script.php
– application/views/backend/shipping_zones/search_form.php
– application/views/backend/products/entry_form_script.php

SQL

Copy to Clipboard

ALTER TABLE core_users ADD code VARCHAR(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL AFTER device_token, ADD verify_types TINYINT(1) NOT NULL DEFAULT ‘0’ AFTER code;

ALTER TABLE core_about ADD terms TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL AFTER about_description;

CREATE TABLE `mk_countries` (
`id` varchar(255) NOT NULL,
`name` varchar(255) NOT NULL,
`status` tinyint(1) NOT NULL DEFAULT ‘1’,
`added_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`updated_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`added_user_id` varchar(255) NOT NULL,
`updated_user_id` varchar(255) NOT NULL,
`updated_flag` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

CREATE TABLE `mk_cities` (
`id` varchar(255) NOT NULL,
`country_id` varchar(255) NOT NULL,
`name` varchar(255) NOT NULL,
`status` tinyint(1) NOT NULL DEFAULT ‘1’,
`added_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`updated_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`added_user_id` varchar(255) NOT NULL,
`updated_user_id` varchar(255) NOT NULL,
`updated_flag` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

CREATE TABLE `mk_zones` (
`id` varchar(255) NOT NULL,
`name` varchar(255) NOT NULL,
`shop_id` varchar(255) NOT NULL,
`status` tinyint(1) NOT NULL DEFAULT ‘1’,
`added_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`updated_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`added_user_id` varchar(255) NOT NULL,
`updated_user_id` varchar(255) NOT NULL,
`updated_flag` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

CREATE TABLE `mk_zones_junction` (
`id` varchar(255) NOT NULL,
`zone_id` varchar(255) NOT NULL,
`country_id` varchar(255) NOT NULL,
`city_id` varchar(255) NOT NULL,
`added_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`updated_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`added_user_id` varchar(255) NOT NULL,
`updated_user_id` varchar(255) NOT NULL,
`updated_flag` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

CREATE TABLE `mk_shipping_zones` (
`id` varchar(255) NOT NULL,
`name` varchar(255) NOT NULL,
`zone_id` varchar(255) NOT NULL,
`shop_id` varchar(255) NOT NULL,
`per_order_based_enabled` tinyint(1) NOT NULL,
`per_item_based_enabled` tinyint(1) NOT NULL,
`free_enabled` tinyint(1) NOT NULL,
`per_order_based_cost` double NOT NULL,
`per_item_based_cost` double NOT NULL,
`per_item_based_from_product_cost_enable` tinyint(1) NOT NULL,
`added_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`updated_date` timestamp NOT NULL DEFAULT ‘0000-00-00 00:00:00’,
`added_user_id` varchar(255) NOT NULL,
`updated_user_id` varchar(255) NOT NULL,
`updated_flag` int(11) NOT NULL,
`status` tinyint(1) NOT NULL,
`delivery_increment_of_zone` float NOT NULL DEFAULT ‘1’
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

ALTER TABLE core_users ADD country_id VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL AFTER verify_types, ADD city_id VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL AFTER country_id;

ALTER TABLE mk_products ADD product_unit VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL AFTER sub_cat_id;

ALTER TABLE mk_shops ADD standard_shipping_enable TINYINT(1) NOT NULL AFTER messenger, ADD zone_shipping_enable TINYINT(1) NOT NULL AFTER standard_shipping_enable, ADD no_shipping_enable TINYINT(1) NOT NULL AFTER zone_shipping_enable;

ALTER TABLE mk_shipping_zones ADD delivery_increment_of_zone FLOAT NOT NULL AFTER status;
 
ALTER TABLE mk_shipping_zones ADD name VARCHAR(255) NOT NULL AFTER id;

ALTER TABLE mk_shipping_zones CHANGE added_date added_date TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP;

ALTER TABLE mk_products ADD shipping_cost DOUBLE NOT NULL AFTER unit_price;

ALTER TABLE mk_products ADD minimum_order INT(11) NOT NULL AFTER shipping_cost;

INSERT INTO `core_modules` (`module_id`, `module_name`, `module_desc`, `module_icon`, `ordering`, `is_show_on_menu`, `group_id`) VALUES (’37’, ‘shipping_zones’, ‘Shipping With Zones’, ”, ’10’, ‘1’, ‘1’);

INSERT INTO `core_modules` (`module_id`, `module_name`, `module_desc`, `module_icon`, `ordering`, `is_show_on_menu`, `group_id`) VALUES (’36’, ‘zones’, ‘Zones’, ”, ’10’, ‘1’, ‘1’);

INSERT INTO `core_modules` (`module_id`, `module_name`, `module_desc`, `module_icon`, `ordering`, `is_show_on_menu`, `group_id`) VALUES (’35’, ‘cities’, ‘Cities’, ”, ’10’, ‘1’, ‘1’);

INSERT INTO `core_modules` (`module_id`, `module_name`, `module_desc`, `module_icon`, `ordering`, `is_show_on_menu`, `group_id`) VALUES (’34’, ‘countries’, ‘Countries’, ”, ’10’, ‘1’, ‘1’);