Demo 4
Classes | Functions | Variables
d4_orders.4gl File Reference

Classes

Record  c
 Generating order invoice report. More...
 
Record  x
 

Functions

function orders ()
 The menu for working with orders is implemented in the orders function. More...
 
function add_order ()
 The ability to add new order for a particular client is implemented in the add_order function. More...
 
function update_order ()
 update_order function is not implemented. More...
 
function delete_order ()
 The option to delete a client order is implemented in the delete_order function. More...
 
function order_total ()
 The order_total function displays the value of 'Total including Tax and Shipping Charges' to a t_price field. More...
 
function item_total ()
 The item_total function displays the "Total" value for every element to the total_price field. More...
 
function renum_items ()
 The return_items function displays the order element sequence number to the item_num field. More...
 
function insert_items ()
 The insert_items function writes order details (item_num,order_num,stock_num,manu_code,quantity,total_price) to the 'items' table. More...
 
function get_stock ()
 The get_stock function displays the list of possible values with the possibility of choice. More...
 
function get_order ()
 The possibility to look at the orders of a client is implemented in the get_order function. More...
 
function get_item ()
 The get_item function displays order details to the corresponding form fields. More...
 
function invoice (file_name)
 The invoice function forms the invoice of an order. More...
 

Variables

Record { ... }  x
 

Function Documentation

function d4_orders::orders ( )

The menu for working with orders is implemented in the orders function.

Returns
No value

dot_d4_orders_F_orders.png

function d4_orders::order_total ( )

The order_total function displays the value of 'Total including Tax and Shipping Charges' to a t_price field.

Returns
No value

dot_d4_orders_F_order_total.png

function d4_orders::delete_order ( )

The option to delete a client order is implemented in the delete_order function.

After confirmation, the order is deleted from tables 'orders' and 'items'.

Returns
No value

dot_d4_orders_F_delete_order.png

function d4_orders::add_order ( )

The ability to add new order for a particular client is implemented in the add_order function.

After the client is found and selected the order for the client can be added. Order data is entered in the order form (order_date,po_num,ship_instruct), then detailed data (stock_num,manu_code,quantity). Entered order data is saved in the 'orders' and 'items' tables.

Returns
No value

dot_d4_orders_F_add_order.png

function d4_orders::item_total ( )

The item_total function displays the "Total" value for every element to the total_price field.

Returns
No value

dot_d4_orders_F_item_total.png

function d4_orders::update_order ( )

update_order function is not implemented.

Returns
No value

dot_d4_orders_F_update_order.png

function d4_orders::renum_items ( )

The return_items function displays the order element sequence number to the item_num field.

Returns
No value

dot_d4_orders_F_renum_items.png

function d4_orders::insert_items ( )

The insert_items function writes order details (item_num,order_num,stock_num,manu_code,quantity,total_price) to the 'items' table.

Returns
TRUE if INSERT was successful or FALSE if error occurred.

dot_d4_orders_F_insert_items.png

function d4_orders::get_stock ( )

The get_stock function displays the list of possible values with the possibility of choice.

Returns
stock_num, manu_code, description and unit_price of selected item

dot_d4_orders_F_get_stock.png

function d4_orders::get_order ( )

The possibility to look at the orders of a client is implemented in the get_order function.

Returns
No value

dot_d4_orders_F_get_order.png

function d4_orders::get_item ( )

The get_item function displays order details to the corresponding form fields.

Returns
No value

dot_d4_orders_F_get_item.png

function d4_orders::invoice (   file_name)

The invoice function forms the invoice of an order.

Depending on the variable of the print_option value, invoice can be sent to file "f", for printing "p" or to the screen "s". In the d4_main module print_option = "s" (by default - screen output)

Parameters
file_nameCHAR(20) report filename
Returns
No value

dot_d4_orders_F_invoice.png

Variable Documentation

Record { ... } x