function uc_views_install in Ubercart Views 6

Same name and namespace in other branches

1. 6.2 uc_views.install \uc_views_install()

Implentation of the hook_install().

File

./uc_views.install, line 6

Code

function uc_views_install() {

  //Create db views to make agregations on UC tables
  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 `nid`, `pair_nid`  ORDER BY `nid`, `order_count` DESC, `pair_sum_qty` DESC");
}