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 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() "; }