function uc_views_marketing_install in Ubercart Views 6.3

Same name and namespace in other branches

1. 6.2 uc_views_marketing/uc_views_marketing.install \uc_views_marketing_install()

Implementation of hook_install().

File

uc_views_marketing/uc_views_marketing.install, line 168

Code

function uc_views_marketing_install() {
  db_query("CREATE VIEW {uc_order_products_qty_vw} (nid,order_count,avg_qty,sum_qty,max_qty,min_qty)  AS SELECT op.nid AS nid, COUNT(op.nid) AS order_count,AVG(op.qty) AS avg_qty, SUM(op.qty) AS sum_qty,MAX(op.qty) AS max_qty, MIN(op.qty) AS min_qty FROM {uc_order_products} op GROUP BY op.nid ORDER BY op.nid");
  db_query("CREATE VIEW {uc_order_products_user_vw} (nid,uid,order_count,avg_qty,sum_qty,max_qty,min_qty)  AS SELECT op.nid AS nid, o.uid AS uid, COUNT(o.order_id) AS order_count, AVG(op.qty) AS avg_qty, SUM(op.qty) AS sum_qty,MAX(op.qty) AS max_qty, MIN(op.qty) AS min_qty FROM {uc_order_products} op, {uc_orders} o where op.order_id =o.order_id GROUP BY o.uid,op.nid ORDER BY o.uid,op.nid");
  db_query("CREATE VIEW {uc_order_products_pair_vw} (nid,pair_nid,pair_sum_qty,order_count)  AS SELECT op1.nid AS nid, op2.nid AS pair_nid, SUM(op2.qty) AS pair_sum_qty, COUNT(op2.nid) AS order_count FROM {uc_order_products} op1, {uc_order_products} op2 WHERE op1.order_id = op2.order_id AND op1.nid <> op2.nid GROUP BY op1.nid, pair_nid  ORDER BY nid, order_count DESC, pair_sum_qty DESC");
}