private void button3_Click(object sender, EventArgs e)// filtruoti statistik1
{
ordersStatisticsFilter = new OrderStatisticsFilter()
{
startDate = OrdersStatisticsStartdateTimePicker.Value.ToString("yyyy-MM-dd"),
endDate = OrdersStatisticsEnddateTimePicker.Value.ToString("yyyy-MM-dd")
};
database.fillOrderStatisticsGrid(dataGridView4, ordersStatisticsFilter);
}
private void pardavimųStatistikaToolStripMenuItem_Click(object sender, EventArgs e)
{
hideAll();
tableLayoutPanel4.Visible = true;
//pardavim7 statistikos logika
ordersStatisticsFilter = new OrderStatisticsFilter()
{
startDate = OrdersStatisticsStartdateTimePicker.Value.ToString("yyyy-MM-dd"),
endDate = OrdersStatisticsEnddateTimePicker.Value.ToString("yyyy-MM-dd")
};
database.fillOrderStatisticsGrid(dataGridView4, ordersStatisticsFilter);
}
public void fillOrderStatisticsGrid(DataGridView grid, OrderStatisticsFilter filter)
{
//SELECT name, real_price, sum(quantity), sum(quantity)*real_price, bts_carts.created_at FROM marsud.bts_products, marsud.bts_carts inner join marsud.bts_packs on bts_carts.id = bts_packs.cart where bts_carts.status = 'done' and product = bts_products.id group by product
string Query = "SELECT name as 'Pavadinimas', real_price as 'Kaina', sum(quantity) as 'Kiekis', sum(quantity)*real_price as 'Pardavimų suma' " +
"FROM marsud.bts_products, marsud.bts_carts inner join marsud.bts_packs on bts_carts.id = bts_packs.cart " +
"where bts_carts.status = 'done' and product = bts_products.id";
if (filter != null)
{
string str = "";
if (!string.IsNullOrEmpty(filter.startDate) && filter.startDate != filter.endDate)
{
str = str + " and marsud.bts_carts.created_at>='" + filter.startDate + "'";
}
if (!string.IsNullOrEmpty(filter.endDate) && filter.startDate != filter.endDate)
{
str = str + " and marsud.bts_carts.created_at<='" + filter.endDate + "'";
}
Query = Query + str;
}
Query = Query + " group by product order by Kiekis desc";
gridFillWithQuery(grid, Query);
DataGridViewColumn column1 = grid.Columns[0];
column1.Width = 200;
DataGridViewColumn column2 = grid.Columns[1];
column2.Width = 100;
DataGridViewColumn column3 = grid.Columns[2];
column3.Width = 100;
}
public void fillOrderStatisticsGrid(DataGridView grid, OrderStatisticsFilter filter)
{
//SELECT name, real_price, sum(quantity), sum(quantity)*real_price, bts_carts.created_at FROM marsud.bts_products, marsud.bts_carts inner join marsud.bts_packs on bts_carts.id = bts_packs.cart where bts_carts.status = 'done' and product = bts_products.id group by product
string Query = "SELECT name as 'Pavadinimas', real_price as 'Kaina', sum(quantity) as 'Kiekis', sum(quantity)*real_price as 'Pardavimų suma' " +
"FROM marsud.bts_products, marsud.bts_carts inner join marsud.bts_packs on bts_carts.id = bts_packs.cart "+
"where bts_carts.status = 'done' and product = bts_products.id";
if (filter != null)
{
string str = "";
if (!string.IsNullOrEmpty(filter.startDate) && filter.startDate!= filter.endDate)
{
str = str + " and marsud.bts_carts.created_at>='" + filter.startDate+"'";
}
if (!string.IsNullOrEmpty(filter.endDate) && filter.startDate != filter.endDate)
{
str = str + " and marsud.bts_carts.created_at<='" + filter.endDate+"'";
}
Query = Query + str;
}
Query = Query + " group by product order by Kiekis desc";
gridFillWithQuery(grid, Query);
DataGridViewColumn column1 = grid.Columns[0];
column1.Width = 200;
DataGridViewColumn column2 = grid.Columns[1];
column2.Width = 100;
DataGridViewColumn column3 = grid.Columns[2];
column3.Width = 100;
}
private void button3_Click(object sender, EventArgs e)// filtruoti statistik1
{
ordersStatisticsFilter = new OrderStatisticsFilter()
{
startDate = OrdersStatisticsStartdateTimePicker.Value.ToString("yyyy-MM-dd"),
endDate = OrdersStatisticsEnddateTimePicker.Value.ToString("yyyy-MM-dd")
};
database.fillOrderStatisticsGrid(dataGridView4, ordersStatisticsFilter);
}
private void pardavimųStatistikaToolStripMenuItem_Click(object sender, EventArgs e)
{
hideAll();
tableLayoutPanel4.Visible = true;
//pardavim7 statistikos logika
ordersStatisticsFilter = new OrderStatisticsFilter()
{
startDate = OrdersStatisticsStartdateTimePicker.Value.ToString("yyyy-MM-dd"),
endDate = OrdersStatisticsEnddateTimePicker.Value.ToString("yyyy-MM-dd")
};
database.fillOrderStatisticsGrid(dataGridView4, ordersStatisticsFilter);
}
