Liz::ProjectSet::Order - Order objects within the ProjectSet
use xxLINK; $xxlink = new xxLINK; $projectset = $xxlink->ProjectSet; $project = $projectset->Project( $projectID ); $order = $project->Order;
Provide object oriented access to the Order tables of the ProjectSet. The Liz::ProjectSet::Order object is in fact a Liz::Forum::Message object in disguise. See the documentation of that module for more information.
Create a new Order object from a ProjectSet object.
1 ProjectSet object 2 ID or name to create Order object with (default: none = new order) 3 projectID for which this order should be created
1 instantiated object
It is not intended to call this method directly, but rather indirectly through the Liz::ProjectSet module.
$xxlink = new xxLINK; $projectset = $xxlink->ProjectSet; $order = $projectset->Order; $order = $projectset->Order( $orderID,$projectID );
Update the Order object.
1 the ID of the Order object
$orderID = $order->update;
The following methods allow you to inspect and/or change certain fields of the Liz::ProjectSet::Order object.
Return the ClientID of the Order.
1 clientID of the project of the Order
$clientID = $order->ClientID;
Return the Created information of the Liz::ProjectSet::Order object.
1 current timestamp of the Created
$created = $order->Created;
Set or return the timestamp of the deadline of the Order.
1 new deadline of the Order (default: no change)
1 current/old deadline of the Order
$order->Deadline( $deadline ); $deadline = $order->Deadline;
Set or return the description of the Order.
1 new description of the Order (default: no change)
1 current/old description of the Order
$order->Description( $description ); $description = $order->Description;
Return or set the EmployeeIDs (list of contactID's from the EmployeeSet) of the Liz::ProjectSet::Order object.
1..N new employeeID's
(default: no change)
1..N current/old employeeID's
$client->EmployeeIDs( @employeeID ); @employeeID = $client->EmployeeIDs;
Set or return the foreign key of the Order. This is usually the offerID or the contract ID of the customer's system.
1 new foreign key of the Order (default: no change)
1 current/old foreign key of the Order
$order->ForeignKey( $foreignkey ); $foreignkey = $order->ForeignKey;
Set or return the history of the Order.
1 new history of the Order (default: no change)
1 current/old history of the Order
$order->History( $history ); $history = $order->History;
Return or set the InvoiceContactID of the Liz::ProjectSet::Order object.
1 new InvoiceContactID (default: no change)
1 current/old InvoiceContactID
$client->InvoiceContactID( $invoicecontactID ); $invoicecontactID = $client->InvoiceContactID;
Set or return the leaderID of the Order.
1 new leaderID of the Order (default: no change)
1 current/old leaderID of the Order
$order->LeaderID( $leaderID ); $leaderID = $order->LeaderID;
Set or return the name of the Order.
1 new name of the Order (default: no change)
1 current/old name of the Order
$order->Name( $name ); $name = $order->Name;
Return or set the OtherContactIDs (list of contactID's) of the Liz::ProjectSet::Order object.
1..N new othercontactID's
(default: no change)
1..N current/old othercontactID's
$client->OtherContactIDs( @othercontactID ); @othercontactID = $client->OtherContactIDs;
Return or set the projectID of the Order.
1 new projectID of the Order (default: no change)
1 current/old projectID of the Order
$order->ProjectID( $projectID ); $projectID = $order->ProjectID;
Return or set the SortName information of the Liz::ProjectSet::Order object.
1 new value of the SortName (default: no change)
1 current/old value of the SortName
$order->SortName( $sortname ); $sortname = $order->SortName;
Return or set the Status information of the Liz::ProjectSet::Status object.
1 new value of the Status (default: no change)
1 current/old value of the Status
$order->Status( 1 ); $status = $order->Status;
Return the Updated information of the Liz::ProjectSet::Order object.
1 current timestamp of the Updated
$updated = $order->Updated;
Specify or return the URL associated with the Liz::ProjectSet::Order object.
1 new value of the URL (default: no change)
1 previous/current version of the URL
$order->URL( $url ); $url = $order->URL;
Return the URLID of the Liz::ProjectSet::Order object. This is usually only used internally. It is better to use the more transparant method URL instead.
1 current urlID
$urlID = $project->URLID;
The following methods return an SQL-statement(-like) handle that allows listing of (a selection of) the objects of a certain type.
Return an SQL-statement(-like) handle that contains a selection of the Items available in the ProjectSet. The following field names can be specified with the first parameter:
ID The ID of the Item. Can be used as parameter on the L<Item> method.
description The description of the Item, e.g. 'Implementatie MailingList Functionaliteit'.
deadline Timestamp for the deadline of the Item
status The status of the Item: this can be any number between 0 and 255 inclusive.
orderedbyID The ID of the Contact/Employee information of the Item
updated Timestamp when the Item record was last updated in the database.
created Timestamp when the Item record was created in the database.
orderID The ID of the Order information of the Item. If non-zero, can be used to create an L<Order> object with.
contactID The ID of the Contact information of the Item. If non-zero, can be used to create an L<Contact> object with.
urlID The ID of the URL associated with the Item. If non-zero, can be used to create an L<URL> object with.
invoicetypeID The ID of the category that contains the type of invoicing to be performed.
worktypeID The ID of the category that contains the type of work to be done.
tariffID The ID of the category that contains the tariff to be used for invoicing.
1 fields to return for each Item, seperated by comma's (default: 'ID,description,deadline,status,orderedbyID,updated,created,orderID,contactID,urlID,invoicetypeID,worktypeID,tariffID' ); 2 extra SQL condition to apply (default: none) 3 order in which to return the finds (default: sortname) 4 which records should be returned (default: all )
1 SQL-like statement handle (on which method "fetchrow" can be applied)
$result = $projectset->Items; $result = $projectset->Items( 'ID,description,orderedbyID','status=0' );
Elizabeth Mattijsen ( lizperl@INC.nl )
(C) 1998-1999 International Network Consultants
Now, update sets the alteredbyID-field to the current user ID. Now inherits the PROJECTSET from the object.
Added stuff for alteredbyID-field.
Added OrganizationID to the allowed list.
Now no longer adds Exporter to ISA: it wasn't necessary.
First version of this true Perl module.