// MODULE Expenses;

FORM exportDataReception ' '
    OBJECTS r = Reception
    PROPERTIES READONLY
        date = date(header(r)), number = number(header(r)), shop = organizationName(header(r)),
        pname = name(r), quantity(r), price(r), 
        username = userName(header(r)), userdate = userDate(header(r))
    ORDERS date, number
;

onExport ' ' () {
    EXPORT exportDataReception XLSX HEADER TO r=exportFile;
    WRITE exportFile() TO 'file://c:/1/prihod';
}

FORM exportDataExpenses ' '
    OBJECTS e = Expenses
    PROPERTIES READONLY
        date = date(header(e)), number = number(header(e)), shop = organizationName(header(e)),
        pname = name(e), quantity(e), price(e),
        username = userName(header(e)), userdate = userDate(header(e))
    ORDERS date, number
;


onExport2 ' ' () {
    EXPORT exportDataExpenses XLSX HEADER TO e=exportFile;
    WRITE exportFile() TO 'file://c:/1/rashod';
}

EXTEND FORM viewExpenses PROPERTIES onExport(), onExport2();


// 
onImport1 ' ' () {
    LOCAL date, userdate = DATE(INTEGER);
    LOCAL number = STRING[10](INTEGER);
    LOCAL number2 = STRING();
    LOCAL shop, name, username = STRING[100](INTEGER);
    LOCAL quantity = NUMERIC[10,3](INTEGER);
    LOCAL price = NUMERIC[10,2](INTEGER);
    LOCAL h = HeaderReception();
    number2() <- '';
    INPUT dbfile = NAMEDFILE DO {
        IMPORT XLS HEADER FROM dbfile TO date = A, number = B, shop = C,
                name = D, quantity = E, price = F, username = G, userdate = H;
        FOR imported(INTEGER i) ORDER i DO NEW r = Reception {
            IF number2() != number(i) THEN {
                number2() <- number(i);
                NEW h = HeaderReception {
                    h() <- h;
                    date(h) <- date(i);
                    number(h) <- number(i);
                    supplier(h) <- GROUP MAX (Organization o) IF name(o) = shop(i);
                    userDate(h) <- userdate(i);
                    userName(h) <- STRING[50](username(i));
                }
            }
            header(r) <- h();
            name(r) <- name(i);
            quantity(r) <- quantity(i);
            price(r) <- price(i);
        }
        APPLY; // FOR
    } // INPUT    
}

onImport2 ' ' () {
    LOCAL date, userdate = DATE(INTEGER);
    LOCAL number = STRING[10](INTEGER);
    LOCAL number2 = STRING();
    LOCAL shop, name, username = STRING[100](INTEGER);
    LOCAL quantity = NUMERIC[10,3](INTEGER);
    LOCAL price = NUMERIC[10,2](INTEGER);
    LOCAL h = HeaderExpenses();
    number2() <- '';
    INPUT dbfile = NAMEDFILE DO {
        IMPORT XLS HEADER FROM dbfile TO date = A, number = B, shop = C,
                name = D, quantity = E, price = F, username = G, userdate = H;
        FOR imported(INTEGER i) ORDER i DO NEW e = Expenses {
            IF number2() != number(i) THEN {
                number2() <- number(i);
                NEW h = HeaderExpenses {
                    h() <- h;
                    date(h) <- date(i);
                    number(h) <- number(i);
                    customer(h) <- GROUP MAX (Organization o) IF name(o) = shop(i);
                    userDate(h) <- userdate(i);
                    userName(h) <- STRING[50](username(i));
                }
            }    
            header(e) <- h();
            reception(e) <- GROUP MAX (Reception o) IF name(o) = name(i);
            quantity(e) <- quantity(i);
        }
        APPLY;
    }
}

EXTEND FORM viewExpenses PROPERTIES onImport1(), onImport2();