Buy and Sell Frontend (v1.2) Version Release

Backend Change Logs

– add product discount (Backend)

– product discount list (Api)

– add search subcategory (Api)

– search user (Api)

– item upload improvement (Backend & Api)

– all report and reorder menu (Backend)

– limit ad post for users (Backend & Api)

– sub category noti subscription (Backend & Api)

– show owner’s name at approval items (Backend)

– user list for most rating users report (Backend)

– user search form for most rating users report (Backend)

– user detail for most rating users report (Backend)

– login with demo account feature for demo mode (Backend)

– email notification when the ad is approved/rejected by the admin (Backend)

– email notification about ad review and rating (Api)

– disable block feature ‌admin control (Backend)

– admin can control item upload field (Backend)

– filter by cat_id at search subcategory api (Api)

– reported item improvement (Backend & Api)

– demo data delete (Bakend)

– buy ad post transactions history (Api)

– buy ad post transactions detail (Api)

– check the condition at chat api (Api)

– item currency can’t unpublish to default currency (Backend)

– add csv import at location city (Backend)

– add csv import at location township (Backend)

– fix language csv import removing duplicate row at table (Backend)

– safety tips ckeditors (Backend)

– sitemap generator (Backend)

– category csv import (Backend)

– subcategory csv import (Backend)

Backend Effected Files

– getsitemap.php

– application/config/autoload.php

– application/core/API_Controller.php

– application/core/My_Model.php

– application/libraries/PS_Adapter.php

– application/libraries/PS_Delete.php

– application/libraries/PS_Image.php

– application/helpers/ps_mail_helper.php

– application/helpers/ps_helper.php

– application/controllers/rest/Items.php

– application/controllers/rest/Itemreports.php

– application/controllers/rest/Chat_items.php

– application/controllers/rest/Chats.php

– application/controllers/rest/Subcategories.php

– application/controllers/rest/Subcat_subscribes.php

– application/controllers/rest/Users.php

– application/controllers/rest/Feeds.php

– application/controllers/rest/Packages.php

– application/controllers/rest/Buy_ad_post_transaction.php

– application/controllers/backend/App_settings.php

– application/controllers/backend/Packages.php

– application/controllers/backend/Categories.php

– application/controllers/backend/Subcategories.php

– application/controllers/backend/Items.php

– application/controllers/backend/Item_currency.php

– application/controllers/backend/Item_reports.php

– application/controllers/backend/Item_locations.php

– application/controllers/backend/Item_location_townships.php

– application/controllers/backend/Ratings.php

– application/controllers/backend/Disables.php

– application/controllers/backend/Pendings.php

– application/controllers/backend/Rejects.php

– application/controllers/backend/Notis.php

– application/controllers/backend/Language_strings.php

– application/controllers/backend/Demo_data_delete.php

– application/controllers/backend/Buy_ad_post_transactions.php

– application/controllers/backend/Sitemap_generators.php

– application/models/Item.php

– application/models/Itemreport.php

– application/models/Reported_item_status.php

– application/models/Subcategory.php

– application/models/Subcat_subscribe.php

– application/models/User.php

– application/models/Package.php

– application/models/Package_bought.php

– application/models/Image.php

– application/models/Module.php

– application/models/Sitemap_generator.php

– application/views/backend/login.php

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

SQL Change Logs

You must run the following queries.

Copy to Clipboard

CREATE TABLE bs_packages ( package_id VARCHAR(255) NOT NULL , title VARCHAR(255) NOT NULL , price FLOAT NOT NULL , currency_id VARCHAR(255) NOT NULL , post_count INT NOT NULL , status TINYINT(1) NOT NULL DEFAULT '1' , added_date TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ) ENGINE = InnoDB;

CREATE TABLE bs_package_bought_transactions ( id VARCHAR(255) NOT NULL , user_id VARCHAR(255) NOT NULL , package_id VARCHAR(255) NOT NULL , payment_type VARCHAR(255) NOT NULL, price VARCHAR(255) NOT NULL, razor_id VARCHAR(255) NOT NULL, isPaystack TINYINT(1) NOT NULL, added_date TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id)) ENGINE = InnoDB;

CREATE TABLE bs_subcat_subscribes ( id VARCHAR(255) NOT NULL , user_id VARCHAR(255) NOT NULL , cat_id VARCHAR(255) NOT NULL , subcat_id VARCHAR(255) NOT NULL ) ENGINE = InnoDB;

CREATE TABLE bs_item_upload_config ( id INT NOT NULL , title TINYINT(1) NOT NULL DEFAULT '1' , price TINYINT(1) NOT NULL DEFAULT '1' , description TINYINT(1) NOT NULL DEFAULT '1' , item_location_id TINYINT(1) NOT NULL DEFAULT '1' , item_location_township_id TINYINT(1) NOT NULL DEFAULT '0' , cat_id TINYINT(1) NOT NULL DEFAULT '1' , sub_cat_id TINYINT(1) NOT NULL DEFAULT '0' , item_type_id TINYINT(1) NOT NULL DEFAULT '0' , item_price_type_id TINYINT(1) NOT NULL DEFAULT '0' , item_currency_id TINYINT(1) NOT NULL DEFAULT '1' , condition_of_item_id TINYINT(1) NOT NULL DEFAULT '0' , discount_rate_by_percentage TINYINT(1) NOT NULL DEFAULT '0' , business_mode TINYINT(1) NOT NULL DEFAULT '0' , image TINYINT(1) NOT NULL DEFAULT '1' , video TINYINT(1) NOT NULL DEFAULT '0' , video_icon TINYINT(1) NOT NULL DEFAULT '0' , address TINYINT(1) NOT NULL DEFAULT '0' , lat TINYINT(1) NOT NULL DEFAULT '0' , lng TINYINT(1) NOT NULL DEFAULT '0' , highlight_info TINYINT(1) NOT NULL DEFAULT '0' , brand TINYINT(1) NOT NULL DEFAULT '0' , deal_option_id TINYINT(1) NOT NULL DEFAULT '0' , deal_option_remark TINYINT(1) NOT NULL DEFAULT '0' , PRIMARY KEY (id)) ENGINE = InnoDB CHARSET=utf8 COLLATE utf8_general_ci;

CREATE TABLE bs_reported_item_status ( id INT NOT NULL , title VARCHAR(50) NOT NULL ) ENGINE = InnoDB;

CREATE TABLE bs_sitemap_logs ( id VARCHAR(255) NOT NULL ,  sitemap_path VARCHAR(255) NOT NULL ,  added_date DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ,    PRIMARY KEY  (`id`)) ENGINE = InnoDB;

ALTER TABLE bs_items ADD discount_rate_by_percentage FLOAT NOT NULL DEFAULT '0' AFTER payment_type;

ALTER TABLE bs_app_settings ADD is_paid_app TINYINT(1) NOT NULL DEFAULT '0' AFTER is_thumb2x_3x_generate;

ALTER TABLE bs_app_settings ADD is_block_user TINYINT(1) NOT NULL DEFAULT '1' AFTER is_paid_app;

ALTER TABLE bs_app_settings ADD is_subcat_subscription TINYINT NOT NULL DEFAULT '0' AFTER is_block_user;

ALTER TABLE core_users ADD remaining_post INT NOT NULL AFTER blue_mark_note;

ALTER TABLE bs_items_report ADD text_note VARCHAR(255) NOT NULL AFTER reported_user_id;

ALTER TABLE bs_items_report ADD reported_status TINYINT(1) NOT NULL DEFAULT '1' AFTER text_note;

ALTER TABLE bs_items_report ADD updated_date TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP AFTER added_date;

INSERT INTO bs_reported_item_status (id, title) VALUES ('1', 'open'), ('2', 'in progress'), ('3', 'close');

INSERT INTO core_modules(module_id, module_name, module_desc, module_lang_key, module_icon, ordering, is_show_on_menu, group_id) VALUES ('53','packages','Packages','package_module','','25','1','1');

INSERT INTO core_modules(module_id, module_name, module_desc, module_lang_key, module_icon, ordering, is_show_on_menu, group_id) VALUES ('54','item_upload_configs','Item Upload Configs','item_upload_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 ('55','demo_data_delete','Demo Data Deletion','demo_data_delete','','5','1','5');

INSERT INTO core_modules(module_id, module_name, module_desc, module_lang_key, module_icon, ordering, is_show_on_menu, group_id) VALUES ('56','buy_ad_post_transactions','Buy Ad Post Transactions','ad_post_transactions_module','','5','1','3');

INSERT INTO core_modules(module_id, module_name, module_desc, module_lang_key, module_icon, ordering, is_show_on_menu, group_id) VALUES ('57','sitemap_generators','Sitemap Generator','sitemap_generators','','5','1','5');

UPDATE core_modules SET ordering='25' WHERE module_name='item_locations';

UPDATE core_modules SET ordering='25' WHERE module_name='item_location_townships';

UPDATE core_modules SET ordering='13' WHERE module_name='deal_options';

UPDATE core_modules SET ordering='14' WHERE module_name='item_conditions';

UPDATE core_modules SET module_desc='Sponsored Items Report' WHERE module_name='paid_items';

UPDATE core_modules SET ordering='5' WHERE module_name='blogs';

UPDATE core_modules SET ordering='9' WHERE module_name='disables';

UPDATE core_modules SET module_desc='Offline Sponsored Items Request', ordering='5', group_id='2' WHERE module_name='offline_paids';

UPDATE core_modules SET ordering='25' WHERE module_name='api_keys';

UPDATE core_modules SET module_desc='App Version', ordering='25' WHERE module_name='versions';

UPDATE core_modules SET ordering='25' WHERE module_name='app_settings';

UPDATE core_modules SET module_desc='App About', ordering='20' WHERE module_name='abouts';

UPDATE core_modules SET ordering='19' WHERE module_name='privacy_policies';

UPDATE core_modules SET ordering='18' WHERE module_name='data_deletion_policies';

UPDATE core_modules SET ordering='15' WHERE module_name='backend_configs';

UPDATE core_modules SET module_desc='Payment Setting', ordering='15' WHERE module_name='paid_configs';

UPDATE core_modules SET module_desc='Offline Payment Setting', ordering='12', group_id='6' WHERE module_name='offline_payments';

UPDATE core_modules SET module_desc='Payment In App Purchased Setting', ordering='11', group_id='6' WHERE module_name='in_app_purchases';

UPDATE core_modules SET module_desc='Menu Name Setting', ordering='10' WHERE module_name='module_groups';

UPDATE core_modules SET module_desc='Sub Menu Name Setting', ordering='9' WHERE module_name='modules';

UPDATE core_modules SET ordering='5' WHERE module_name='image_lists';

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

– Fixed sorting issue
– Improve Sitemap Logic
– Add noti count on button “FROM BUYER” and “FROM SELLER chat screen
– Fixed Unread count in message not showing
– Fixed user status online issue
– Added User bought notification
– Insert Images To Blog
– Added Disable block config
– Item upload improvement
– Added User List and Search user feature
– Added search category
– Added search sub category
– Added product discount
– Added product discount list
– Fixed category filter issue in sub category.
– Added sub category noti subscription
– Added Limit ad post for user
– Added Hide/Show item upload fields according to API
– Added store and footer content at config
– Added Buy ad post transaction History List
– Added Buy ad post transaction Detail
– Fixed category long text issue
– Added search box in sub location and sub category
– Added safety tips with ckeditor
– Fixed missing the important button (Mark As Sold)
– Fixed contacts us add require all field and success dialog
– Added feature item in home page

Frontend Effected Files

– package.json
– public/firebase-messaging-sw.js
– public/index.html
– src/App.vue
– src/api/PsApiService.ts
– src/api/PsUrl.ts
– src/api/common/PsApi.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/icons/Icons/Icons.json
– src/components/core/notificationbox/PsNotificationBox.vue
– src/components/core/radio/PsRadio2.vue
– src/components/layouts/footer/FooterLinkSection.vue
– src/components/layouts/navbar/PsNavBar.vue
– src/components/layouts/navbar/PsNavTabBar.vue
– src/components/modules/blog/BlogHorizontalItem.vue
– src/components/modules/category/CategoryHorizontalItem.vue
– src/components/modules/chat/ChatBuyerHorizontalItem.vue
– src/components/modules/chat/ChatHorizontalItem.vue
– src/components/modules/chat/ChatImageDetail.vue
– src/components/modules/chat/OfferModal.vue
– src/components/modules/credit/OfflinePaymentModal.vue
– src/components/modules/credit/PaypalPaymentModal.vue
– src/components/modules/credit/StripePaymentModal.vue
– src/components/modules/gallery/GalleryDetailHorizontalSwiper.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/noti/NotiHorizontalItem.vue
– src/components/modules/subCategory/SubCategoryHorizontalItem.vue
– src/components/modules/user/BlockUserListHorizontal.vue
– src/components/modules/user/UserBlueMarkModal.vue
– src/components/modules/user/UserListHorizontal.vue
– src/components/modules/user/UserPhoneLoginVerificationModal.vue
– src/components/modules/user/UserSearchListHorizontal.vue
– src/components/modules/user/UserSettingModal.vue
– src/config/PsConfig.ts
– src/css/app.css
– src/css/custom.css
– src/main.ts
– src/object/LimitAdTransaction.ts
– src/object/Package.ts
– src/object/Product.ts
– src/object/PsAppInfo.ts
– src/object/PsAppSetting.ts
– src/object/PsItemUploadConfig.ts
– src/object/SubCategory.ts
– src/object/SubCategoryScribe.ts
– src/object/User.ts
– src/object/constant/ps_constants.ts
– src/object/core/PsValueHolder.ts
– src/object/holder/CategoryListParameterHolder.ts
– src/object/holder/FbLoginParameterHolder.ts
– src/object/holder/GoogleLoginPatameterHolder.ts
– src/object/holder/ItemEntryParameterHolder.ts
– src/object/holder/ItemLimitParameterHolder.ts
– src/object/holder/LocationTownshipParameterHolder.ts
– src/object/holder/PhoneLoginParameterHolder.ts
– src/object/holder/ProductParameterHolder.ts
– src/object/holder/SubCategoryListParameterHolder.ts
– src/object/holder/SubCategoryScribeParameterHolder.ts
– src/object/holder/UserListParameterHolder.ts
– src/object/holder/UserLoginParameterHolder.ts
– src/object/holder/UserRegisterParameterHolder.ts
– src/router/index.ts
– src/store/modules/appinfo/AppInfoProvider.ts
– src/store/modules/blog/BlogProvider.ts
– src/store/modules/category/CategoryProvider.ts
– src/store/modules/chat/ChatHistoryListProvider.ts
– src/store/modules/chat/UserUnReadMessageProvider.ts
– src/store/modules/dealOption/DealOptionProvider.ts
– src/store/modules/gallery/GalleryProvider.ts
– src/store/modules/homebunner/BunnerProvider.ts
– src/store/modules/item/FeaturedItemProvider.ts
– src/store/modules/item/FollowerItemProvider.ts
– src/store/modules/item/ItemConditionProvider.ts
– src/store/modules/item/ItemCurrencyProvider.ts
– src/store/modules/item/ItemDealOptionProvider.ts
– src/store/modules/item/ItemPriceTypeProvider.ts
– src/store/modules/item/ItemTypeProvider.ts
– src/store/modules/item/PaidAdItemProvider.ts
– src/store/modules/item/PopularItemProvider.ts
– src/store/modules/item/ProductProvider.ts
– src/store/modules/item/RecentItemProvider.ts
– src/store/modules/itemLocationTownship/ItemLocationTownshipProvider.ts
– src/store/modules/itemPriceType/ItemPriceTypeProvider.ts
– src/store/modules/itemType/ItemTypeProvider.ts
– src/store/modules/itemcolor/ItemColorProvider.ts
– src/store/modules/itemlocation/ItemLocationProvider.ts
– src/store/modules/itemsellertype/ItemSellerTypeProvider.ts
– src/store/modules/limit/LimitAdItemProvider.ts
– src/store/modules/noti/NotiProvider.ts
– src/store/modules/offer/OfferProvider.ts
– src/store/modules/package/PackageProvider.ts
– src/store/modules/rating/RatingListProvider.ts
– src/store/modules/subCategory/SubCategoryProvider.ts
– src/store/modules/subCategory/SubCategoryScribeProvider.ts
– src/store/modules/user/UserListProvider.ts
– src/store/modules/user/UserProvider.ts
– src/views/about/About.vue
– src/views/blog/detail/BlogDetail.vue
– src/views/blog/list/BlogList.vue
– src/views/category/list/CategoryList.vue
– src/views/chat/Chat.vue
– src/views/chat/list/ChatList.vue
– src/views/chat/list/OfferList.vue
– src/views/contact/ContactUs.vue
– src/views/dashboard/Dashboard.vue
– src/views/item/detail/ItemDetail.vue
– src/views/item/entry/ItemEntry.vue
– src/views/item/favourite/FavouriteList.vue
– src/views/item/list/ActiveItemList.vue
– src/views/item/list/FollowerItemList.vue
– src/views/item/list/ItemList.vue
– src/views/item/list/PaidItemList.vue
– src/views/item/list/PendingItemList.vue
– src/views/item/list/RejectItemList.vue
– src/views/item/reported/ReportedItemList.vue
– src/views/notification/Notification.vue
– src/views/notification/NotificationList.vue
– src/views/privacy/Privacy.vue
– src/views/review/ReviewList.vue
– src/views/review/entry/ReviewEntry.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/EditProfile.vue
– src/views/user/Login.vue
– src/views/user/OtherProfile.vue
– src/views/user/PhoneLogin.vue
– src/views/user/Profile.vue
– src/views/user/Register.vue
– src/views/user/VerifyEmail.vue
– tailwind.config.js
– vue.config.js