private function strVolSQLCommon()
{
//-----------------------------------------------------------------------
//
//-----------------------------------------------------------------------
global $glUserID;
$vol =& $this->volRecs[0];
if (is_null($vol->lAttributedTo)) {
$strAttrib = 'null';
} else {
$strAttrib = (int) $vol->lAttributedTo;
}
return '
vol_strTitle = ' . strPrepStr($vol->strTitle, 80) . ',
vol_strFName = ' . strPrepStr($vol->strFName, 80) . ',
vol_strMName = ' . strPrepStr($vol->strMName, 80) . ',
vol_strLName = ' . strPrepStr($vol->strLName, 80) . ',
vol_strPreferredName = ' . strPrepStr($vol->strPreferredName, 80) . ',
vol_strAddr1 = ' . strPrepStr($vol->strAddr1, 80) . ',
vol_strAddr2 = ' . strPrepStr($vol->strAddr2, 80) . ',
vol_strCity = ' . strPrepStr($vol->strCity, 80) . ',
vol_strState = ' . strPrepStr($vol->strState, 80) . ',
vol_strCountry = ' . strPrepStr($vol->strCountry, 80) . ',
vol_strZip = ' . strPrepStr($vol->strZip, 40) . ',
vol_strPhone = ' . strPrepStr($vol->strPhone, 40) . ',
vol_strCell = ' . strPrepStr($vol->strCell, 40) . ',
vol_strNotes = ' . strPrepStr($vol->strNotes) . ',
vol_strEmail = ' . strPrepStr($vol->strEmail, 120) . ",\n vol_lAttributedTo = {$strAttrib},\n\n vol_lLastUpdateID = {$glUserID},\n\n vol_dteBirthDate = " . strDBValueConvert_String($vol->dteMysqlBirthDate) . ' ';
}
private function strCommonFieldSQL()
{
//---------------------------------------------------------------------
//
//---------------------------------------------------------------------
global $glUserID;
$ufield =& $this->fields[0];
return '
pff_strFieldNameUser = '******',
pff_strFieldNotes = ' . strPrepStr($ufield->strFieldNotes) . ',
pff_bCheckDef = ' . strDBValueConvert_BOOL($ufield->pff_bCheckDef) . ',
pff_curDef = ' . strDBValueConvert_SNG($ufield->pff_curDef, 2) . ',
pff_strTxtDef = ' . strDBValueConvert_String($ufield->pff_strTxtDef) . ',
pff_lDef = ' . strDBValueConvert_INT($ufield->pff_lDef) . ",\n pff_lCurrencyACO = " . (int) $ufield->pff_lCurrencyACO . ",\n pff_bPrefilled = " . ($ufield->bPrefilled ? '1' : '0') . ",\n pff_bHidden = " . ($ufield->pff_bHidden ? '1' : '0') . ",\n pff_bRequired = " . ($ufield->pff_bRequired ? '1' : '0') . ",\n pff_lLastUpdateID = {$glUserID},\n pff_dteLastUpdate = NOW() ";
}
function sqlCommonTermAddEdit()
{
//---------------------------------------------------------------------
//
//---------------------------------------------------------------------
global $glUserID;
$term =& $this->terms[0];
$strOut = '
crs_bCompareBool = ' . strDBValueConvert_BOOL($term->bCompareBool) . ',
crs_lCompVal = ' . strDBValueConvert_INT($term->lCompVal) . ',
crs_curCompVal = ' . strDBValueConvert_SNG($term->curCompVal, 2) . ',
crs_strCompVal = ' . strDBValueConvert_String($term->strCompVal) . ',
crs_dteCompVal = ' . strDBValueConvert_String($term->mdteCompVal) . ",\n crs_lCompareOpt = {$term->lCompareOpt},\n crs_lSortIDX = {$term->lSortIDX},\n crs_lLastUpdateID = {$glUserID},\n crs_dteLastUpdate = NOW()\n ";
return $strOut;
}
private function strPeopleSQLCommon()
{
//-----------------------------------------------------------------------
//
//-----------------------------------------------------------------------
global $glUserID;
$people = $this->people[0];
if (is_null($people->lAttributedTo)) {
$strAttrib = 'null';
} else {
$strAttrib = (int) $people->lAttributedTo;
}
return '
pe_strTitle = ' . strPrepStr($people->strTitle, 80) . ',
pe_strFName = ' . strPrepStr($people->strFName, 80) . ',
pe_strMName = ' . strPrepStr($people->strMName, 80) . ',
pe_strLName = ' . strPrepStr($people->strLName, 80) . ',
pe_strPreferredName = ' . strPrepStr($people->strPreferredName, 80) . ',
pe_strSalutation = ' . strPrepStr($people->strSalutation, 80) . ',
pe_strAddr1 = ' . strPrepStr($people->strAddr1, 80) . ',
pe_strAddr2 = ' . strPrepStr($people->strAddr2, 80) . ',
pe_strCity = ' . strPrepStr($people->strCity, 80) . ',
pe_strState = ' . strPrepStr($people->strState, 80) . ',
pe_strCountry = ' . strPrepStr($people->strCountry, 80) . ',
pe_strZip = ' . strPrepStr($people->strZip, 40) . ',
pe_strPhone = ' . strPrepStr($people->strPhone, 40) . ',
pe_strCell = ' . strPrepStr($people->strCell, 40) . ',
pe_strNotes = ' . strPrepStr($people->strNotes) . ',
pe_strEmail = ' . strPrepStr($people->strEmail, 120) . ',
pe_enumGender = ' . strPrepStr($people->enumGender) . ',
pe_dteExpire = ' . strDBValueConvert_Date($people->dteExpire) . ",\n pe_lACO = {$people->lACO},\n pe_bBiz = 0,\n pe_lAttributedTo = {$strAttrib},\n\n pe_lLastUpdateID = {$glUserID},\n\n pe_dteBirthDate = " . strDBValueConvert_String($people->dteMysqlBirthDate) . ',
pe_dteDeathDate = ' . strDBValueConvert_String($people->dteMysqlDeath) . ' ';
}
