Buy and Sell Frontend (v1.3) Version Release

Backend Change Logs

– transactions csv export (Backend)

– buy ad post transactions csv export (Backend)

– status code update in api response (Api)

– read all messages and text from language instead of hard code modification (Backend)

– image limit config (Backend & Api)

– reorder images (Api)

– bumps up ads (Api)

– fix buy package by offline payment method (Backend)

Backend Effected Files

– application/config/autoload.php

– application/core/API_Controller.php

– application/core/BE_Controller.php

– application/core/My_Model.php

– application/libraries/PS_Image.php

– application/libraries/PS_Adapter.php

– application/libraries/UploadHandler.php

– application/models/Ad_post_type.php

– application/models/Package_bought.php

– application/controllers/rest/Blockusers.php

– application/controllers/rest/Chat_items.php

– application/controllers/rest/Chats.php

– application/controllers/rest/Example.php

– application/controllers/rest/Favourites.php

– application/controllers/rest/Itemreports.php

– application/controllers/rest/Notis.php

– application/controllers/rest/Packages.php

– application/controllers/rest/Paid_items.php

– application/controllers/rest/Subcat_subscribes.php

– application/controllers/rest/Chat_items.php

– application/controllers/rest/Chats.php

– application/controllers/rest/Images.php

– application/controllers/rest/Items.php

– application/controllers/rest/Userfollows.php

– application/controllers/rest/Users.php

– application/controllers/backend/Buy_ad_post_transactions.php

– application/controllers/backend/Offline_ad_package_bought_request.php

– application/controllers/backend/Transactions.php

– application/controllers/backend/Abouts.php

– application/controllers/backend/Apis.php

– application/controllers/backend/App_settings.php

– application/controllers/backend/Apps.php

– application/controllers/backend/Disables.php

– application/controllers/backend/Notis.php

– application/controllers/backend/Pendings.php

– application/controllers/backend/Rejects.php

– application/controllers/backend/Versions.php

– application/controllers/backend/Frontend_configs.php

– application/controllers/backend/Mobile_configs.php

– application/views/backend/abouts/entry_form.php

– application/views/backend/abouts/entry_form_script.php

– application/views/backend/api_keys/entry_form.php

– application/views/backend/api_keys/entry_form_script.php

– application/views/backend/app_settings/entry_form.php

– application/views/backend/app_settings/entry_form_script.php

– application/views/backend/app_users/entry_form.php

– application/views/backend/backend_configs/entry_form.php

– application/views/backend/blogs/entry_form.php

– application/views/backend/blogs/list.php

– application/views/backend/bluemarkusers/entry_form.php

– application/views/backend/categories/entry_form_script.php

– application/views/backend/colors/entry_form.php

– application/views/backend/components/delete_cover_photo_modal.php

– application/views/backend/components/delete_demo_data_modal.php

– application/views/backend/components/delete_icon_modal.php

– application/views/backend/components/delete_video_modal.php

– application/views/backend/components/favicon_upload_modal.php

– application/views/backend/components/gallery.php

– application/views/backend/components/icon_upload_modal.php

– application/views/backend/components/offline_delete_confirm_modal.php

– application/views/backend/components/photo_upload_modal.php

– application/views/backend/components/profile_upload_modal.php

– application/views/backend/components/sidebar_logo_upload.php

– application/views/backend/components/summary_card.php

– application/views/backend/components/summary_news_panel.php

– application/views/backend/components/summary_panel.php

– application/views/backend/components/video_upload_modal.php

– application/views/backend/disables/entry_form.php

– application/views/backend/in_app_purchases/list.php

– application/views/backend/item_conditions/entry_form.php

– application/views/backend/item_location_townships/entry_form.php

– application/views/backend/item_locations/entry_form.php

– application/views/backend/item_price/entry_form.php

– application/views/backend/item_reports/entry_form.php

– application/views/backend/item_type/entry_form.php

– application/views/backend/items/entry_form.php

– application/views/backend/language_strings/entry_form.php

– application/views/backend/languages/entry_form.php

– application/views/backend/notis/entry_form.php

– application/views/backend/offline_paids/entry_form.php

– application/views/backend/offline_paids/entry_form_script.php

– application/views/backend/offline_payments/entry_form_script.php

– application/views/backend/offline_payments/list.php

– application/views/backend/packages/list.php

– application/views/backend/paid_items/entry_form.php

– application/views/backend/paid_items/entry_form_script.php

– application/views/backend/partials/header.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/ratings/entry_form.php

– application/views/backend/rejects/entry_form.php

– application/views/backend/request_categories/entry_form.php

– application/views/backend/request_categories/entry_form_script.php

– application/views/backend/request_categories/search_form.php

– application/views/backend/reset_email.php

– application/views/backend/subcategories/entry_form.php

– application/views/backend/subcategories/entry_form_script.php

– application/views/backend/system_users/entry_form.php

– application/views/backend/transactions/entry_form.php

– application/views/backend/pendings/list.php

– application/views/backend/registered_users/list.php

– application/views/backend/registered_users/list_script.php

– application/views/backend/thumbnail_generators/entry_form.php

– application/views/backend/buy_ad_post_transactions/search_form.php

– application/views/backend/transactions/search_form.php

– application/views/backend/offline_ad_package_bought_request/entry_form.php

– application/views/backend/offline_ad_package_bought_request/entry_form_script.php

– application/views/backend/offline_ad_package_bought_request/list.php

– application/views/backend/offline_ad_package_bought_request/list_script.php

– application/views/backend/offline_ad_package_bought_request/search_form.php

– application/views/backend/frontend_configs/entry_form.php

– application/views/backend/frontend_configs/entry_form_script.php

– application/views/backend/mobile_configs/entry_form.php

– application/views/backend/mobile_configs/entry_form_script.php

SQL Change Logs

You must run the following queries.

Copy to Clipboard

CREATE TABLE `bs_frontend_config` (  `id` varchar(255) NOT NULL,  `map_key` varchar(255) NOT NULL,  `is_enable_video_setting` tinyint(1) NOT NULL,  `show_user_profile` tinyint(1) NOT NULL,  `no_filter_with_location_on_map` tinyint(1) NOT NULL,  `price_format` varchar(255) NOT NULL,  `enable_notification` tinyint(1) NOT NULL,  `fcm_server_key` varchar(255) NOT NULL,  `firebase_web_push_key_pair` varchar(255) NOT NULL,  `ad_client` varchar(255) NOT NULL,  `ad_slot` varchar(255) NOT NULL,  `copy_right` varchar(255) NOT NULL,  `google_play_url` varchar(255) NOT NULL,  `app_store_url` varchar(255) NOT NULL,  `google_setting` tinyint(1) NOT NULL,  `app_store_setting` tinyint(1) NOT NULL,  `banner_src` varchar(255) NOT NULL,  `google_map` tinyint(1) NOT NULL,  `open_street_map` tinyint(1) NOT NULL,  `mile` varchar(255) NOT NULL,  `default_language` varchar(255) NOT NULL,  `exclude_language` varchar(255) NOT NULL,  `promote_first_choice_day` varchar(255) NOT NULL,  `promote_second_choice_day` varchar(255) NOT NULL,  `promote_third_choice_day` varchar(255) NOT NULL,  `promote_fourth_choice_day` varchar(255) NOT NULL) ENGINE=InnoDB;

CREATE TABLE `bs_mobile_config` (  `id` varchar(255) NOT NULL,  `apple_appstore_url` varchar(255) NOT NULL,  `google_playstore_url` varchar(255) NOT NULL,  `is_show_admob` tinyint(1) NOT NULL,  `fb_key` varchar(255) NOT NULL,  `ios_appstore_id` varchar(255) NOT NULL,  `date_format` varchar(255) NOT NULL,  `price_format` varchar(255) NOT NULL,  `default_razor_currency` varchar(255) NOT NULL,  `is_razor_support_multi_currency` tinyint(1) NOT NULL,  `is_show_subcategory` tinyint(1) NOT NULL,  `show_phone_login` tinyint(1) NOT NULL,  `show_google_login` tinyint(1) NOT NULL,  `show_facebook_login` tinyint(1) NOT NULL,  `is_show_token_id` tinyint(1) NOT NULL,  `is_use_thumbnail_as_placeholder` tinyint(1) NOT NULL,  `is_use_googlemap` tinyint(1) NOT NULL,  `item_detail_view_count_for_ads` int(11) NOT NULL,  `is_show_ads_in_item_detail` tinyint(1) NOT NULL,  `after_item_count_admob_once` int(11) NOT NULL,  `is_show_admob_inside_list` tinyint(1) NOT NULL,  `blue_mark_size` int(11) NOT NULL,  `block_item_loading_limit` int(11) NOT NULL,  `follower_item_loading_limit` int(11) NOT NULL,  `block_slider_loading_limit` int(11) NOT NULL,  `feature_item_loading_limit` int(11) NOT NULL,  `discount_item_loading_limit` int(11) NOT NULL,  `popular_item_loading_limit` int(11) NOT NULL,  `recent_item_loading_limit` int(11) NOT NULL,  `category_loading_limit` int(11) NOT NULL,  `default_loading_limit` int(11) NOT NULL,  `mile` varchar(255) NOT NULL,  `video_duration` int(11) NOT NULL,  `is_show_owner_info` tinyint(1) NOT NULL,  `no_filter_with_location_on_map` tinyint(1) NOT NULL,  `chat_image_size` int(11) NOT NULL,  `profile_image_size` int(11) NOT NULL,  `upload_image_size` int(11) NOT NULL,  `promote_fourth_choice_day` varchar(255) NOT NULL,  `promote_third_choice_day` varchar(255) NOT NULL,  `promote_second_choice_day` varchar(255) NOT NULL,  `promote_first_choice_day` varchar(255) NOT NULL,  `default_language` varchar(255) NOT NULL,  `exclude_language` varchar(255) NOT NULL) ENGINE=InnoDB;

CREATE TABLE `bs_ad_post_type` ( `id` INT NOT NULL ,  `key` VARCHAR(255) NOT NULL ,  `value` VARCHAR(255) NOT NULL ) ENGINE = InnoDB;

ALTER TABLE `bs_app_settings` ADD `max_img_upload_of_item` TINYINT NOT NULL DEFAULT '1' AFTER `is_block_user`;

ALTER TABLE `bs_app_settings` ADD `ad_type` TINYINT(1) NOT NULL DEFAULT '2' AFTER `max_img_upload_of_item`;

ALTER TABLE `bs_app_settings` ADD `promo_cell_interval_no` INT NOT NULL AFTER `ad_type`;

ALTER TABLE `bs_package_bought_transactions` ADD `status` TINYINT(1) NOT NULL DEFAULT '0' AFTER `isPaystack`;

ALTER TABLE `core_about` ADD `faq_pages` TEXT NOT NULL AFTER `safety_tips`;

ALTER TABLE `core_about` ADD `terms_and_conditions` TEXT NOT NULL AFTER `faq_pages`;

INSERT INTO `bs_ad_post_type` (`id`, `key`, `value`) VALUES ('1', 'paid_item_first', 'Show Sponsored Ad at the top of Item List'), ('2', 'bumps_ups_between', 'Bumps ups the Sponsored Ad Between Normal Ads'), ('3', 'google_ads_between', 'Google Ad Between Normal Ads'), ('4', 'bumps_and_google_ads_between', 'Sponsored Ad and Google Ad Between Normal Ads Alternatively'), ('5', 'normal_ads_only', 'Normal Ads Only');

INSERT INTO `core_modules` (`module_id`, `module_name`, `module_desc`, `module_lang_key`, `module_icon`, `ordering`, `is_show_on_menu`, `group_id`) VALUES ('61', 'offline_ad_package_bought_request', 'Offline Ad Package Bought Request', 'offline_ad_package_bought_request', '', '4', '1', '2');


INSERT INTO `core_modules` (`module_id`, `module_name`, `module_desc`, `module_lang_key`, `module_icon`, `ordering`, `is_show_on_menu`, `group_id`) VALUES ('59', 'mobile_configs', 'Mobile Config', 'mobile_configs', '', '20', '1', '6');

INSERT INTO `core_modules` (`module_id`, `module_name`, `module_desc`, `module_lang_key`, `module_icon`, `ordering`, `is_show_on_menu`, `group_id`) VALUES ('60', 'frontend_configs', 'Frontend Config', 'frontend_configs', '', '20', '1', '6');

INSERT INTO bs_frontend_config(id) VALUES ('fe1');

INSERT INTO bs_mobile_config(id) VALUES ('mb1');

​x
 
CREATE TABLE `bs_frontend_config` (  `id` varchar(255) NOT NULL,  `map_key` varchar(255) NOT NULL,  `is_enable_video_setting` tinyint(1) NOT NULL,  `show_user_profile` tinyint(1) NOT NULL,  `no_filter_with_location_on_map` tinyint(1) NOT NULL,  `price_format` varchar(255) NOT NULL,  `enable_notification` tinyint(1) NOT NULL,  `fcm_server_key` varchar(255) NOT NULL,  `firebase_web_push_key_pair` varchar(255) NOT NULL,  `ad_client` varchar(255) NOT NULL,  `ad_slot` varchar(255) NOT NULL,  `copy_right` varchar(255) NOT NULL,  `google_play_url` varchar(255) NOT NULL,  `app_store_url` varchar(255) NOT NULL,  `google_setting` tinyint(1) NOT NULL,  `app_store_setting` tinyint(1) NOT NULL,  `banner_src` varchar(255) NOT NULL,  `google_map` tinyint(1) NOT NULL,  `open_street_map` tinyint(1) NOT NULL,  `mile` varchar(255) NOT NULL,  `default_language` varchar(255) NOT NULL,  `exclude_language` varchar(255) NOT NULL,  `promote_first_choice_day` varchar(255) NOT NULL,  `promote_second_choice_day` varchar(255) NOT NULL,  `promote_third_choice_day` varchar(255) NOT NULL,  `promote_fourth_choice_day` varchar(255) NOT NULL) ENGINE=InnoDB;
​
CREATE TABLE `bs_mobile_config` (  `id` varchar(255) NOT NULL,  `apple_appstore_url` varchar(255) NOT NULL,  `google_playstore_url` varchar(255) NOT NULL,  `is_show_admob` tinyint(1) NOT NULL,  `fb_key` varchar(255) NOT NULL,  `ios_appstore_id` varchar(255) NOT NULL,  `date_format` varchar(255) NOT NULL,  `price_format` varchar(255) NOT NULL,  `default_razor_currency` varchar(255) NOT NULL,  `is_razor_support_multi_currency` tinyint(1) NOT NULL,  `is_show_subcategory` tinyint(1) NOT NULL,  `show_phone_login` tinyint(1) NOT NULL,  `show_google_login` tinyint(1) NOT NULL,  `show_facebook_login` tinyint(1) NOT NULL,  `is_show_token_id` tinyint(1) NOT NULL,  `is_use_thumbnail_as_placeholder` tinyint(1) NOT NULL,  `is_use_googlemap` tinyint(1) NOT NULL,  `item_detail_view_count_for_ads` int(11) NOT NULL,  `is_show_ads_in_item_detail` tinyint(1) NOT NULL,  `after_item_count_admob_once` int(11) NOT NULL,  `is_show_admob_inside_list` tinyint(1) NOT NULL,  `blue_mark_size` int(11) NOT NULL,  `block_item_loading_limit` int(11) NOT NULL,  `follower_item_loading_limit` int(11) NOT NULL,  `block_slider_loading_limit` int(11) NOT NULL,  `feature_item_loading_limit` int(11) NOT NULL,  `discount_item_loading_limit` int(11) NOT NULL,  `popular_item_loading_limit` int(11) NOT NULL,  `recent_item_loading_limit` int(11) NOT NULL,  `category_loading_limit` int(11) NOT NULL,  `default_loading_limit` int(11) NOT NULL,  `mile` varchar(255) NOT NULL,  `video_duration` int(11) NOT NULL,  `is_show_owner_info` tinyint(1) NOT NULL,  `no_filter_with_location_on_map` tinyint(1) NOT NULL,  `chat_image_size` int(11) NOT NULL,  `profile_image_size` int(11) NOT NULL,  `upload_image_size` int(11) NOT NULL,  `promote_fourth_choice_day` varchar(255) NOT NULL,  `promote_third_choice_day` varchar(255) NOT NULL,  `promote_second_choice_day` varchar(255) NOT NULL,  `promote_first_choice_day` varchar(255) NOT NULL,  `default_language` varchar(255) NOT NULL,  `exclude_language` varchar(255) NOT NULL) ENGINE=InnoDB;
​
CREATE TABLE `bs_ad_post_type` ( `id` INT NOT NULL ,  `key` VARCHAR(255) NOT NULL ,  `value` VARCHAR(255) NOT NULL ) ENGINE = InnoDB;
​
ALTER TABLE `bs_app_settings` ADD `max_img_upload_of_item` TINYINT NOT NULL DEFAULT '1' AFTER `is_block_user`;
​
ALTER TABLE `bs_app_settings` ADD `ad_type` TINYINT(1) NOT NULL DEFAULT '2' AFTER `max_img_upload_of_item`;
​
ALTER TABLE `bs_app_settings` ADD `promo_cell_interval_no` INT NOT NULL AFTER `ad_type`;
​
ALTER TABLE `bs_package_bought_transactions` ADD `status` TINYINT(1) NOT NULL DEFAULT '0' AFTER `isPaystack`;
​
ALTER TABLE `core_about` ADD `faq_pages` TEXT NOT NULL AFTER `safety_tips`;
​
ALTER TABLE `core_about` ADD `terms_and_conditions` TEXT NOT NULL AFTER `faq_pages`;
​
INSERT INTO `bs_ad_post_type` (`id`, `key`, `value`) VALUES ('1', 'paid_item_first', 'Show Sponsored Ad at the top of Item List'), ('2', 'bumps_ups_between', 'Bumps ups the Sponsored Ad Between Normal Ads'), ('3', 'google_ads_between', 'Google Ad Between Normal Ads'), ('4', 'bumps_and_google_ads_between', 'Sponsored Ad and Google Ad Between Normal Ads Alternatively'), ('5', 'normal_ads_only', 'Normal Ads Only');
​
INSERT INTO `core_modules` (`module_id`, `module_name`, `module_desc`, `module_lang_key`, `module_icon`, `ordering`, `is_show_on_menu`, `group_id`) VALUES ('61', 'offline_ad_package_bought_request', 'Offline Ad Package Bought Request', 'offline_ad_package_bought_request', '', '4', '1', '2');
​
​
INSERT INTO `core_modules` (`module_id`, `module_name`, `module_desc`, `module_lang_key`, `module_icon`, `ordering`, `is_show_on_menu`, `group_id`) VALUES ('59', 'mobile_configs', 'Mobile Config', 'mobile_configs', '', '20', '1', '6');
​
INSERT INTO `core_modules` (`module_id`, `module_name`, `module_desc`, `module_lang_key`, `module_icon`, `ordering`, `is_show_on_menu`, `group_id`) VALUES ('60', 'frontend_configs', 'Frontend Config', 'frontend_configs', '', '20', '1', '6');
​
INSERT INTO bs_frontend_config(id) VALUES ('fe1');
​
INSERT INTO bs_mobile_config(id) VALUES ('mb1');

How to run SQL queries for version update

Please watch the screen recording here : https://drive.google.com/file/d/1n5sLt1TI73p5vmUgEfAZ_erm4zBNy1AY/view

Important Note – Need to import language csv files.

Language Update at Backend

You may need to update language file at backend. Please take a look at this video : https://www.youtube.com/watch?v=XueP33MM6DQ

Frontend Change Logs

– Add Reorder image in item
– Add Apple Sign In feature
– Add Open street Map feature
– Add FAQ Pages
– Add Terms & Conditions
– Improve Image upload limit setting
– All setting config are come from backend
– Add Bump up ads

Frontend Effected Files

– package-lock.json
– package.json
– public/firebase-messaging-sw.js
– public/index.html
– src/App.vue
– src/api/PsApiService.ts
– src/api/PsUrl.ts
– src/assets/locales/index.ts
– src/assets/locales/locales/ar.json
– src/assets/locales/locales/de.json
– src/assets/locales/locales/en.json
– src/assets/locales/locales/es.json
– src/assets/locales/locales/fr.json
– src/assets/locales/locales/hi.json
– src/assets/locales/locales/id.json
– src/assets/locales/locales/it.json
– src/assets/locales/locales/ja.json
– src/assets/locales/locales/ko.json
– src/assets/locales/locales/ms.json
– src/assets/locales/locales/pt.json
– src/assets/locales/locales/ru.json
– src/assets/locales/locales/th.json
– src/assets/locales/locales/tr.json
– src/assets/locales/locales/zh.json
– src/components/core/adsense/PsAdSense.vue
– src/components/core/checkbox/CustomCheckbox.vue
– src/components/core/notificationbox/PsNotificationBox.vue
– src/components/layouts/footer/FooterLinkSection.vue
– src/components/layouts/map/MapWithCircleFilterModal.vue
– src/components/layouts/map/MapWithPinModal.vue
– src/components/layouts/map/MapWithPinPicker.vue
– src/components/layouts/map/MapWithPinPickerModal.vue
– src/components/layouts/navbar/PsNavBar.vue
– src/components/layouts/navbar/PsNavTabBar.vue
– src/components/modules/chat/ChatBuyerHorizontalItem.vue
– src/components/modules/chat/ChatHorizontalItem.vue
– src/components/modules/gallery/GalleryHorizontalItem.vue
– src/components/modules/gallery/GalleryHorizontalSwiper.vue
– src/components/modules/item/ItemHorizontalItem.vue
– src/components/modules/item/LimitAdHorizontalItem.vue
– src/components/modules/item/LimitItemModal.vue
– src/components/modules/item/PaidAdItemHorizontalItem.vue
– src/components/modules/item/ProfileItemHorizontalItem.vue
– src/components/modules/item/PromoteItemModal.vue
– src/components/modules/user/UserListHorizontal.vue
– src/components/modules/user/UserSearchListHorizontal.vue
– src/components/modules/user/UserSettingModal.vue
– src/config/PsConfig.ts
– src/main.ts
– src/object/AboutUs.ts
– src/object/DefaultPhoto.ts
– src/object/Product.ts
– src/object/PsAppInfo.ts
– src/object/PsAppSetting.ts
– src/object/PsItemUploadConfig.ts
– src/object/constant/ps_constants.ts
– src/object/core/PsValueHolder.ts
– src/object/holder/ProductParameterHolder.ts
– src/router/index.ts
– src/store/modules/category/CategoryProvider.ts
– src/store/modules/gallery/GalleryProvider.ts
– src/store/modules/item/ProductProvider.ts
– src/store/modules/itemLocationTownship/ItemLocationTownshipProvider.ts
– src/store/modules/offer/OfferProvider.ts
– src/store/modules/package/PackageProvider.ts
– src/store/modules/user/UserListProvider.ts
– src/store/modules/user/UserProvider.ts
– src/views/chat/Chat.vue
– src/views/chat/list/ChatList.vue
– src/views/chat/list/OfferList.vue
– src/views/dashboard/Dashboard.vue
– src/views/general/UiCollection.vue
– src/views/item/detail/ItemDetail.vue
– src/views/item/entry/ItemEntry.vue
– src/views/item/list/ItemList.vue
– src/views/search/SearchForLargeScreen.vue
– src/views/subCategory/list/SubCategoryList.vue
– src/views/transaction/BuyAdTransaction.vue
– src/views/user/AccountList.vue
– src/views/user/Login.vue
– src/views/user/OtherProfile.vue
– src/views/user/Profile.vue
– src/views/user/Register.vue
– src/views/user/VerifyEmail.vue
– vue.config.js
– src/components/core/draggable/
– src/components/layouts/map/OpenStreetMap.vue
– src/components/modules/item/ItemImageDraggable.vue
– src/object/FrontendConfigSetting.ts
– src/object/Language.ts
– src/object/holder/AppleLoginParameterHolder.ts
– src/object/holder/ImageParameterHolder.ts
– src/views/about/FaqPage.vue
– src/views/about/TermsAndConditions.vue