function assignmentworkflow($clientcompanypropertyid){
global $assignmentworkflow_instance;
$assignmentworkflow_instance++;
if($assignmentworkflow_instance == 1){
?>
}
?>
}
/**
* Returns the assignmentmethodid if there is a companyid, returns 0 if not
* @param int $clientcompanyid
*/
function internalonlyassignmentmethod($clientcompanyid)//assignmentmethodid
{
if (!$clientcompanyid)
{
developer_error("internalonlyassignmentmethod called with NO clientcompanyid: '".$clientcompanyid."'");
return 0;
}
$sql = "
select assignmentmethodid
from tblassignmentmethod
where assignmentmethodinternalonlydate is not null
and assignmentmethodname = 'Internal Only'
and clientcompanyid = ".db_number($clientcompanyid);
$id = db_firstval($sql);
if (!$id)
{
$id = db_nextid('assignmentmethod');
$sql = "
insert into tblassignmentmethod
(
assignmentmethodid
, assignmentmethodname
, clientcompanyid
, assignmentmethodcreateddate
, assignmentmethodcreatedby
, externalusertypeid
, assignmentinternaldate
, assignmentinternalby
, assignmentmethodinternalonlydate
)
values
(
$id
, 'Internal Only'
, ".db_number($clientcompanyid)."
, now()
, ".loginid()."
, -1
, now()
, ".loginid()."
, now()
) ";
db_exec($sql);
}
return $id;
}
?>