PHP cw_warehouse_check_avail_record Examples

Example #1

File: cw.warehouse.php Project: CartworksPlatform/cartworksplatform

function cw_warehouse_products_delete_amount($pwa_id)
{
    global $tables;
    $info = cw_query_first("select warehouse_customer_id, variant_id, product_id from {$tables['products_supplied_amount']} where pwa_id='{$pwa_id}'");
    db_query("delete from {$tables['products_supplied_amount']} where pwa_id='{$pwa_id}'");
    cw_warehouse_check_avail_record($info['warehouse_customer_id'], $info['product_id'], $info['variant']);
}

Example #2

File: cw.accounting.php Project: CartworksPlatform/cartworksplatform

function cw_accounting_create_initial_amount($warehouse_id, $product_id, $variant_id, $avail, $field = 'avail')
{
    global $tables;
    $pwa_id = cw_query_first_cell("select pwa_id from {$tables['products_supplied_amount']} where product_id='{$product_id}' and warehouse_customer_id='{$warehouse_id}' and variant_id='{$variant_id}' and is_init=1");
    if ($pwa_id) {
        db_query("update {$tables['products_supplied_amount']} set {$field}={$field}+{$avail} where pwa_id='{$pwa_id}'");
    } else {
        $record = array('is_auto_calc' => 0, 'product_id' => $product_id, 'warehouse_customer_id' => $warehouse_id, $field => $avail, 'variant_id' => $variant_id, 'date' => cw_core_get_time(), 'is_init' => 1, 'is_hide' => 1);
        # kornev, is_init - it's not display it in some area, but include this amount in calculations
        $pwa_id = cw_array2insert('products_supplied_amount', $record);
    }
    cw_warehouse_check_avail_record($warehouse_id, $product_id, $variant_id);
}