{foreach from=Database::getInstance()->system_entity("system_entity.table", Parameter::getTableName($MODULE)) item=ENTITY}
{if in_array($ENTITY['type'], array('belong', 'has', 'have', 'enum')) && $ENTITY['statistic'] != 'none'}
{if $ENTITY['type'] == 'have'}
{assign var=JOIN value=$ENTITY['field']}
{if strpos($ENTITY['field'], $ENTITY['table']) === 0}
{assign var=ENTITY_TABLE value=$ENTITY['table']}
{assign var=REF value=trim(str_replace($ENTITY['table'], '', $ENTITY['field']), '_')}
{else}
{assign var=REF value=$ENTITY['table']}
{assign var=ENTITY_TABLE value=trim(str_replace($ENTITY['table'], '', $ENTITY['field']), '_')}
{/if}
{elseif in_array($ENTITY['type'], array('belong', 'enum'))}
{assign var=ENTITY_TABLE value=$ENTITY['table']}
{assign var=REF value=$ENTITY['field']}
{else}
{assign var=ENTITY_TABLE value=$ENTITY['field']}
{assign var=REF value=$ENTITY['table']}
{/if}
{assign var=PIE_CHART_ITEMS value=array()}
{assign var=BAR_CHART_ITEMS value=array()}
{if $ENTITY['type'] == 'enum'}
{assign var=REF_ITEMS value=json_decode($ENTITY['extra'])}
{else}
{assign var=REF_ITEMS value=Database::getInstance()->$REF()}
{/if}
{foreach from=$REF_ITEMS item=REF_ITEM}
{assign var=PIE_CHART_ITEM value=array()}
{if $ENTITY['type'] == 'have'}
{$PIE_CHART_ITEM['label'] = $REF_ITEM[$ENTITY['statistic']]}
{$PIE_CHART_ITEM['data'] = count($REF_ITEM->$JOIN())}
{elseif $ENTITY['type'] == 'enum'}
{$PIE_CHART_ITEM['label'] = $REF_ITEM}
{$PIE_CHART_ITEM['data'] = count(Database::getInstance()->$ENTITY_TABLE($REF, $REF_ITEM))}
{else}
{$PIE_CHART_ITEM['label'] = $REF_ITEM[$ENTITY['statistic']]}
{$PIE_CHART_ITEM['data'] = count($REF_ITEM->$ENTITY_TABLE())}
{/if}
{$PIE_CHART_ITEMS[] = $PIE_CHART_ITEM}
{assign var=BAR_CHART_ITEM value=array()}
{if $ENTITY['type'] == 'have'}
{$BAR_CHART_ITEM[] = $REF_ITEM[$ENTITY['statistic']]}
{$BAR_CHART_ITEM[] = count($REF_ITEM->$JOIN())}
{elseif $ENTITY['type'] == 'enum'}
{$BAR_CHART_ITEM[] = $REF_ITEM}
{$BAR_CHART_ITEM[] = count(Database::getInstance()->$ENTITY_TABLE($REF, $REF_ITEM))}
{else}
{$BAR_CHART_ITEM[] = $REF_ITEM[$ENTITY['statistic']]}
{$BAR_CHART_ITEM[] = count($REF_ITEM->$ENTITY_TABLE())}
{/if}
{$BAR_CHART_ITEMS[] = $BAR_CHART_ITEM}
{/foreach}
{if in_array($ENTITY['type'], array('enum', 'have'))}
{Parameter::formatName($REF)}
{elseif $ENTITY['type'] == 'has'}
{$MODULE}
{else}
{Parameter::formatName($REF)}
{/if}
Pie Chart
{if in_array($ENTITY['type'], array('enum', 'have'))}
{Parameter::formatName($REF)}
{elseif $ENTITY['type'] == 'has'}
{$MODULE}
{else}
{Parameter::formatName($REF)}
{/if}
Bar Chart
{/if}
{/foreach}