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) . ' '; }