コード例 #1
0
 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;
 }
コード例 #2
0
 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() ";
 }