Vyššie na [Platon] / tucniak / lib

Initial import

// Copyright (c) 2003,2004,2005 Juraj Kolesár <koli@koli.sk>               
#include "lt.h"
/* data init {{{ **************************************************************/
int lt_s_item_data_init(T_ITEM *item) {
    register int i;
    for (i=0;i<__LT_S_ITEM_PARAM_COUNT;i++) item->status[i] = false;
    SET_CELL(item->pk,         "", "pk_s_items",     0);
    SET_CELL(item->number,    "", "number",         10);
    SET_CELL(item->name,    "", "name",         20);
    SET_CELL(item->code,    "", "code",         __LT_S_ITEM_WIDTH_CODE);
    SET_CELL(item->messure,    "", "messure",        __LT_S_ITEM_WIDTH_MESSURE);
    SET_CELL(item->price,    "", "price",        10);
    return(__LT_OK);
}
/* }}} */
/* data clear {{{ *************************************************************/
int lt_s_item_data_clear(T_ITEM *item) {
    register int i;
    item->pk.value[0] = '\0';
    item->number.value[0] = '\0';
    item->name.value[0] = '\0';
    item->code.value[0] = '\0';
    item->messure.value[0] = '\0';    
    item->price.value[0] = '\0';
    for (i=0;i<__LT_S_ITEM_PARAM_COUNT;i++) item->status[i] = false;
    return(__LT_OK);
}
/* }}} */
/* data get {{{ ***************************************************************/
int lt_s_item_data_get(T_DB *tdb, T_ITEM *item) {
    if (!(item->status[__LT_S_ITEM_NAME])) {
        tdb_query_cell(tdb, item->name.value, g_strdup_printf(
            "SELECT name FROM s_items WHERE pk_s_items='%s'", item->pk.value));
        item->status[__LT_S_ITEM_NAME] = true;
    }
    if (!(item->status[__LT_S_ITEM_NUMBER])) {
        tdb_query_cell(tdb, item->number.value, g_strdup_printf(
            "SELECT number FROM s_items WHERE pk_s_items='%s'", item->pk.value));
        item->status[__LT_S_ITEM_NUMBER] = true;
    }
    if (!(item->status[__LT_S_ITEM_CODE])) {
        tdb_query_cell(tdb, item->code.value, g_strdup_printf(
            "SELECT pk_s_codes "
            "FROM s_codes "
            "INNER JOIN s_items "
            "ON pk_s_codes=fk_s_codes "
            "WHERE pk_s_items='%s'", item->pk.value));
        tdb_query_cell(tdb, item->code.name, g_strdup_printf(
            "SELECT code "
            "FROM s_codes "
            "INNER JOIN s_items "
            "ON pk_s_codes=fk_s_codes "
            "WHERE pk_s_items='%s'", item->pk.value));
        item->status[__LT_S_ITEM_CODE] = true;
    }
    if (!(item->status[__LT_S_ITEM_MESSURE])) {
        tdb_query_cell(tdb, item->messure.value, g_strdup_printf(
            "SELECT pk_s_messures "
            "FROM s_messures "
            "INNER JOIN s_items "
            "ON pk_s_messures=fk_s_messures "
            "WHERE pk_s_items='%s'", item->pk.value));
        tdb_query_cell(tdb, item->messure.name, g_strdup_printf(
            "SELECT messure "
            "FROM s_messures "
            "INNER JOIN s_items " 
            "ON pk_s_messures=fk_s_messures "
            "WHERE pk_s_items='%s'", item->pk.value));
        item->status[__LT_S_ITEM_CODE] = true;
    }
    if (!(item->status[__LT_S_ITEM_PRICE])) {
        tdb_query_cell(tdb, item->price.value, g_strdup_printf(
            "SELECT price "
            "FROM s_add "
            "WHERE fk_s_items='%s' "
            "ORDER BY pk_s_add DESC", item->pk.value));
        item->status[__LT_S_ITEM_PRICE] = true;
    }
    return(__LT_OK);
}
/* }}} */
/* data set {{{ ***************************************************************/
int lt_s_item_data_set(T_DB *tdb, T_ITEM *item) {
    if (!(item->status[__LT_S_ITEM_PK])) {
        tdb_query(tdb, g_strdup_printf(
            "INSERT INTO s_items (number, name, fk_s_codes, fk_s_messures) " 
            "VALUES ('%s', '%s', '%s', '%s')",
            item->number.value, 
            item->name.value, 
            item->code.value, 
            item->messure.value));
        tdb_query_lastid(tdb, item->pk.value);
        item->status[__LT_S_ITEM_PK] = true;
        item->status[__LT_S_ITEM_NUMBER] = true;
        item->status[__LT_S_ITEM_NAME] = true;
        item->status[__LT_S_ITEM_CODE] = true;
        item->status[__LT_S_ITEM_MESSURE] = true;
    }
    return(__LT_OK);
}
/* }}} */
/* data remove {{{ ************************************************************/
int lt_s_item_data_remove(T_DB *tdb, T_ITEM *item) {
    tdb_query(tdb, g_strdup_printf(
        "DELETE FROM s_items WHERE pk_s_items='%s'", item->pk.value)
    );
    return(__LT_OK);
}
/* }}} */
/* next number {{{ ************************************************************/
int lt_s_item_next_number(T_DB *tdb, T_ITEM *item) {
    tdb_query_cell(tdb, item->number.value, "SELECT MAX(number) FROM s_items");
    str_inc(item->number.value);
    item->status[__LT_S_ITEM_NUMBER] = true;
    item->status[__LT_S_ITEM_NAME] = true;
    item->status[__LT_S_ITEM_CODE] = true;
    item->status[__LT_S_ITEM_MESSURE] = true;
    return(__LT_OK);
}
/* }}} */
/* qs init {{{ ****************************************************************/
int lt_s_item_qs_init(T_ITEM *item, T_COLS **cols, T_QS *qs) {
    *cols = g_slist_append(*cols, &(item->pk));    
    *cols = g_slist_append(*cols, &(item->number));    
    *cols = g_slist_append(*cols, &(item->code));    
    *cols = g_slist_append(*cols, &(item->name));    
    if (strlen(qs->columns) == 0) tdb_qs_set_columns(qs, *cols);
    if (strlen(qs->from) == 0)     
        strcpy(qs->from, "s_items INNER JOIN s_codes ON fk_s_codes=pk_s_codes");
    return(__LT_OK);
}
/* }}} */
/* qs overview {{{ ************************************************************/
int lt_s_item_qs_overview(T_QS *qs) {
    strcpy(qs->columns, "pk_s_items, number, code, name, sum(count)");
    strcpy(qs->from, "s_add "
                        "INNER JOIN s_items ON pk_s_items=fk_s_items "
                        "INNER JOIN s_codes ON fk_s_codes=pk_s_codes");
    strcpy(qs->group, "pk_s_items");
    return(__LT_OK);
}
/* }}} */
/* get codes {{{ **************************************************************/
int lt_s_item_get_codes(T_DB *tdb, T_MATRIX *matrix) {
    tdb_table_fill(tdb, matrix, "SELECT pk_s_codes, code FROM s_codes ORDER BY code");
    return(__LT_OK);
}
/* }}} */
/* get messures {{{ ***********************************************************/
int lt_s_item_get_messures(T_DB *tdb, T_MATRIX *matrix) {
    tdb_table_fill(tdb, matrix, "SELECT pk_s_messures, messure FROM s_messures");
    return(__LT_OK);
}
/* }}} */
/* new code {{{ **************************************************************/
int lt_s_item_new_code(T_DB *tdb, T_ITEM *item) {
    tdb_query(tdb, g_strdup_printf(
        "INSERT INTO s_codes (code)    VALUES ('%s')", item->code.name));
    tdb_query_lastid(tdb, item->code.value);
    return(__LT_OK);
}
/* }}} */
/* new messure {{{ **************************************************************/
int lt_s_item_new_messure(T_DB *tdb, T_ITEM *item) {
    tdb_query(tdb, g_strdup_printf(
        "INSERT INTO s_messures (messure) VALUES ('%s')", item->messure.name));
    tdb_query_lastid(tdb, item->messure.value);
    return(__LT_OK);
}
/* }}} */