productModule

productModule

class to handle product functions

Constructor

new productModule()

Source:

Methods

(async, static) addattachement(data, proid) → {object}

Source:

add attachemnt

Parameters:
Name Type Description
data object

data

proid number

project id

Returns:

sql response

Type
object

(async, static) addattachementtoproduct(req, data) → {object}

Source:

add attachment to product

Parameters:
Name Type Description
req object

request data

data object

data

Returns:

sql response

Type
object

(async, static) addcategory(req, data) → {object}

Source:

add category

Parameters:
Name Type Description
req object

request data

data object

data

Returns:

sql response

Type
object

(async, static) allInvoiceItems(id, data, count) → {object}

Source:

all invlice Items

Parameters:
Name Type Description
id number

project id

data object

data

count number

count

Returns:

sql response

Type
object

(async, static) allReturnInvoiceItems(cartID, data, count) → {object}

Source:

all return invoice times

Parameters:
Name Type Description
cartID number

cart id

data string

data

count number

count

Returns:

sql response

Type
object

(async, static) auctionProjectUpdateexist(req) → {object}

Source:

auction project update exist

Parameters:
Name Type Description
req object

request data

Returns:

sql response

Type
object

(async, static) auctionProjectUpdateexistrest(req) → {object}

Source:

auction project update exist rest

Parameters:
Name Type Description
req object

request data

Returns:

sql response

Type
object

(async, static) bidHistory(id, cnt) → {object}

Source:

Fetch All Bid history

Parameters:
Name Type Description
id object

project id

cnt number

count for the pagination

Returns:

sql response

Type
object

(async, static) bidHistoryViewPage(req, count) → {object}

Source:

Fetch Bid history

Parameters:
Name Type Description
req object

req.body

count number

count for the pagination

Returns:

sql response

Type
object

(async, static) bidsawarded(pid, uid) → {object}

Source:

bids awarded

Parameters:
Name Type Description
pid number

project id

uid number

user id

Returns:

sql response

Type
object

(async, static) bidsnotifyall(pid, uid) → {object}

Source:

bids notify all

Parameters:
Name Type Description
pid number

project id

uid number

user id

Returns:

sql response

Type
object

(async, static) cartqtyproduct(data, proid)

Source:

cart qty product

Parameters:
Name Type Description
data object

data

proid number

product id

(async, static) cartqtyproductsoldvalue(data, proid)

Source:

cart qty product sold values

Parameters:
Name Type Description
data object

data

proid number

product id

(async, static) cartqtyproductsub(data, fieldType, proid, baseTableUsed) → {object}

Source:

cart quntity

Parameters:
Name Type Description
data object

data

fieldType number

field taype

proid number

product id

baseTableUsed string

base table used

Returns:

sql response

Type
object

(async, static) checkbidPlacedwhoutlogin(pid) → {object}

Source:

check bid placed without login

Parameters:
Name Type Description
pid number

project id

Returns:

sql response

Type
object

(async, static) commondeleteparenttable(proid, baseTableUsed, baseid) → {object}

Source:

get all sub lots new

Parameters:
Name Type Description
proid number

product id

baseTableUsed string

base table used

baseid number

base id

Returns:

sql response

Type
object

(async, static) commonselectparenttable(data, baseid, proid, baseTableUsed) → {object}

Source:

common select parent table

Parameters:
Name Type Description
data object

data

baseid number

base id

proid number

project id

baseTableUsed string

base table name

Returns:

sql response

Type
object

(async, static) deleteattachement(req, proid) → {object}

Source:

delete attachment

Parameters:
Name Type Description
req object

request data

proid number

proid

Returns:

sql response

Type
object

(async, static) deleteAvatax(items) → {object}

Source:

delete avatax

Parameters:
Name Type Description
items object

items

Returns:

sql response

Type
object

(async, static) fetchAllAttachments(pid) → {object}

Source:

getch all attachments

Parameters:
Name Type Description
pid number

project id

Returns:

sql response

Type
object

(async, static) fetchAuctionbyID(pid)

Source:

fetch auction by id

Parameters:
Name Type Description
pid number

product id

(async, static) getAllReturnTransactions(cartID) → {object}

Source:

get all return transactions

Parameters:
Name Type Description
cartID number

cart id

Returns:

sql response

Type
object

(async, static) getAllSubLotsnew(id) → {object}

Source:

get all sub lots new

Parameters:
Name Type Description
id number

id

Returns:

sql response

Type
object

(async, static) getAllTransactions(cartID) → {object}

Source:

get All Transactions

Parameters:
Name Type Description
cartID number

cart id

Returns:

sql response

Type
object

(async, static) getAppointmentDetails(cartID) → {object}

Source:

get Appointment Deatails

Parameters:
Name Type Description
cartID number

cart id

Returns:

sql response

Type
object

(async, static) getAvatax(items) → {object}

Source:

insert avatax

Parameters:
Name Type Description
items object

items

Returns:

sql response

Type
object

(async, static) getCommonInvoiceNo(data, proid, baseTableUsed) → {object}

Source:

get Common Invoice no

Parameters:
Name Type Description
data object

data

proid number

project id

baseTableUsed string

base table used

Returns:

sql response

Type
object

(async, static) getInvoiceCartDetails(cartid) → {object}

Source:

all invlice Items

Parameters:
Name Type Description
cartid number

cart id

Returns:

sql response

Type
object

(async, static) getLocationDetails(cartID) → {object}

Source:

get location details

Parameters:
Name Type Description
cartID number

cart id

Returns:

sql response

Type
object

(async, static) getlotcartsdetails(data, proid, userid, baseTableUsed) → {object}

Source:

get lot carts details

Parameters:
Name Type Description
data object

data

proid number

product id

userid number

user id

baseTableUsed string

base table used

Returns:

sql response

Type
object

(async, static) getlotdetails(data, proid, baseTableUsed) → {object}

Source:

auction project update exist rest

Parameters:
Name Type Description
data object

data

proid object

data

baseTableUsed string

data

Returns:

sql response

Type
object

(async, static) getparticulartabledetails(data, fieldType, postID, baseTableUsed) → {object}

Source:

get particular table details

Parameters:
Name Type Description
data object

data

fieldType number

field taype

postID number

post id

baseTableUsed string

base table used

Returns:

sql response

Type
object

(async, static) getPrivateSoldQty(id, id) → {object}

Source:

get private Sold Quantity

Parameters:
Name Type Description
id object

project id

id number

project id

Returns:

sql response

Type
object

(async, static) getProxyDetails(pid, type) → {object}

Source:

check bid placed without login

Parameters:
Name Type Description
pid number

project id

type string

type

Returns:

sql response

Type
object

(async, static) getReturnAppointmentDetails(cartID) → {object}

Source:

get return appointment details

Parameters:
Name Type Description
cartID number

cart id

Returns:

sql response

Type
object

(async, static) getReturnInvoiceCartDetails(cartID) → {object}

Source:

get return invoice cart details

Parameters:
Name Type Description
cartID number

cart id

Returns:

sql response

Type
object

(async, static) getReturnLocationDetails(cartID) → {object}

Source:

get return location details

Parameters:
Name Type Description
cartID number

cart id

Returns:

sql response

Type
object

(async, static) getSearchSortCategories(id) → {object}

Source:

get search sort categories

Parameters:
Name Type Description
id object

project id

Returns:

sql response

Type
object

(async, static) getSecondHighestBidderTTW(id) → {object}

Source:

get second higest bidder ttw

Parameters:
Name Type Description
id number

project id

Returns:

sql response

Type
object

(async, static) getUserProxyAmt(pid, uid) → {object}

Source:

get user proxy amt

Parameters:
Name Type Description
pid number

project id

uid number

user id

Returns:

sql response

Type
object

(async, static) insertAvatax(items, tax, address) → {object}

Source:

get all sub lots new

Parameters:
Name Type Description
items object

items

tax number

tax

address string

address

Returns:

sql response

Type
object

(async, static) isbuyerbidstarted(id, cnt) → {object}

Source:

Fetch All Bid history

Parameters:
Name Type Description
id object

project id

cnt number

count for the pagination

Returns:

sql response

Type
object

(async, static) postalltypeoflisting(req, data, baseTableUsed)

Source:

post all type of listing

Parameters:
Name Type Description
req object

request data

data object

data

baseTableUsed string

base table used

(async, static) postlistingCustom(req, data, proID)

Source:

post listing custom

Parameters:
Name Type Description
req object

request object

data data

data

proID number

project id

(async, static) postproduct(req) → {object}

Source:

post product

Parameters:
Name Type Description
req object

request object

Returns:

sql response

Type
object

(async, static) productstatusupdate(data, proid) → {object}

Source:

produt status update

Parameters:
Name Type Description
data object

data

proid number

product id

Returns:

sql response

Type
object

(async, static) searchDashboardProducts(req, data, count) → {object}

Source:

Search all the dashboard products

Parameters:
Name Type Description
req object

req object

data object

req.body object

count number

count for the pagination

Returns:

sql response

Type
object

(async, static) searchInvoiceProducts(req, data, count) → {object}

Source:

Search all the invoice products

Parameters:
Name Type Description
req object

req object

data object

req.body object

count number

count for the pagination

Returns:

sql response

Type
object

(async, static) searchInvoiceProductsNew(req, data, count) → {object}

Source:

Search all the new invoice products

Parameters:
Name Type Description
req object

req object

data object

req.body object

count number

count for the pagination

Returns:

sql response

Type
object

(async, static) searchProducts(req, data, count) → {object}

Source:

Search all the search products

Parameters:
Name Type Description
req object

req object

data object

req.body object

count number

count for the pagination

Returns:

sql response

Type
object

(async, static) searchReturnProducts(req, data, count) → {object}

Source:

Search all the return products

Parameters:
Name Type Description
req object

req object

data object

req.body object

count number

count for the pagination

Returns:

sql response

Type
object

(async, static) ttwBidHistory(pid, uid) → {object}

Source:

ttw bid history

Parameters:
Name Type Description
pid number

project id

uid number

user id

Returns:

sql response

Type
object

(async, static) ttwSearchDashboardProducts(req, data, count) → {object}

Source:

Search all the dashboard products

Parameters:
Name Type Description
req object

req object

data object

req.body object

count number

count for the pagination

Returns:

sql response

Type
object

(async, static) updateAllCloseDates(dateAdded, dateClosed, pid) → {object}

Source:

update all close dates

Parameters:
Name Type Description
dateAdded string

date added

dateClosed string

date closed

pid number

product id

Returns:

sql response

Type
object

(async, static) updatealltypeofproduct(req, data, proid, typeoffield, baseTableUsed) → {object}

Source:

update all type of product

Parameters:
Name Type Description
req object

request data

data object

data

proid number

proid

typeoffield string

type of field

baseTableUsed string

base table used

Returns:

sql response

Type
object

(async, static) updateAvatax(items) → {object}

Source:

update avatax

Parameters:
Name Type Description
items object

items

Returns:

sql response

Type
object

(async, static) updatecartsbuynow(req, data, proid) → {object}

Source:

update cart buynow

Parameters:
Name Type Description
req req

request data

data object

data

proid number

product id

Returns:

sql response

Type
object

(async, static) updatecategory(req, data) → {object}

Source:

update category

Parameters:
Name Type Description
req object

request data

data object

data

Returns:

sql response

Type
object

(async, static) updatelistingCustom(req, data, proID) → {object}

Source:

update listing custom

Parameters:
Name Type Description
req object

request object

data object

data

proID number

project id

Returns:

sql response

Type
object

(async, static) updatelofdetails(id, date) → {object}

Source:

get all sub lots new

Parameters:
Name Type Description
id number

id

date string

date

Returns:

sql response

Type
object

(async, static) updateproduct(req, data)

Source:

update product

Parameters:
Name Type Description
req object

request object

data data

data