<?php

function np_get_all_catalog_group() {
    global $wpdb;
    $qr = "SELECT id, name FROM catalog_group WHERE deleted_at IS NULL";
    $rs = $wpdb->get_results($qr);
    return $rs;
}

function np_get_catalog_of_catalog_group_by_id($catalog_group_id) {
    global $wpdb;
    $qr = "SELECT cata.id, cata.name, cata.description ,cata.icon_path, cata.order, cata.catalog_group_id FROM catalog AS cata
           INNER JOIN catalog_group as cata_gr ON cata.catalog_group_id = cata_gr.id
           WHERE cata_gr.id = %d
           AND cata.deleted_at IS NULL
           AND cata_gr.deleted_at IS NULL
           ORDER BY cata.id";
    $sql = $wpdb->prepare($qr, $catalog_group_id);
    $rs = $wpdb->get_results($sql);
    return $rs;
}

function renderCatalogs($is_banner) {
    extract(shortcode_atts(array(
        'is_banner' => 'true'
    ), $is_banner));
    $catalog_groups = np_get_all_catalog_group();
    $rt_html = '<div class="catalog-wrapper ';
    if ($is_banner === 'false') {
        $rt_html .= 'not-banner ';
    }
    $rt_html .= 'clearfix"><div class="catalog-group-inner-wrapper">';
    $count = 0;
    foreach ($catalog_groups as $catalog_group) {
        $count++;
        $rt_html .= '
            <div class="catalog-group-container ';
            if ($count === 2) {
                $rt_html .= 'renewable';
            }
            $rt_html .= '">
                <div class="catalog-group-main-content">
                        <div class="catalogs-group-item clearfix">
                            <div class="catalog-group-title">
                                <h4><span>'. $catalog_group->name . '</span></h4>
                            </div>
                            <div class="catalog-main-content">';
        $catalogs = np_get_catalog_of_catalog_group_by_id($catalog_group->id);
        $count_item = 0;
        foreach ($catalogs as $catalog) {
            $count_item++;
            $rt_html .= '<a href="#" class="catalog-item-wrapprer ';
            $rt_html .= 'catalog-item-' . $count_item;
            $rt_html .= '">
                                    <div class="catalog-inner">
                                        <div class="catalog-icon">
                                            <img src="'. DOMAIN_ICON_RESOURCE . $catalog->icon_path . '" alt="'.$catalog->name .'">
                                        </div>
                                        <div class="catalog-title">
                                            <p>' . $catalog->name . '</p>
                                        </div>
                                    </div>
                                    <div class="catalog-info">
                                        <p>' . $catalog->description . '</p>
                                    </div>
                                </a>';
        }
        $rt_html .= '</div>
                    </div>
                </div>
            </div>';
    }

    $rt_html .= '</div></div>';
    return $rt_html;
}

add_shortcode('np_catalog', 'renderCatalogs');