PS Buy and Sell (v3.1) Version Release

Backend Change Logs

– Export database error fixed ( Backend )

– location_id filter at featured item search fixed ( Backend )

– Not allowed to send message to deleted item and deactivated user ( Api )

– Show password and confirm password as readonly at profile for demo mode ( Backend )

– User profile image upload fixed ( Api )

– Add facebook login redirect URL ( Backend )

– search with pagination issue ( Api )

– Accepted Offer Noti issue fixed ( Api )

– Promote Item with date and time ( Backend & Api )

– Sub Location ( Backend & Api )

– Sorting by name ascending and descending at Categories and Sub Categories ( Backend & Api )

– Auto Select Default Currency ( Backend & Api )

– Default Image and image ordering at Item Image Upload ( Api )

– Delete Item Image ( Api )

– Admin can modify offline and show status as selected at edit form ( Backend )

– user can buy same item multiple times modified ( Api )

– sponsored items filter by all conditions updated ( Backend )

Backend Effected Files

– application/config/autoload.php
– application/controllers/backend/App_settings.php
– application/controllers/backend/Categories.php
– application/controllers/backend/Item_currency.php
– application/controllers/backend/Item_location_townships.php
– application/controllers/backend/Items.php
– application/controllers/backend/Notis.php
– application/controllers/backend/Offline_paids.php
– application/controllers/backend/Paid_items.php
– application/controllers/backend/Popularitems.php
– application/controllers/backend/Subcategories.php
– application/controllers/frontend/Home.php
– application/controllers/rest/Chats.php
– application/controllers/rest/Images.php
– application/controllers/rest/Item_location_townships.php
– application/controllers/rest/Items.php
– application/controllers/rest/Paid_items.php
– application/core/API_Controller.php
– application/core/My_Model.php
– application/libraries/PS_Adapter.php
– application/libraries/PS_Delete.php
– application/models/Category.php
– application/models/Currency.php
– application/models/Disable.php
– application/models/Item.php
– application/models/Item_location_township.php
– application/models/Pending.php
– application/models/Reject.php
– application/models/Subcategory.php
– application/views/backend/app_settings/entry_form.php
– application/views/backend/categories/search_form.php
– application/views/backend/components/currency_warning_modal.php
– application/views/backend/disables/entry_form.php
– application/views/backend/item_currency/entry_form.php
– application/views/backend/item_currency/list.php
– application/views/backend/item_currency/list_script.php
– application/views/backend/item_location_townships/entry_form.php
– application/views/backend/item_location_townships/entry_form_script.php
– application/views/backend/item_location_townships/list.php
– application/views/backend/item_location_townships/list_script.php
– application/views/backend/item_location_townships/search_form.php
– application/views/backend/item_reports/entry_form.php
– application/views/backend/items/entry_form.php
– application/views/backend/items/entry_form_script.php
– application/views/backend/items/search_form.php
– application/views/backend/offline_paids/entry_form.php
– application/views/backend/offline_paids/search_form.php
– application/views/backend/paid_items/entry_form.php
– application/views/backend/paid_items/entry_form_script.php
– application/views/backend/paid_items/search_form.php
– application/views/backend/partials/footer.php
– application/views/backend/pendings/entry_form.php
– application/views/backend/popularitems/entry_form.php
– application/views/backend/profile/entry_form.php
– application/views/backend/rejects/entry_form.php
– application/views/backend/subcategories/search_form.php
– application/views/frontend/fb_login_success.php
– application/core/BE_Controller.php
– system/database/*.*

Important Note :

1) You need to run the query one by one. Don’t run all query as one time.

2) Please make sure that you need to run all necessary query before 2.5. Because some of query are depend on previous older version SQL.

You can reference how to run SQL queries to update new version :

https://www.dropbox.com/s/63ukld2x0y1fxcj/sql_log_version_update.m4v?dl=0

SQL

Copy to Clipboard

RENAME TABLE bs_items_location TO bs_item_locations;

ALTER TABLE `bs_items` ADD `item_location_township_id` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL AFTER `item_location_id`;

CREATE TABLE `flutter_buysell_admin`.`bs_item_location_townships` ( `id` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL , `city_id` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL , `township_name` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL , `ordering` INT(10) NOT NULL , `lat` FLOAT(10,6) NOT NULL , `lng` FLOAT(10,6) NOT NULL , `status` TINYINT(1) NOT NULL , `added_date` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ) ENGINE = InnoDB;

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

ALTER TABLE `bs_items_currency` ADD `is_default` TINYINT(1) NOT NULL AFTER `status`;

ALTER TABLE `core_images` ADD `ordering` INT(11) NOT NULL AFTER `updated_user_id`;

INSERT INTO `core_modules` (`module_id`, `module_name`, `module_desc`, `module_lang_key`, `module_icon`, `ordering`, `is_show_on_menu`, `group_id`) VALUES ('31', 'item_location_townships', 'Location Townships', 'location_townships', '', '15', '1', '1');

DELETE FROM `bs_order_by` WHERE `bs_order_by`.`id` = 'added_date_asc';
DELETE FROM `bs_order_by` WHERE `bs_order_by`.`id` = 'added_date_desc';
DELETE FROM `bs_order_by` WHERE `bs_order_by`.`id` = 'point_asc';
DELETE FROM `bs_order_by` WHERE `bs_order_by`.`id` = 'point_desc';

UPDATE `bs_order_by` SET `name` = 'Name Ascending' WHERE `bs_order_by`.`id` = 'name_asc';
UPDATE `bs_order_by` SET `name` = 'Name Descending' WHERE `bs_order_by`.`id` = 'name_desc';

ALTER TABLE `bs_chat_history` ADD `offer_status` TINYINT(1) NOT NULL AFTER `is_accept`;

ALTER TABLE `bs_app_settings` ADD `is_sub_location` TINYINT(1) NOT NULL AFTER `is_approval_enabled`;

Language CSV Need to import

– There are some changes at langauge csv file so you need to import all those cvs file at backend. Please take a look this video
https://www.dropbox.com/s/em6wzh93swznjae/language_import.mov?dl=0

Android Change Logs

– Added time in promote date selection
– Added sub location with on/off setting
– Added sorting category & sub category
– Added default currency
– Updated mulitple sales to same users
– Added default image
– Added delete image
– Updated deeplinking
– Updated stripe version

Android Effected Files

– app/build.gradle
– app/src/main/AndroidManifest.xml
– app/src/main/java/com/panaceasoft/psbuyandsell/Config.java
– app/src/main/java/com/panaceasoft/psbuyandsell/MainActivity.java
– app/src/main/java/com/panaceasoft/psbuyandsell/api/PSApiService.java
– app/src/main/java/com/panaceasoft/psbuyandsell/db/ImageDao.java
– app/src/main/java/com/panaceasoft/psbuyandsell/db/ItemCategoryDao.java
– app/src/main/java/com/panaceasoft/psbuyandsell/db/ItemMapDao.java
– app/src/main/java/com/panaceasoft/psbuyandsell/db/ItemSubCategoryDao.java
– app/src/main/java/com/panaceasoft/psbuyandsell/db/ItemTownshipLocationDao.java
– app/src/main/java/com/panaceasoft/psbuyandsell/db/PSCoreDb.java
– app/src/main/java/com/panaceasoft/psbuyandsell/di/AppModule.java
– app/src/main/java/com/panaceasoft/psbuyandsell/di/MainActivityModule.java
– app/src/main/java/com/panaceasoft/psbuyandsell/di/ViewModelModule.java
– app/src/main/java/com/panaceasoft/psbuyandsell/repository/chat/ChatRepository.java
– app/src/main/java/com/panaceasoft/psbuyandsell/repository/city/CityRepository.java
– app/src/main/java/com/panaceasoft/psbuyandsell/repository/common/NotificationTask.java
– app/src/main/java/com/panaceasoft/psbuyandsell/repository/image/ImageRepository.java
– app/src/main/java/com/panaceasoft/psbuyandsell/repository/item/ItemRepository.java
– app/src/main/java/com/panaceasoft/psbuyandsell/repository/itemcategory/ItemCategoryRepository.java
– app/src/main/java/com/panaceasoft/psbuyandsell/repository/itemsubcategory/ItemSubCategoryRepository.java
– app/src/main/java/com/panaceasoft/psbuyandsell/repository/itemtownshiplocation/ItemTownshipLocationRepository.java
– app/src/main/java/com/panaceasoft/psbuyandsell/ui/apploading/AppLoadingFragment.java
– app/src/main/java/com/panaceasoft/psbuyandsell/ui/category/categoryfilter/CategoryFilterFragment.java
– app/src/main/java/com/panaceasoft/psbuyandsell/ui/category/categorysorting/CategorySortingListActivity.java
– app/src/main/java/com/panaceasoft/psbuyandsell/ui/category/categorysorting/CategorySortingListFragment.java
– app/src/main/java/com/panaceasoft/psbuyandsell/ui/category/list/CategoryListFragment.java
– app/src/main/java/com/panaceasoft/psbuyandsell/ui/chat/adapter/ChatListAdapter.java
– app/src/main/java/com/panaceasoft/psbuyandsell/ui/city/selectedcity/SelectedCityFragment.java
– app/src/main/java/com/panaceasoft/psbuyandsell/ui/common/NavigationController.java
– app/src/main/java/com/panaceasoft/psbuyandsell/ui/common/PSAppCompactActivity.java
– app/src/main/java/com/panaceasoft/psbuyandsell/ui/common/PSFragment.java
– app/src/main/java/com/panaceasoft/psbuyandsell/ui/dashboard/DashBoardSearchCategoryFragment.java
– app/src/main/java/com/panaceasoft/psbuyandsell/ui/dashboard/DashBoardSearchSubCategoryFragment.java
– app/src/main/java/com/panaceasoft/psbuyandsell/ui/inapppurchase/InAppPurchaseFragment.java
– app/src/main/java/com/panaceasoft/psbuyandsell/ui/item/adapter/ItemHorizontalListAdapter.java
– app/src/main/java/com/panaceasoft/psbuyandsell/ui/item/adapter/ItemVerticalListAdapter.java
– app/src/main/java/com/panaceasoft/psbuyandsell/ui/item/detail/ItemFragment.java
– app/src/main/java/com/panaceasoft/psbuyandsell/ui/item/entry/ItemEntryFragment.java
– app/src/main/java/com/panaceasoft/psbuyandsell/ui/item/itemlocation/ItemEntryLocationFragment.java
– app/src/main/java/com/panaceasoft/psbuyandsell/ui/item/itemlocation/ItemLocationAdapter.java
– app/src/main/java/com/panaceasoft/psbuyandsell/ui/item/itemlocation/ItemLocationFragment.java
– app/src/main/java/com/panaceasoft/psbuyandsell/ui/item/itemtownshiplocation/ItemTownshipLocationFragment.java
– app/src/main/java/com/panaceasoft/psbuyandsell/ui/item/itemtownshiplocation/TownshipLocationActivity.java
– app/src/main/java/com/panaceasoft/psbuyandsell/ui/item/itemtownshiplocation/adapter/ItemTownshipLocationAdapter.java
– app/src/main/java/com/panaceasoft/psbuyandsell/ui/item/itemtownshiplocation/townshipLocationFilter/ItemTownshipLocationFilterActivity.java
– app/src/main/java/com/panaceasoft/psbuyandsell/ui/item/itemtownshiplocation/townshipLocationFilter/ItemTownshipLocationFilterFragment.java
– app/src/main/java/com/panaceasoft/psbuyandsell/ui/item/itemtype/SearchViewActivity.java
– app/src/main/java/com/panaceasoft/psbuyandsell/ui/item/promote/ItemPromoteFragment.java
– app/src/main/java/com/panaceasoft/psbuyandsell/ui/item/promote/adapter/ItemPromoteHorizontalListAdapter.java
– app/src/main/java/com/panaceasoft/psbuyandsell/ui/item/search/searchlist/SearchListFragment.java
– app/src/main/java/com/panaceasoft/psbuyandsell/ui/stripe/StripeFragment.java
– app/src/main/java/com/panaceasoft/psbuyandsell/ui/subcategory/SubCategoryFragment.java
– app/src/main/java/com/panaceasoft/psbuyandsell/ui/user/ProfileFragment.java
– app/src/main/java/com/panaceasoft/psbuyandsell/ui/user/userlist/detail/UserDetailFragment.java
– app/src/main/java/com/panaceasoft/psbuyandsell/ui/user/verifyphone/VerifyMobileFragment.java
– app/src/main/java/com/panaceasoft/psbuyandsell/utils/Constants.java
– app/src/main/java/com/panaceasoft/psbuyandsell/utils/FirebaseMessagingService.java
– app/src/main/java/com/panaceasoft/psbuyandsell/utils/PSDialogMsg.java
– app/src/main/java/com/panaceasoft/psbuyandsell/viewmodel/apploading/PSAPPLoadingViewModel.java
– app/src/main/java/com/panaceasoft/psbuyandsell/viewmodel/homelist/HomeTrendingCategoryListViewModel.java
– app/src/main/java/com/panaceasoft/psbuyandsell/viewmodel/image/ImageViewModel.java
– app/src/main/java/com/panaceasoft/psbuyandsell/viewmodel/item/DisabledViewModel.java
– app/src/main/java/com/panaceasoft/psbuyandsell/viewmodel/item/ItemViewModel.java
– app/src/main/java/com/panaceasoft/psbuyandsell/viewmodel/item/PendingViewModel.java
– app/src/main/java/com/panaceasoft/psbuyandsell/viewmodel/item/RecentItemViewModel.java
– app/src/main/java/com/panaceasoft/psbuyandsell/viewmodel/item/RejectedViewModel.java
– app/src/main/java/com/panaceasoft/psbuyandsell/viewmodel/itemcategory/ItemCategoryViewModel.java
– app/src/main/java/com/panaceasoft/psbuyandsell/viewmodel/itemlocation/ItemLocationViewModel.java
– app/src/main/java/com/panaceasoft/psbuyandsell/viewmodel/itemsubcategory/ItemSubCategoryViewModel.java
– app/src/main/java/com/panaceasoft/psbuyandsell/viewmodel/itemtownshiplocation/ItemTownshipLocationViewModel.java
– app/src/main/java/com/panaceasoft/psbuyandsell/viewobject/Image.java
– app/src/main/java/com/panaceasoft/psbuyandsell/viewobject/Item.java
– app/src/main/java/com/panaceasoft/psbuyandsell/viewobject/ItemMap.java
– app/src/main/java/com/panaceasoft/psbuyandsell/viewobject/ItemTownshipLocation.java
– app/src/main/java/com/panaceasoft/psbuyandsell/viewobject/PSAppInfo.java
– app/src/main/java/com/panaceasoft/psbuyandsell/viewobject/holder/CategoryParameterHolder.java
– app/src/main/java/com/panaceasoft/psbuyandsell/viewobject/holder/ItemParameterHolder.java
– app/src/main/java/com/panaceasoft/psbuyandsell/viewobject/holder/SubCategoryParameterHolder.java
– app/src/main/res/layout/activity_township_location.xml
– app/src/main/res/layout/dialog_subcategory_filter.xml
– app/src/main/res/layout/fragment_item.xml
– app/src/main/res/layout/fragment_item_entry.xml
– app/src/main/res/layout/fragment_item_township_location.xml
– app/src/main/res/layout/fragment_item_township_location_filter.xml
– app/src/main/res/layout/fragment_language.xml
– app/src/main/res/layout/item_item_horizontal_with_user.xml
– app/src/main/res/layout/item_item_township_location.xml
– app/src/main/res/layout/item_item_vertical_with_user.xml
– app/src/main/res/values-ar/strings.xml
– app/src/main/res/values-de/strings.xml
– app/src/main/res/values-es/strings.xml
– app/src/main/res/values-fr/strings.xml
– app/src/main/res/values-hi-rIN/strings.xml
– app/src/main/res/values-in/strings.xml
– app/src/main/res/values-it/strings.xml
– app/src/main/res/values-ja/strings.xml
– app/src/main/res/values-ko/strings.xml
– app/src/main/res/values-ms/strings.xml
– app/src/main/res/values-pt/strings.xml
– app/src/main/res/values-ru/strings.xml
– app/src/main/res/values-th/strings.xml
– app/src/main/res/values-tr/strings.xml
– app/src/main/res/values-zh/strings.xml
– app/src/main/res/values/strings.xml
– build.gradle