belherdigital / open-eshop Goto Github PK

And appears at home page slider

Put up in the route...if exists then page first.

Import from excel:

Email Name Product_seotitle amount date_paid

Create user if doesnt exists
Search for product, if exists->Create order

Add products reviews so later we can short by reviews.

Star system + Comment.

Only after purchase you can add 1 review.

Review option to disable. Doesn't appear in the product page or to add the review in the user panel.e

Add field Rank/rate to products. it recalculates after new review its posted.

So we need to:

• Add new field Rank to product
• Use table reviews
• oc-panel:
  • add review to purchase, sends thanks email to buyer and to product owner notifying him
  • review controller list, email, product, rating, date -> edit, delete. On edit delete recalculate!
• Product display reviews
• Public controller last reviews, Product, comment, rating. if review enabled
• product listing display stars (only image) if review enabled.

mysql_query("CREATE TABLE IF NOT EXISTS ".$_POST['TABLE_PREFIX']."reviews (
id_review int(10) unsigned NOT NULL AUTO_INCREMENT,
id_user int(10) unsigned NOT NULL,
id_product int(10) unsigned NOT NULL,
rate int(2) unsigned NOT NULL DEFAULT '0',
description text NOT NULL,
created timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
ip_address float DEFAULT NULL,
status tinyint(1) NOT NULL DEFAULT '0',
PRIMARY KEY (id_review) USING BTREE,
KEY ".$_POST['TABLE_PREFIX']."reviews_IK_id_user (id_user),
KEY ".$_POST['TABLE_PREFIX']."reviews_IK_id_product (id_product)
) ENGINE=InnoDB DEFAULT CHARSET=".$POST['DBCHARSET'].";");```

API, were we send the license key and returns if its valid or not.

If was not activated we activate the license and we store the domain from were was used.

If they are trying to activate form different domain return KO.

Implement it on Open Classifieds, when theme is first installed. And then to check it every day that still uses a license. We can store a config with last verification.

Controller on panel like widgets but for menus.

Should appear all the dynamic pages + all the categories + all the static pages.

We store it as a config.

https://es.bitcoin.it/wiki/Introducci%C3%B3n_para_desarrolladores_de_PHP
https://github.com/mikegogulski/bitcoin-php
https://bips.me/pricing
https://bitpay.com/pricing
https://coinbase.com/

Display:
File type amnd size (if theres)
Support Days
Licenses
License duration

Add sales manually:

User Email
User Name
Product
Amount
Currency
Date paid
Method

Check email new reply.

Put up in the route...if exists then page first.

Some configs are not in use any more.
New configs:
PRODUCT(max_size, num_images, formats)

Removed:
Advertisements in Map, Moderation, Advertisements in RSS

Rename:
general.advertisements_per_page to general.product_per_page

Sidebar coupon form. (after purchase we delete the session)

id_cupon
name -> unique
expire date
number of coupons
% percentage 0
fixed amount 0

Only display, logo title, 1 screenshot price and purchase buttons.

No menu, no widgets no footer.

Specially made to be opened in a modal.

Able to specify a return paypal page from config like in the TOS.

Or better display the 'email_purchase_notes' field in a thanks page?

Using same as OC blog.

But adding fields to allow use the table posts for the forums.

id_post
id_user
id_forum (null)
title
description
created
ip_Address

Todo:
Route /blog/TITLE.html
config activate blog
Menu link
Sitemap
Feed

contact.html etc...

To avoid problems when routing if they use an existing route name

Done for the payment with paymill. If redirected form created open paymill pay box.

• Create a config for admin called affiliates. With options::
  Activate affiliates (true/false)
  Payout days (number of days that a commission is paid)
  Minimum paid XX€ by currency
  Days Cookie
  Terms of service page (displayed in the affiliate panel)
• User Affiliate panel:
  Panel only appears if affiliates active
  Text resume how many days cookie lasts, minimum to get paid, button to add paypal account
  Will show the affiliate link (product select and modal).
  Total earn / visits / conversion %
  Total Month / visits / conversion %
  Total since last payment / visits / conversion %
  View payments (orders without product)
  All affiliates sales paginated
• Affiliate flow
  All users are affiliates
  &a=67(affiliate number) at any url will give XX days cookie
  Every visit store id_affiliate
  Purchase paid create an affiliate line at table affiliates
  Send email to affiliate.
• Affiliate to get paid (todo elaborate)
  Only pay affiliate lines that are older than X days
  Generates an order negative amount, without product, update affiliate lines with id order
  Sends an email to affiliate that he got paid.
• users Table
  New field paypal_account
• Views table
  Affiliate ID
• oe_affiliates TABLE
  id_affilate
  id_order
  id_user
  created
  status (0=new,1=paid.10=refunded)
  date_paid
  percentage
  amount
  currency

user can open tickets for orders they have made

https://github.com/open-classifieds/openclassifieds2/issues/396

new.sale

Option in general to set public publishing products.

Market = on/off
Market price = X USD (to publish a product)

User has panel access to:

• Profile has payment options, paypal email, and paymill (only appears if market option ON)
• Products, filter for his. Restrict delete, edit etc.. We dont allow to create new product if he didnt put his paypal at least.
• To create product needs to pay unless market price its 0.
• Tickets, that he opened and those that belong to him (from any of his products)
• Global stats filtered by user /stats/IDUSER

To modify:

• Notify of new sale to the product owner
• Notify of new ticket/answer to product owner
• Payment is done to the paypal paymill account of the product owner

Displays products and buttons to read more and pay. responsive.

In products we need a license expire days.

If 0 never expires.

https://github.com/open-classifieds/openclassifieds2/issues/386

Validation with JS for the forms

Display in product page # of purchases, set it as a config.

Dropdown to show all pages, if none selected, use normal listing of products. If not display page content, using the title.

For the admin part I mean

Table posts:

id_post
id_user
type = 1= blog 2 = forum
id_category
title
description
created_DAte
published_Date
ip_Address

Table categories product/blog/forums (2 different controllers same table):
id_category
type = 0=products 1= blog 2 = forum

table comments
id_post
id_user
id_category
description
date
ip_Address

table_visit (add)
id_post
type = 0=products 1= blog 2 = forum

Public controllers:
Blog:
/blog/CATEGORY/
/blog/TITLE.html
/forum/FORUMCAT/
/forum/TITLE.html
/forum/new-topic.html

Configs to activate/deactivate blog/forum will show icon on header

Widget:
latest forums/blog, latest comments forum/blog.
Categories forum/blog

Also in OC

Check links and sidebar icons

For the 2 kinds of users.