need help data query please

[narbner]

meron po kaming project tapos ang client namin nag bebenta ng products isa sa function na kailangan ma achive eh
kung walang stock ung store na bibilhan ng customer mag rerefer ung system ng pinka malapit na store para dun sya umor der
pa help nnman po sa query need lang talga salmat po...
ung parang sa national bookstore pag walang libro sa isang branch nila mag rerefer ung system nila kung anong branch meron dun...


Ito na po yung final features namin:

Online Selling
--> payments through paypal

Dashboard
--> comment
-->feedbacks
-->interaction with cleints

Trends (graphical)
-->system suggest the nearest branch to the customer

Centralized
-->reports
-->invoices
-->view each branch
-->view sales

 

[narbner]

up up uplease

 

[erickock]

up up uplease

sql query ba need mo?

 

[narbner]

sql query ba need mo?

opo sir sql query kung paano gagawin un.. ung inventory pa nila di ko alam kung pano papalanuhun kung ibat ibang database ba o isang db lang pero ibang tabale ung branch ng company.. nahihirapan po ako eh/

 

[ciaossu21]

pa-post nung table structure ts. baka makatulong sa query




~ tGbtG

 

[bhabyqoueh]

pa-post nung table structure ts. baka makatulong sa query




~ tGbtG

saken sir ganito ung table
View attachment 203762

eh ang kelangan ko sana is makuha ung average nung item for the past 3 months as of todate..
example 6/1/2014 na ngaun ganito sna makukuha ko result

sku desc average for past 3months
asusz5 50%
nokia 2%

panu kaya diskarte neto sir? hope you can help me, 1 month ko na to pinag iisipan, huhuhu..

 

[gutierrez_ronnel]

TS,

meron ka table ng mga stocks?

dump ko kaya DB mo? tapos save mo sa mediafire, DL nalang namen nun. tapos tulungan ka sa query..

pero something ganito lang logic nun:

SELECT
SUM(a.f_stock_quantity) AS 'TotalStocks',
SUM(b.f_total_sales) AS 'TotalSales',
SUM(SUM(b.f_total_sales)/SUM(a.f_stock_quantity))*100 AS 'PercentageSales'
FROM
tbl_stocks a
INNER JOIN tbl_sales b ON a.f_sku_code = b.f_sku_code
WHERE a.date_updated BETWEEN '2014-06-01' AND '2014-12-01'
GROUP BY a.f_sku_code


pero something ganyan din kasi yan eh... mas maganda kasi may actual data, para same page tayo.

 

[narbner]

update ko kayo sa progress ko.. sana magawa ko to.,.