/**
* メーカー商品数数の登録を行う.
*
* @param Query $objQuery Query インスタンス
* @return void
*/
public function countMaker($objQuery)
{
//テーブル内容の削除
$objQuery->query('DELETE FROM dtb_maker_count');
//各メーカーの商品数を数えて格納
$sql = ' INSERT INTO dtb_maker_count(maker_id, product_count, create_date) ';
$sql .= ' SELECT T1.maker_id, count(T2.maker_id), CURRENT_TIMESTAMP ';
$sql .= ' FROM dtb_maker AS T1 LEFT JOIN dtb_products AS T2';
$sql .= ' ON T1.maker_id = T2.maker_id ';
$sql .= ' WHERE T2.del_flg = 0 AND T2.status = 1 ';
$sql .= ' GROUP BY T1.maker_id, T2.maker_id ';
$objQuery->query($sql);
}
