libikk / ddiscounthero Goto Github PK

JavaScript 37.90% TypeScript 44.40% CSS 15.43% TSQL 2.28%

ddiscounthero's Introduction

Hi, I am Marek! 👋

I'm a creative and innovative javascript developer who is constantly seeking improvement.

Recent project

Please check out my recently developed site - www.DDiscounthero.com. DDiscounthero has been designed to help you monitor your favourite products (such as shoes, clothes, groceries or anything that is available online) and notify you about any discounts via email or push notifications.

About me

I am a big fan of gym and developing smart home devices using raspberry pi or ESP8266 modules using C++

📫 How to reach me:

Email: [email protected]

ddiscounthero's People

Contributors

Watchers

ddiscounthero's Issues

http -> https

test2

cookies bar

todo:

login validation
email confirmation
show error 500
http -> https
mobile friendly
on create new websitew, create row website selectors
add product price scan
add real domain
cookies information
last login update fix
reset password
language selection
landing page text

approve product if same website exist??

user roles

account settings

~~1. password change~~
~~2. current email and username~~
3. notifications preferences

ui tweaks

how it works icons sux
menu dropdown doesnt close back when you click somewhere else

last login update fix

google analitics

error handler solid

refactor some sql queries

do multiple in one querry

add product price scan

product scan

when it gets image src it save without protocol

add real domain

images skeleton loader

auto login from each page

#48

SQL param replacer

This example fails, because order of the object and way of replacing.

Conflicting:

'@isDiscountSelector': '.product-price .discount-percentage',
 '@isDiscountSelectorRegex': 'savee',

params:

{ '@id': 7,
  '@isClientSideCheck': 1,
  '@isDiscountSelector': '.product-price .discount-percentage',
  '@isDiscountSelectorRegex': 'savee',
  '@imageSelector': '.js-qv-product-cover',
  '@productNameSelector': '#main > div.col-md-6.pb-right-column > h1',
  '@productPriceSelector': null,
  '@productDiscountedPriceSelector': null,
  '@hostName': '4ecoshop.co.uk',
  '@url': 'https://4ecoshop.co.uk' }

Query:

UPDATE websitesselectors
SET
    isDiscountSelectorRegex = @isDiscountSelectorRegex,
    isClientSideCheck = @isClientSideCheck,
    isDiscountSelector = @isDiscountSelector,
    imageSelector = @imageSelector,
    productNameSelector = @productNameSelector,
    productPriceSelector = @productPriceSelector,
    productDiscountedPriceSelector = @productDiscountedPriceSelector
WHERE
    id = @id;

output:

SET
    isDiscountSelectorRegex = '.product-price .discount-percentage'Regex,
    isClientSideCheck = 1,
    isDiscountSelector = '.product-price .discount-percentage',
    imageSelector = '.js-qv-product-cover',
    productNameSelector = '#main > div.col-md-6.pb-right-column > h1',
    productPriceSelector = NULL,
    productDiscountedPriceSelector = NULL
WHERE
    id = 7;

params with order which doesnt cause the problem:

{ '@id': 7,
  '@isClientSideCheck': 1,
  '@isDiscountSelectorRegex': 'savee',
  '@isDiscountSelector': '.product-price .discount-percentage',
  '@imageSelector': '.js-qv-product-cover',
  '@productNameSelector': '#main > div.col-md-6.pb-right-column > h1',
  '@productPriceSelector': null,
  '@productDiscountedPriceSelector': null,
  '@hostName': '4ecoshop.co.uk',
  '@url': 'https://4ecoshop.co.uk' }