예제 #1
0
    }
    if (!is_date($_POST['due_date'])) {
        display_error(_("The required by date entered is in an invalid format."));
        set_focus('due_date');
        return false;
    }
    return true;
}
//-------------------------------------------------------------------------------------
if (isset($_POST['ADD_ITEM']) || isset($_POST['UPDATE_ITEM'])) {
    if (!isset($_POST['dimension_tags'])) {
        $_POST['dimension_tags'] = array();
    }
    if (can_process()) {
        if ($selected_id == -1) {
            $id = add_dimension($_POST['ref'], $_POST['name'], $_POST['type_'], $_POST['date_'], $_POST['due_date'], $_POST['memo_']);
            add_tag_associations($id, $_POST['dimension_tags']);
            meta_forward($_SERVER['PHP_SELF'], "AddedID={$id}");
        } else {
            update_dimension($selected_id, $_POST['name'], $_POST['type_'], $_POST['date_'], $_POST['due_date'], $_POST['memo_']);
            update_tag_associations(TAG_DIMENSION, $selected_id, $_POST['dimension_tags']);
            meta_forward($_SERVER['PHP_SELF'], "UpdatedID={$selected_id}");
        }
    }
}
//--------------------------------------------------------------------------------------
if (isset($_POST['delete'])) {
    $cancel_delete = false;
    // can't delete it there are productions or issues
    if (dimension_has_payments($selected_id) || dimension_has_deposits($selected_id)) {
        display_error(_("This dimension cannot be deleted because it has already been processed."));
예제 #2
0
     if (!$row) {
         add_item_code($code, $id, $description, $cat, $qty, $foreign);
     } else {
         update_item_code($row[0], $code, $id, $description, $cat, $qty, $foreign);
     }
     $k++;
 }
 if ($type == 'ITEM') {
     $dim = 0;
     if ($qty != '') {
         $dim = get_dimension_by_name($qty);
         if ($dim == -1) {
             $date = Today();
             $due = add_days($date, sys_prefs::default_dimension_required_by());
             $ref = references::get_next(systypes::dimension());
             $dim = add_dimension($ref, $qty, 1, $date, $due, "Added due to Item Import");
             $dim_n++;
         }
     }
     $sql = "SELECT stock_id FROM " . TB_PREF . "stock_master WHERE stock_id='{$id}'";
     $result = db_query($sql, "item could not be retrieved");
     $row = db_fetch_row($result);
     if (!$row) {
         $sql = "INSERT INTO " . TB_PREF . "stock_master (stock_id, description, long_description, category_id,\n\t\t\t\t\t    tax_type_id, units, mb_flag, sales_account, inventory_account, cogs_account,\n\t\t\t\t\t    adjustment_account, assembly_account, dimension_id, dimension2_id)\n\t\t\t\t\t    VALUES ('{$id}', " . db_escape($description) . ", '',\n\t\t\t\t\t    '{$cat}', {$_POST['tax_type_id']}, '{$units}', '{$mb_flag}',\n\t\t\t\t\t    '{$_POST['sales_account']}', '{$_POST['inventory_account']}', '{$_POST['cogs_account']}',\n\t\t\t\t\t    '{$_POST['adjustment_account']}', '{$_POST['assembly_account']}', {$dim}, 0)";
         db_query($sql, "The item could not be added");
         if ($mb_flag == "M" || $mb_flag == "B") {
             $sql = "INSERT INTO " . TB_PREF . "loc_stock (loc_code, stock_id) VALUES ('{$_POST['location']}', '{$id}')";
             db_query($sql, "The item locstock could not be added");
         }
         $i++;
     } else {