Пример #1
0
 function people_biz_search($strSearch, $lLimit = 30)
 {
     //---------------------------------------------------------------------
     //
     //---------------------------------------------------------------------
     $lLen = strlen($strSearch);
     $sqlStr = 'SELECT pe_strLName, pe_strFName, pe_bBiz, pe_lKeyID, pe_strAddr1
       FROM people_names
       WHERE NOT pe_bRetired
          AND LEFT(pe_strLName, ' . $lLen . ')=' . strPrepStr($strSearch) . "\n          ORDER BY pe_strLName, pe_strFName, pe_lKeyID\n          LIMIT 0, {$lLimit};";
     $query = $this->db->query($sqlStr);
     $this->lNumRows = $query->num_rows();
     if ($this->lNumRows > 0) {
         $idx = 0;
         $this->results = array();
         foreach ($query->result() as $row) {
             $this->results[$idx] = new stdClass();
             $r =& $this->results[$idx];
             $r->lKeyID = $row->pe_lKeyID;
             $r->strFName = $row->pe_strFName;
             $r->strLName = $row->pe_strLName;
             $r->bBiz = $row->pe_bBiz;
             $r->strAddr1 = $row->pe_strAddr1;
             if ($r->bBiz) {
                 $r->strSafeName = htmlspecialchars($r->strLName) . ' (business)';
             } else {
                 $r->strSafeName = htmlspecialchars($r->strLName . ', ' . $r->strFName);
             }
             ++$idx;
         }
     }
 }
 function lSaveObject(&$theObject)
 {
     $prepedObject = strPrepStr(serialize($theObject));
     $sqlStr = "INSERT INTO serial_objects SET so_object= {$prepedObject};";
     $this->db->query($sqlStr);
     return $this->db->insert_id();
 }
function upgrade_addTimeZoneTables()
{
    //---------------------------------------------------------------------
    //
    //---------------------------------------------------------------------
    $CI =& get_instance();
    /*
    $zzzlPos = strrpos(__FILE__, '\\'); $zzzlLen=strlen(__FILE__); echo('<font class="debug">'.substr(__FILE__, strrpos(__FILE__, '\\',-(($zzzlLen-$zzzlPos)+1))) .': '.__LINE__
    .":\$CI->config->item('dl_timezone') = ".$CI->config->item('dl_timezone')."<br></font>\n");
    die;
    */
    $sqlStr = "DROP TABLE IF EXISTS lists_tz;";
    $CI->db->query($sqlStr);
    $sqlStr = "CREATE TABLE IF NOT EXISTS lists_tz (\n           tz_lKeyID      int(11) NOT NULL AUTO_INCREMENT,\n           tz_strTimeZone varchar(120) NOT NULL DEFAULT '',\n           tz_lTZ_Const   int(11) NOT NULL,\n           tz_bTopList    tinyint(1) NOT NULL DEFAULT '0' ,\n           PRIMARY KEY (tz_lKeyID),\n           KEY tz_strTimeZone (tz_strTimeZone)\n\n         ) ENGINE=MyISAM  DEFAULT CHARSET=latin1\n         COMMENT='php time zone constants via http://pecl.php.net/get/timezonedb'\n         AUTO_INCREMENT=1;";
    $CI->db->query($sqlStr);
    $sqlStr = "INSERT INTO lists_tz (tz_strTimeZone, tz_lTZ_Const, tz_bTopList) VALUES\n   ('US/Eastern'         , 0x03E4DA , 1),    ('US/Central'         , 0x03DFCF , 1),    ('US/Mountain'        , 0x03F35C , 1),\n   ('US/Pacific'         , 0x03F6D5 , 1),    ('US/Alaska'          , 0x03D872 , 1),    ('US/Hawaii'          , 0x03EC43 , 1),\n\n\t('Canada/Atlantic'                   , 0x02617D , 1),\t('Canada/Central'                    , 0x026665 , 1),\n\t('Canada/East-Saskatchewan'          , 0x026F6F , 1),\t('Canada/Eastern'                    , 0x026A7F , 1),\n\t('Canada/Mountain'                   , 0x0270F8 , 1),\t('Canada/Newfoundland'               , 0x02746E , 1),\n\t('Canada/Pacific'                    , 0x027999 , 1),\t('Canada/Saskatchewan'               , 0x027DB2 , 1),\n\t('Canada/Yukon'                      , 0x027F3B , 1),\n\n\t( 'Africa/Abidjan'                    , 0x000000 , 0),\t( 'Africa/Accra'                      , 0x000055 , 0),\t( 'Africa/Addis_Ababa'                , 0x00019D , 0),\t( 'Africa/Algiers'                    , 0x00021C , 0),\n\t( 'Africa/Asmara'                     , 0x000347 , 0),\t( 'Africa/Asmera'                     , 0x0003C6 , 0),\t( 'Africa/Bamako'                     , 0x000445 , 0),\t( 'Africa/Bangui'                     , 0x00049A , 0),\n\t( 'Africa/Banjul'                     , 0x0004EF , 0),\t( 'Africa/Bissau'                     , 0x000544 , 0),\t( 'Africa/Blantyre'                   , 0x0005AA , 0),\t( 'Africa/Brazzaville'                , 0x0005FF , 0),\n\t( 'Africa/Bujumbura'                  , 0x000654 , 0),\t( 'Africa/Cairo'                      , 0x0006A9 , 0),\t( 'Africa/Casablanca'                 , 0x000A90 , 0),\t( 'Africa/Ceuta'                      , 0x000CF2 , 0),\n\t( 'Africa/Conakry'                    , 0x000FF9 , 0),\t( 'Africa/Dakar'                      , 0x00104E , 0),\t( 'Africa/Dar_es_Salaam'              , 0x0010A3 , 0),\t( 'Africa/Djibouti'                   , 0x001122 , 0),\n\t( 'Africa/Douala'                     , 0x0011A1 , 0),\t( 'Africa/El_Aaiun'                   , 0x0011F6 , 0),\t( 'Africa/Freetown'                   , 0x001421 , 0),\t( 'Africa/Gaborone'                   , 0x001476 , 0),\n\t( 'Africa/Harare'                     , 0x0014CB , 0),\t( 'Africa/Johannesburg'               , 0x001520 , 0),\t( 'Africa/Juba'                       , 0x00158E , 0),\t( 'Africa/Kampala'                    , 0x0016A1 , 0),\n\t( 'Africa/Khartoum'                   , 0x001720 , 0),\t( 'Africa/Kigali'                     , 0x001833 , 0),\t( 'Africa/Kinshasa'                   , 0x001888 , 0),\t( 'Africa/Lagos'                      , 0x0018F4 , 0),\n\t( 'Africa/Libreville'                 , 0x001949 , 0),\t( 'Africa/Lome'                       , 0x00199E , 0),\t( 'Africa/Luanda'                     , 0x0019F3 , 0),\t( 'Africa/Lubumbashi'                 , 0x001A48 , 0),\n\t( 'Africa/Lusaka'                     , 0x001AB4 , 0),\t( 'Africa/Malabo'                     , 0x001B09 , 0),\t( 'Africa/Maputo'                     , 0x001B5E , 0),\t( 'Africa/Maseru'                     , 0x001BB3 , 0),\n\t( 'Africa/Mbabane'                    , 0x001C21 , 0),\t( 'Africa/Mogadishu'                  , 0x001C8F , 0),\t( 'Africa/Monrovia'                   , 0x001D0E , 0),\t( 'Africa/Nairobi'                    , 0x001D74 , 0),\n\t( 'Africa/Ndjamena'                   , 0x001DF3 , 0),\t( 'Africa/Niamey'                     , 0x001E5F , 0),\t( 'Africa/Nouakchott'                 , 0x001EB4 , 0),\t( 'Africa/Ouagadougou'                , 0x001F09 , 0),\n\t( 'Africa/Porto-Novo'                 , 0x001F5E , 0),\t( 'Africa/Sao_Tome'                   , 0x001FB3 , 0),\t( 'Africa/Timbuktu'                   , 0x002008 , 0),\t( 'Africa/Tripoli'                    , 0x00205D , 0),\n\t( 'Africa/Tunis'                      , 0x002166 , 0),\t( 'Africa/Windhoek'                   , 0x002278 , 0),\t( 'America/Adak'                      , 0x0024BF , 0),\t( 'America/Anchorage'                 , 0x002835 , 0),\n\t( 'America/Anguilla'                  , 0x002BA9 , 0),\t( 'America/Antigua'                   , 0x002BFE , 0),\t( 'America/Araguaina'                 , 0x002C53 , 0),\t( 'America/Argentina/Buenos_Aires'    , 0x002DB8 , 0),\n\t( 'America/Argentina/Catamarca'       , 0x002F66 , 0),\t( 'America/Argentina/ComodRivadavia'  , 0x003127 , 0),\t( 'America/Argentina/Cordoba'         , 0x0032CD , 0),\t( 'America/Argentina/Jujuy'           , 0x0034A2 , 0),\n\t( 'America/Argentina/La_Rioja'        , 0x003656 , 0),\t( 'America/Argentina/Mendoza'         , 0x00380E , 0),\t( 'America/Argentina/Rio_Gallegos'    , 0x0039CE , 0),\t( 'America/Argentina/Salta'           , 0x003B83 , 0),\n\t( 'America/Argentina/San_Juan'        , 0x003D2F , 0),\t( 'America/Argentina/San_Luis'        , 0x003EE7 , 0),\t( 'America/Argentina/Tucuman'         , 0x0040AD , 0),\t( 'America/Argentina/Ushuaia'         , 0x004269 , 0),\n\t( 'America/Aruba'                     , 0x004424 , 0),\t( 'America/Asuncion'                  , 0x00448A , 0),\t( 'America/Atikokan'                  , 0x00476F , 0),\t( 'America/Atka'                      , 0x004845 , 0),\n\t( 'America/Bahia'                     , 0x004BAB , 0),\t( 'America/Bahia_Banderas'            , 0x004D3E , 0),\t( 'America/Barbados'                  , 0x004FB7 , 0),\t( 'America/Belem'                     , 0x005051 , 0),\n\t( 'America/Belize'                    , 0x00514C , 0),\t( 'America/Blanc-Sablon'              , 0x0052C8 , 0),\t( 'America/Boa_Vista'                 , 0x00537C , 0),\t( 'America/Bogota'                    , 0x005485 , 0),\n\t( 'America/Boise'                     , 0x0054F1 , 0),\t( 'America/Buenos_Aires'              , 0x005888 , 0),\t( 'America/Cambridge_Bay'             , 0x005A21 , 0),\t( 'America/Campo_Grande'              , 0x005D49 , 0),\n\t( 'America/Cancun'                    , 0x006038 , 0),\t( 'America/Caracas'                   , 0x0061A2 , 0),\t( 'America/Catamarca'                 , 0x006209 , 0),\t( 'America/Cayenne'                   , 0x0063AF , 0),\n\t( 'America/Cayman'                    , 0x006411 , 0),\t( 'America/Chicago'                   , 0x006466 , 0),\t( 'America/Chihuahua'                 , 0x00697D , 0),\t( 'America/Coral_Harbour'             , 0x006BE8 , 0),\n\t( 'America/Cordoba'                   , 0x006C7A , 0),\t( 'America/Costa_Rica'                , 0x006E20 , 0),\t( 'America/Creston'                   , 0x006EAA , 0),\t( 'America/Cuiaba'                    , 0x006F36 , 0),\n\t( 'America/Curacao'                   , 0x007214 , 0),\t( 'America/Danmarkshavn'              , 0x00727A , 0),\t( 'America/Dawson'                    , 0x0073BE , 0),\t( 'America/Dawson_Creek'              , 0x0076DB , 0),\n\t( 'America/Denver'                    , 0x0078B5 , 0),\t( 'America/Detroit'                   , 0x007C3B , 0),\t( 'America/Dominica'                  , 0x007F9A , 0),\t( 'America/Edmonton'                  , 0x007FEF , 0),\n\t( 'America/Eirunepe'                  , 0x0083A7 , 0),\t( 'America/El_Salvador'               , 0x0084BF , 0),\t( 'America/Ensenada'                  , 0x008534 , 0),\t( 'America/Fort_Wayne'                , 0x0089DB , 0),\n\t( 'America/Fortaleza'                 , 0x00889D , 0),\t( 'America/Glace_Bay'                 , 0x008C45 , 0),\t( 'America/Godthab'                   , 0x008FBC , 0),\t( 'America/Goose_Bay'                 , 0x009280 , 0),\n\t( 'America/Grand_Turk'                , 0x00973D , 0),\t( 'America/Grenada'                   , 0x00991C , 0),\t( 'America/Guadeloupe'                , 0x009971 , 0),\t( 'America/Guatemala'                 , 0x0099C6 , 0),\n\t( 'America/Guayaquil'                 , 0x009A4F , 0),\t( 'America/Guyana'                    , 0x009AAC , 0),\t( 'America/Halifax'                   , 0x009B2D , 0),\t( 'America/Havana'                    , 0x00A043 , 0),\n\t( 'America/Hermosillo'                , 0x00A3B6 , 0),\t( 'America/Indiana/Indianapolis'      , 0x00A494 , 0),\t( 'America/Indiana/Knox'              , 0x00A725 , 0),\t( 'America/Indiana/Marengo'           , 0x00AABC , 0),\n\t( 'America/Indiana/Petersburg'        , 0x00AD62 , 0),\t( 'America/Indiana/Tell_City'         , 0x00B2AF , 0),\t( 'America/Indiana/Vevay'             , 0x00B548 , 0),\t( 'America/Indiana/Vincennes'         , 0x00B783 , 0),\n\t( 'America/Indiana/Winamac'           , 0x00BA37 , 0),\t( 'America/Indianapolis'              , 0x00B045 , 0),\t( 'America/Inuvik'                    , 0x00BCF0 , 0),\t( 'America/Iqaluit'                   , 0x00BFE7 , 0),\n\t( 'America/Jamaica'                   , 0x00C309 , 0),\t( 'America/Jujuy'                     , 0x00C3CE , 0),\t( 'America/Juneau'                    , 0x00C578 , 0),\t( 'America/Kentucky/Louisville'       , 0x00C8F6 , 0),\n\t( 'America/Kentucky/Monticello'       , 0x00CD14 , 0),\t( 'America/Knox_IN'                   , 0x00D099 , 0),\t( 'America/Kralendijk'                , 0x00D40A , 0),\t( 'America/La_Paz'                    , 0x00D470 , 0),\n\t( 'America/Lima'                      , 0x00D4D7 , 0),\t( 'America/Los_Angeles'               , 0x00D57F , 0),\t( 'America/Louisville'                , 0x00D990 , 0),\t( 'America/Lower_Princes'             , 0x00DD85 , 0),\n\t( 'America/Maceio'                    , 0x00DDEB , 0),\t( 'America/Managua'                   , 0x00DF25 , 0),\t( 'America/Manaus'                    , 0x00DFD8 , 0),\t( 'America/Marigot'                   , 0x00E0DA , 0),\n\t( 'America/Martinique'                , 0x00E12F , 0),\t( 'America/Matamoros'                 , 0x00E19B , 0),\t( 'America/Mazatlan'                  , 0x00E3F4 , 0),\t( 'America/Mendoza'                   , 0x00E661 , 0),\n\t( 'America/Menominee'                 , 0x00E815 , 0),\t( 'America/Merida'                    , 0x00EB96 , 0),\t( 'America/Metlakatla'                , 0x00EDD1 , 0),\t( 'America/Mexico_City'               , 0x00EF0C , 0),\n\t( 'America/Miquelon'                  , 0x00F187 , 0),\t( 'America/Moncton'                   , 0x00F3F9 , 0),\t( 'America/Monterrey'                 , 0x00F890 , 0),\t( 'America/Montevideo'                , 0x00FAF3 , 0),\n\t( 'America/Montreal'                  , 0x00FE05 , 0),\t( 'America/Montserrat'                , 0x0102F5 , 0),\t( 'America/Nassau'                    , 0x01034A , 0),\t( 'America/New_York'                  , 0x01068F , 0),\n\t( 'America/Nipigon'                   , 0x010B9A , 0),\t( 'America/Nome'                      , 0x010EEB , 0),\t( 'America/Noronha'                   , 0x011269 , 0),\t( 'America/North_Dakota/Beulah'       , 0x011399 , 0),\n\t( 'America/North_Dakota/Center'       , 0x01172D , 0),\t( 'America/North_Dakota/New_Salem'    , 0x011AC1 , 0),\t( 'America/Ojinaga'                   , 0x011E6A , 0),\t( 'America/Panama'                    , 0x0120CB , 0),\n\t( 'America/Pangnirtung'               , 0x012120 , 0),\t( 'America/Paramaribo'                , 0x012456 , 0),\t( 'America/Phoenix'                   , 0x0124E8 , 0),\t( 'America/Port-au-Prince'            , 0x0125A6 , 0),\n\t( 'America/Port_of_Spain'             , 0x0128CA , 0),\t( 'America/Porto_Acre'                , 0x0127C6 , 0),\t( 'America/Porto_Velho'               , 0x01291F , 0),\t( 'America/Puerto_Rico'               , 0x012A15 , 0),\n\t( 'America/Rainy_River'               , 0x012A80 , 0),\t( 'America/Rankin_Inlet'              , 0x012DB8 , 0),\t( 'America/Recife'                    , 0x01309E , 0),\t( 'America/Regina'                    , 0x0131C8 , 0),\n\t( 'America/Resolute'                  , 0x013386 , 0),\t( 'America/Rio_Branco'                , 0x01366E , 0),\t( 'America/Rosario'                   , 0x013776 , 0),\t( 'America/Santa_Isabel'              , 0x01391C , 0),\n\t( 'America/Santarem'                  , 0x013CBF , 0),\t( 'America/Santiago'                  , 0x013DC4 , 0),\t( 'America/Santo_Domingo'             , 0x014094 , 0),\t( 'America/Sao_Paulo'                 , 0x01415A , 0),\n\t( 'America/Scoresbysund'              , 0x014469 , 0),\t( 'America/Shiprock'                  , 0x014757 , 0),\t( 'America/Sitka'                     , 0x014AD0 , 0),\t( 'America/St_Barthelemy'             , 0x014E58 , 0),\n\t( 'America/St_Johns'                  , 0x014EAD , 0),\t( 'America/St_Kitts'                  , 0x015400 , 0),\t( 'America/St_Lucia'                  , 0x015455 , 0),\t( 'America/St_Thomas'                 , 0x0154AA , 0),\n\t( 'America/St_Vincent'                , 0x0154FF , 0),\t( 'America/Swift_Current'             , 0x015554 , 0),\t( 'America/Tegucigalpa'               , 0x015675 , 0),\t( 'America/Thule'                     , 0x0156F4 , 0),\n\t( 'America/Thunder_Bay'               , 0x01593B , 0),\t( 'America/Tijuana'                   , 0x015C84 , 0),\t( 'America/Toronto'                   , 0x01601D , 0),\t( 'America/Tortola'                   , 0x01653D , 0),\n\t( 'America/Vancouver'                 , 0x016592 , 0),\t( 'America/Virgin'                    , 0x0169CF , 0),\t( 'America/Whitehorse'                , 0x016A24 , 0),\t( 'America/Winnipeg'                  , 0x016D41 , 0),\n\t( 'America/Yakutat'                   , 0x017181 , 0),\t( 'America/Yellowknife'               , 0x0174EC , 0),\t( 'Antarctica/Casey'                  , 0x0177FC , 0),\t( 'Antarctica/Davis'                  , 0x01789A , 0),\n\t( 'Antarctica/DumontDUrville'         , 0x01793B , 0),\t( 'Antarctica/Macquarie'              , 0x0179CC , 0),\t( 'Antarctica/Mawson'                 , 0x017C19 , 0),\t( 'Antarctica/McMurdo'                , 0x017C95 , 0),\n\t( 'Antarctica/Palmer'                 , 0x018040 , 0),\t( 'Antarctica/Rothera'                , 0x018283 , 0),\t( 'Antarctica/South_Pole'             , 0x0182F9 , 0),\t( 'Antarctica/Syowa'                  , 0x018677 , 0),\n\t( 'Antarctica/Troll'                  , 0x0186E5 , 0),\t( 'Antarctica/Vostok'                 , 0x0188B7 , 0),\t( 'Arctic/Longyearbyen'               , 0x018928 , 0),\t( 'Asia/Aden'                         , 0x018C5A , 0),\n\t( 'Asia/Almaty'                       , 0x018CAF , 0),\t( 'Asia/Amman'                        , 0x018E2E , 0),\t( 'Asia/Anadyr'                       , 0x0190E4 , 0),\t( 'Asia/Aqtau'                        , 0x0192E6 , 0),\n\t( 'Asia/Aqtobe'                       , 0x0194E5 , 0),\t( 'Asia/Ashgabat'                     , 0x01969D , 0),\t( 'Asia/Ashkhabad'                    , 0x0197BA , 0),\t( 'Asia/Baghdad'                      , 0x0198D7 , 0),\n\t( 'Asia/Bahrain'                      , 0x019A4C , 0),\t( 'Asia/Baku'                         , 0x019AB2 , 0),\t( 'Asia/Bangkok'                      , 0x019D9A , 0),\t( 'Asia/Beirut'                       , 0x019DEF , 0),\n\t( 'Asia/Bishkek'                      , 0x01A0FC , 0),\t( 'Asia/Brunei'                       , 0x01A2A8 , 0),\t( 'Asia/Calcutta'                     , 0x01A30A , 0),\t( 'Asia/Chita'                        , 0x01A383 , 0),\n\t( 'Asia/Choibalsan'                   , 0x01A598 , 0),\t( 'Asia/Chongqing'                    , 0x01A7FF , 0),\t( 'Asia/Chungking'                    , 0x01A89F , 0),\t( 'Asia/Colombo'                      , 0x01A93F , 0),\n\t( 'Asia/Dacca'                        , 0x01A9DB , 0),\t( 'Asia/Damascus'                     , 0x01AA81 , 0),\t( 'Asia/Dhaka'                        , 0x01ADD1 , 0),\t( 'Asia/Dili'                         , 0x01AE77 , 0),\n\t( 'Asia/Dubai'                        , 0x01AF01 , 0),\t( 'Asia/Dushanbe'                     , 0x01AF56 , 0),\t( 'Asia/Gaza'                         , 0x01B059 , 0),\t( 'Asia/Harbin'                       , 0x01B3AC , 0),\n\t( 'Asia/Hebron'                       , 0x01B44C , 0),\t( 'Asia/Ho_Chi_Minh'                  , 0x01B7A8 , 0),\t( 'Asia/Hong_Kong'                    , 0x01B84A , 0),\t( 'Asia/Hovd'                         , 0x01BA0C , 0),\n\t( 'Asia/Irkutsk'                      , 0x01BC6A , 0),\t( 'Asia/Istanbul'                     , 0x01BE55 , 0),\t( 'Asia/Jakarta'                      , 0x01C242 , 0),\t( 'Asia/Jayapura'                     , 0x01C2EC , 0),\n\t( 'Asia/Jerusalem'                    , 0x01C389 , 0),\t( 'Asia/Kabul'                        , 0x01C6B8 , 0),\t( 'Asia/Kamchatka'                    , 0x01C709 , 0),\t( 'Asia/Karachi'                      , 0x01C902 , 0),\n\t( 'Asia/Kashgar'                      , 0x01C9B7 , 0),\t( 'Asia/Kathmandu'                    , 0x01CA0C , 0),\t( 'Asia/Katmandu'                     , 0x01CA72 , 0),\t( 'Asia/Khandyga'                     , 0x01CAD8 , 0),\n\t( 'Asia/Kolkata'                      , 0x01CD02 , 0),\t( 'Asia/Krasnoyarsk'                  , 0x01CD7B , 0),\t( 'Asia/Kuala_Lumpur'                 , 0x01CF68 , 0),\t( 'Asia/Kuching'                      , 0x01D025 , 0),\n\t( 'Asia/Kuwait'                       , 0x01D113 , 0),\t( 'Asia/Macao'                        , 0x01D168 , 0),\t( 'Asia/Macau'                        , 0x01D2A3 , 0),\t( 'Asia/Magadan'                      , 0x01D3DE , 0),\n\t( 'Asia/Makassar'                     , 0x01D5E2 , 0),\t( 'Asia/Manila'                       , 0x01D6A7 , 0),\t( 'Asia/Muscat'                       , 0x01D72C , 0),\t( 'Asia/Nicosia'                      , 0x01D781 , 0),\n\t( 'Asia/Novokuznetsk'                 , 0x01DA69 , 0),\t( 'Asia/Novosibirsk'                  , 0x01DC89 , 0),\t( 'Asia/Omsk'                         , 0x01DE79 , 0),\t( 'Asia/Oral'                         , 0x01E065 , 0),\n\t( 'Asia/Phnom_Penh'                   , 0x01E235 , 0),\t( 'Asia/Pontianak'                    , 0x01E28A , 0),\t( 'Asia/Pyongyang'                    , 0x01E34C , 0),\t( 'Asia/Qatar'                        , 0x01E3D1 , 0),\n\t( 'Asia/Qyzylorda'                    , 0x01E437 , 0),\t( 'Asia/Rangoon'                      , 0x01E60D , 0),\t( 'Asia/Riyadh'                       , 0x01E685 , 0),\t( 'Asia/Saigon'                       , 0x01E6DA , 0),\n\t( 'Asia/Sakhalin'                     , 0x01E77C , 0),\t( 'Asia/Samarkand'                    , 0x01E979 , 0),\t( 'Asia/Seoul'                        , 0x01EAAF , 0),\t( 'Asia/Shanghai'                     , 0x01EBA2 , 0),\n\t( 'Asia/Singapore'                    , 0x01EC4E , 0),\t( 'Asia/Srednekolymsk'                , 0x01ED05 , 0),\t( 'Asia/Taipei'                       , 0x01EF05 , 0),\t( 'Asia/Tashkent'                     , 0x01F036 , 0),\n\t( 'Asia/Tbilisi'                      , 0x01F167 , 0),\t( 'Asia/Tehran'                       , 0x01F321 , 0),\t( 'Asia/Tel_Aviv'                     , 0x01F58F , 0),\t( 'Asia/Thimbu'                       , 0x01F8BE , 0),\n\t( 'Asia/Thimphu'                      , 0x01F924 , 0),\t( 'Asia/Tokyo'                        , 0x01F98A , 0),\t( 'Asia/Ujung_Pandang'                , 0x01FA14 , 0),\t( 'Asia/Ulaanbaatar'                  , 0x01FA91 , 0),\n\t( 'Asia/Ulan_Bator'                   , 0x01FCD2 , 0),\t( 'Asia/Urumqi'                       , 0x01FF05 , 0),\t( 'Asia/Ust-Nera'                     , 0x01FF67 , 0),\t( 'Asia/Vientiane'                    , 0x020179 , 0),\n\t( 'Asia/Vladivostok'                  , 0x0201CE , 0),\t( 'Asia/Yakutsk'                      , 0x0203B8 , 0),\t( 'Asia/Yekaterinburg'                , 0x0205A2 , 0),\t( 'Asia/Yerevan'                      , 0x0207C3 , 0),\n\t( 'Atlantic/Azores'                   , 0x0209C3 , 0),\t( 'Atlantic/Bermuda'                  , 0x020EC6 , 0),\t( 'Atlantic/Canary'                   , 0x0211A7 , 0),\t( 'Atlantic/Cape_Verde'               , 0x02147D , 0),\n\t( 'Atlantic/Faeroe'                   , 0x0214F6 , 0),\t( 'Atlantic/Faroe'                    , 0x02179A , 0),\t( 'Atlantic/Jan_Mayen'                , 0x021A3E , 0),\t( 'Atlantic/Madeira'                  , 0x021D70 , 0),\n\t( 'Atlantic/Reykjavik'                , 0x022279 , 0),\t( 'Atlantic/South_Georgia'            , 0x022446 , 0),\t( 'Atlantic/St_Helena'                , 0x022658 , 0),\t( 'Atlantic/Stanley'                  , 0x02248A , 0),\n\t( 'Australia/ACT'                     , 0x0226AD , 0),\t( 'Australia/Adelaide'                , 0x0229D0 , 0),\t( 'Australia/Brisbane'                , 0x022D02 , 0),\t( 'Australia/Broken_Hill'             , 0x022DCF , 0),\n\t( 'Australia/Canberra'                , 0x023113 , 0),\t( 'Australia/Currie'                  , 0x023436 , 0),\t( 'Australia/Darwin'                  , 0x02376F , 0),\t( 'Australia/Eucla'                   , 0x0237FB , 0),\n\t( 'Australia/Hobart'                  , 0x0238D7 , 0),\t( 'Australia/LHI'                     , 0x023C3B , 0),\t( 'Australia/Lindeman'                , 0x023EDC , 0),\t( 'Australia/Lord_Howe'               , 0x023FC3 , 0),\n\t( 'Australia/Melbourne'               , 0x024274 , 0),\t( 'Australia/North'                   , 0x02459F , 0),\t( 'Australia/NSW'                     , 0x024619 , 0),\t( 'Australia/Perth'                   , 0x02493C , 0),\n\t( 'Australia/Queensland'              , 0x024A1A , 0),\t( 'Australia/South'                   , 0x024ACC , 0),\t( 'Australia/Sydney'                  , 0x024DEF , 0),\t( 'Australia/Tasmania'                , 0x025132 , 0),\n\t( 'Australia/Victoria'                , 0x02547D , 0),\t( 'Australia/West'                    , 0x0257A0 , 0),\t( 'Australia/Yancowinna'              , 0x02585C , 0),\t( 'Brazil/Acre'                       , 0x025B84 , 0),\n\t( 'Brazil/DeNoronha'                  , 0x025C88 , 0),\t( 'Brazil/East'                       , 0x025DA8 , 0),\t( 'Brazil/West'                       , 0x026085 , 0),\t( 'Canada/Atlantic'                   , 0x02617D , 0),\n\t( 'Canada/Central'                    , 0x026665 , 0),\t( 'Canada/East-Saskatchewan'          , 0x026F6F , 0),\t( 'Canada/Eastern'                    , 0x026A7F , 0),\t( 'Canada/Mountain'                   , 0x0270F8 , 0),\n\t( 'Canada/Newfoundland'               , 0x02746E , 0),\t( 'Canada/Pacific'                    , 0x027999 , 0),\t( 'Canada/Saskatchewan'               , 0x027DB2 , 0),\t( 'Canada/Yukon'                      , 0x027F3B , 0),\n\t( 'CET'                               , 0x02823E , 0),\t( 'Chile/Continental'                 , 0x028547 , 0),\t( 'Chile/EasterIsland'                , 0x028809 , 0),\t( 'CST6CDT'                           , 0x028A72 , 0),\n\t( 'Cuba'                              , 0x028DC3 , 0),\t( 'EET'                               , 0x029136 , 0),\t( 'Egypt'                             , 0x0293E9 , 0),\t( 'Eire'                              , 0x0297D0 , 0),\n\t( 'EST'                               , 0x029CE1 , 0),\t( 'EST5EDT'                           , 0x029D25 , 0),\t( 'Etc/GMT'                           , 0x02A076 , 0),\t( 'Etc/GMT+0'                         , 0x02A142 , 0),\n\t( 'Etc/GMT+1'                         , 0x02A1CC , 0),\t( 'Etc/GMT+10'                        , 0x02A259 , 0),\t( 'Etc/GMT+11'                        , 0x02A2E7 , 0),\t( 'Etc/GMT+12'                        , 0x02A375 , 0),\n\t( 'Etc/GMT+2'                         , 0x02A490 , 0),\t( 'Etc/GMT+3'                         , 0x02A51C , 0),\t( 'Etc/GMT+4'                         , 0x02A5A8 , 0),\t( 'Etc/GMT+5'                         , 0x02A634 , 0),\n\t( 'Etc/GMT+6'                         , 0x02A6C0 , 0),\t( 'Etc/GMT+7'                         , 0x02A74C , 0),\t( 'Etc/GMT+8'                         , 0x02A7D8 , 0),\t( 'Etc/GMT+9'                         , 0x02A864 , 0),\n\t( 'Etc/GMT-0'                         , 0x02A0FE , 0),\t( 'Etc/GMT-1'                         , 0x02A186 , 0),\t( 'Etc/GMT-10'                        , 0x02A212 , 0),\t( 'Etc/GMT-11'                        , 0x02A2A0 , 0),\n\t( 'Etc/GMT-12'                        , 0x02A32E , 0),\t( 'Etc/GMT-13'                        , 0x02A3BC , 0),\t( 'Etc/GMT-14'                        , 0x02A403 , 0),\t( 'Etc/GMT-2'                         , 0x02A44A , 0),\n\t( 'Etc/GMT-3'                         , 0x02A4D6 , 0),\t( 'Etc/GMT-4'                         , 0x02A562 , 0),\t( 'Etc/GMT-5'                         , 0x02A5EE , 0),\t( 'Etc/GMT-6'                         , 0x02A67A , 0),\n\t( 'Etc/GMT-7'                         , 0x02A706 , 0),\t( 'Etc/GMT-8'                         , 0x02A792 , 0),\t( 'Etc/GMT-9'                         , 0x02A81E , 0),\t( 'Etc/GMT0'                          , 0x02A0BA , 0),\n\t( 'Etc/Greenwich'                     , 0x02A8AA , 0),\t( 'Etc/UCT'                           , 0x02A8EE , 0),\t( 'Etc/Universal'                     , 0x02A932 , 0),\t( 'Etc/UTC'                           , 0x02A976 , 0),\n\t( 'Etc/Zulu'                          , 0x02A9BA , 0),\t( 'Europe/Amsterdam'                  , 0x02A9FE , 0),\t( 'Europe/Andorra'                    , 0x02AE3C , 0),\t( 'Europe/Athens'                     , 0x02B0B8 , 0),\n\t( 'Europe/Belfast'                    , 0x02B3FB , 0),\t( 'Europe/Belgrade'                   , 0x02B932 , 0),\t( 'Europe/Berlin'                     , 0x02BBFB , 0),\t( 'Europe/Bratislava'                 , 0x02BF5F , 0),\n\t( 'Europe/Brussels'                   , 0x02C291 , 0),\t( 'Europe/Bucharest'                  , 0x02C6C8 , 0),\t( 'Europe/Budapest'                   , 0x02C9F2 , 0),\t( 'Europe/Busingen'                   , 0x02CD5B , 0),\n\t( 'Europe/Chisinau'                   , 0x02D012 , 0),\t( 'Europe/Copenhagen'                 , 0x02D3A0 , 0),\t( 'Europe/Dublin'                     , 0x02D6AA , 0),\t( 'Europe/Gibraltar'                  , 0x02DBBB , 0),\n\t( 'Europe/Guernsey'                   , 0x02E012 , 0),\t( 'Europe/Helsinki'                   , 0x02E549 , 0),\t( 'Europe/Isle_of_Man'                , 0x02E7FF , 0),\t( 'Europe/Istanbul'                   , 0x02ED36 , 0),\n\t( 'Europe/Jersey'                     , 0x02F123 , 0),\t( 'Europe/Kaliningrad'                , 0x02F65A , 0),\t( 'Europe/Kiev'                       , 0x02F8C5 , 0),\t( 'Europe/Lisbon'                     , 0x02FBE1 , 0),\n\t( 'Europe/Ljubljana'                  , 0x0300E5 , 0),\t( 'Europe/London'                     , 0x0303AE , 0),\t( 'Europe/Luxembourg'                 , 0x0308E5 , 0),\t( 'Europe/Madrid'                     , 0x030D3B , 0),\n\t( 'Europe/Malta'                      , 0x031101 , 0),\t( 'Europe/Mariehamn'                  , 0x0314BA , 0),\t( 'Europe/Minsk'                      , 0x031770 , 0),\t( 'Europe/Monaco'                     , 0x031983 , 0),\n\t( 'Europe/Moscow'                     , 0x031DBE , 0),\t( 'Europe/Nicosia'                    , 0x032018 , 0),\t( 'Europe/Oslo'                       , 0x032300 , 0),\t( 'Europe/Paris'                      , 0x032632 , 0),\n\t( 'Europe/Podgorica'                  , 0x032A78 , 0),\t( 'Europe/Prague'                     , 0x032D41 , 0),\t( 'Europe/Riga'                       , 0x033073 , 0),\t( 'Europe/Rome'                       , 0x0333B8 , 0),\n\t( 'Europe/Samara'                     , 0x03377B , 0),\t( 'Europe/San_Marino'                 , 0x0339E4 , 0),\t( 'Europe/Sarajevo'                   , 0x033DA7 , 0),\t( 'Europe/Simferopol'                 , 0x034070 , 0),\n\t( 'Europe/Skopje'                     , 0x0342C1 , 0),\t( 'Europe/Sofia'                      , 0x03458A , 0),\t( 'Europe/Stockholm'                  , 0x034892 , 0),\t( 'Europe/Tallinn'                    , 0x034B41 , 0),\n\t( 'Europe/Tirane'                     , 0x034E7B , 0),\t( 'Europe/Tiraspol'                   , 0x035181 , 0),\t( 'Europe/Uzhgorod'                   , 0x03550F , 0),\t( 'Europe/Vaduz'                      , 0x035826 , 0),\n\t( 'Europe/Vatican'                    , 0x035AD5 , 0),\t( 'Europe/Vienna'                     , 0x035E98 , 0),\t( 'Europe/Vilnius'                    , 0x0361C5 , 0),\t( 'Europe/Volgograd'                  , 0x036504 , 0),\n\t( 'Europe/Warsaw'                     , 0x036729 , 0),\t( 'Europe/Zagreb'                     , 0x036B0A , 0),\t( 'Europe/Zaporozhye'                 , 0x036DD3 , 0),\t( 'Europe/Zurich'                     , 0x037114 , 0),\n\t( 'Factory'                           , 0x0373C3 , 0),\t( 'GB'                                , 0x037434 , 0),\t( 'GB-Eire'                           , 0x03796B , 0),\t( 'GMT'                               , 0x037EA2 , 0),\n\t( 'GMT+0'                             , 0x037F6E , 0),\t( 'GMT-0'                             , 0x037F2A , 0),\t( 'GMT0'                              , 0x037EE6 , 0),\t( 'Greenwich'                         , 0x037FB2 , 0),\n\t( 'Hongkong'                          , 0x037FF6 , 0),\t( 'HST'                               , 0x0381B8 , 0),\t( 'Iceland'                           , 0x0381FC , 0),\t( 'Indian/Antananarivo'               , 0x0383C9 , 0),\n\t( 'Indian/Chagos'                     , 0x038448 , 0),\t( 'Indian/Christmas'                  , 0x0384AA , 0),\t( 'Indian/Cocos'                      , 0x0384EE , 0),\t( 'Indian/Comoro'                     , 0x038532 , 0),\n\t( 'Indian/Kerguelen'                  , 0x0385B1 , 0),\t( 'Indian/Mahe'                       , 0x038606 , 0),\t( 'Indian/Maldives'                   , 0x03865B , 0),\t( 'Indian/Mauritius'                  , 0x0386B0 , 0),\n\t( 'Indian/Mayotte'                    , 0x038726 , 0),\t( 'Indian/Reunion'                    , 0x0387A5 , 0),\t( 'Iran'                              , 0x0387FA , 0),\t( 'Israel'                            , 0x038A68 , 0),\n\t( 'Jamaica'                           , 0x038D97 , 0),\t( 'Japan'                             , 0x038E5C , 0),\t( 'Kwajalein'                         , 0x038EE6 , 0),\t( 'Libya'                             , 0x038F49 , 0),\n\t( 'MET'                               , 0x039052 , 0),\t( 'Mexico/BajaNorte'                  , 0x03935B , 0),\t( 'Mexico/BajaSur'                    , 0x0396C4 , 0),\t( 'Mexico/General'                    , 0x039909 , 0),\n\t( 'MST'                               , 0x039B67 , 0),\t( 'MST7MDT'                           , 0x039BAB , 0),\t( 'Navajo'                            , 0x039EFC , 0),\t( 'NZ'                                , 0x03A275 , 0),\n\t( 'NZ-CHAT'                           , 0x03A5F3 , 0),\t( 'Pacific/Apia'                      , 0x03A8D7 , 0),\t( 'Pacific/Auckland'                  , 0x03AA73 , 0),\t( 'Pacific/Bougainville'              , 0x03ADFF , 0),\n\t( 'Pacific/Chatham'                   , 0x03AE76 , 0),\t( 'Pacific/Chuuk'                     , 0x03B169 , 0),\t( 'Pacific/Easter'                    , 0x03B1C2 , 0),\t( 'Pacific/Efate'                     , 0x03B438 , 0),\n\t( 'Pacific/Enderbury'                 , 0x03B4FE , 0),\t( 'Pacific/Fakaofo'                   , 0x03B56C , 0),\t( 'Pacific/Fiji'                      , 0x03B5BD , 0),\t( 'Pacific/Funafuti'                  , 0x03B750 , 0),\n\t( 'Pacific/Galapagos'                 , 0x03B794 , 0),\t( 'Pacific/Gambier'                   , 0x03B80C , 0),\t( 'Pacific/Guadalcanal'               , 0x03B871 , 0),\t( 'Pacific/Guam'                      , 0x03B8C6 , 0),\n\t( 'Pacific/Honolulu'                  , 0x03B91C , 0),\t( 'Pacific/Johnston'                  , 0x03B993 , 0),\t( 'Pacific/Kiritimati'                , 0x03BA12 , 0),\t( 'Pacific/Kosrae'                    , 0x03BA7D , 0),\n\t( 'Pacific/Kwajalein'                 , 0x03BADA , 0),\t( 'Pacific/Majuro'                    , 0x03BB46 , 0),\t( 'Pacific/Marquesas'                 , 0x03BBA5 , 0),\t( 'Pacific/Midway'                    , 0x03BC0C , 0),\n\t( 'Pacific/Nauru'                     , 0x03BC91 , 0),\t( 'Pacific/Niue'                      , 0x03BD09 , 0),\t( 'Pacific/Norfolk'                   , 0x03BD67 , 0),\t( 'Pacific/Noumea'                    , 0x03BDBC , 0),\n\t( 'Pacific/Pago_Pago'                 , 0x03BE4C , 0),\t( 'Pacific/Palau'                     , 0x03BEC3 , 0),\t( 'Pacific/Pitcairn'                  , 0x03BF07 , 0),\t( 'Pacific/Pohnpei'                   , 0x03BF5C , 0),\n\t( 'Pacific/Ponape'                    , 0x03BFB1 , 0),\t( 'Pacific/Port_Moresby'              , 0x03BFF6 , 0),\t( 'Pacific/Rarotonga'                 , 0x03C048 , 0),\t( 'Pacific/Saipan'                    , 0x03C124 , 0),\n\t( 'Pacific/Samoa'                     , 0x03C17A , 0),\t( 'Pacific/Tahiti'                    , 0x03C1F1 , 0),\t( 'Pacific/Tarawa'                    , 0x03C256 , 0),\t( 'Pacific/Tongatapu'                 , 0x03C2AA , 0),\n\t( 'Pacific/Truk'                      , 0x03C336 , 0),\t( 'Pacific/Wake'                      , 0x03C37B , 0),\t( 'Pacific/Wallis'                    , 0x03C3CB , 0),\t( 'Pacific/Yap'                       , 0x03C40F , 0),\n\t( 'Poland'                            , 0x03C454 , 0),\t( 'Portugal'                          , 0x03C835 , 0),\t( 'PRC'                               , 0x03CD31 , 0),\t( 'PST8PDT'                           , 0x03CDD1 , 0),\n\t( 'ROC'                               , 0x03D122 , 0),\t( 'ROK'                               , 0x03D253 , 0),\t( 'Singapore'                         , 0x03D346 , 0),\t( 'Turkey'                            , 0x03D3FD , 0),\n\t( 'UCT'                               , 0x03D7EA , 0),\t( 'Universal'                         , 0x03D82E , 0),\t( 'US/Alaska'                         , 0x03D872 , 0),\t( 'US/Aleutian'                       , 0x03DBDB , 0),\n\t( 'US/Arizona'                        , 0x03DF41 , 0),\t( 'US/Central'                        , 0x03DFCF , 0),\t( 'US/East-Indiana'                   , 0x03E9D9 , 0),\t( 'US/Eastern'                        , 0x03E4DA , 0),\n\t( 'US/Hawaii'                         , 0x03EC43 , 0),\t( 'US/Indiana-Starke'                 , 0x03ECB4 , 0),\t( 'US/Michigan'                       , 0x03F025 , 0),\t( 'US/Mountain'                       , 0x03F35C , 0),\n\t( 'US/Pacific'                        , 0x03F6D5 , 0),\t( 'US/Pacific-New'                    , 0x03FADA , 0),\t( 'US/Samoa'                          , 0x03FEDF , 0),\t( 'UTC'                               , 0x03FF56 , 0),\n\t( 'W-SU'                              , 0x04024D , 0),\t( 'WET'                               , 0x03FF9A , 0),\n   ( 'Zulu'                              , 0x040490 , 0);";
    $CI->db->query($sqlStr);
    $sqlStr = "ALTER TABLE  admin_chapters\n            ADD ch_lTimeZone INT NOT NULL DEFAULT  '2'\n            COMMENT  'foreign key to table lists_tz'\n            AFTER `ch_bUS_DateFormat`;";
    $CI->db->query($sqlStr);
    // find the current time zone
    $strTZ = $CI->config->item('dl_timezone');
    $sqlStr = 'SELECT tz_lKeyID
          FROM lists_tz
          WHERE tz_strTimeZone=' . strPrepStr($strTZ) . '
          ORDER BY tz_lKeyID
          LIMIT 0,1;';
    $query = $CI->db->query($sqlStr);
    $numRows = $query->num_rows();
    if ($numRows > 0) {
        $row = $query->row();
        $lTZ = (int) $row->tz_lKeyID;
        $sqlStr = "UPDATE admin_chapters SET ch_lTimeZone = '{$lTZ}' WHERE ch_lKeyID =1;";
        $CI->db->query($sqlStr);
    }
}
 function loadCustomFormsViaType($enumType)
 {
     //---------------------------------------------------------------------
     //
     //---------------------------------------------------------------------
     $this->strWhereExtra = ' AND cf_enumContextType= ' . strPrepStr($enumType) . ' ';
     $this->loadCustomForms();
 }
Пример #5
0
 function loadVolRegFormsViaHash($strHash)
 {
     //---------------------------------------------------------------------
     //
     //---------------------------------------------------------------------
     $this->strWhereExtra = ' AND vreg_strURLHash=' . strPrepStr($strHash) . ' ';
     $this->loadVolRegForms();
 }
Пример #6
0
 function lDocsGrouped(&$lNumContextGroups, &$contextGroups)
 {
     //---------------------------------------------------------------------
     //
     //---------------------------------------------------------------------
     $sqlWhere = 'AND di_enumEntryType=' . strPrepStr(CENUM_IMGDOC_ENTRY_PDF) . ' ';
     $this->lGroupedImageDocCnt($sqlWhere, 'di_enumContextType', $lNumContextGroups, $contextGroups);
 }
Пример #7
0
 public function updateEventDate($lEventDateID, $dteEvent, $bmysqlDate = false)
 {
     //-----------------------------------------------------------------------
     //
     //-----------------------------------------------------------------------
     if ($bmysqlDate) {
         $strEDate = strPrepStr($dteEvent);
     } else {
         $strEDate = strPrepDate($dteEvent);
     }
     $sqlStr = "UPDATE vol_events_dates\n          SET\n             ved_dteEvent = {$strEDate}\n          WHERE ved_lKeyID={$lEventDateID};";
     $this->db->query($sqlStr);
 }
Пример #8
0
function strNameWhereClauseViaLetter($strFieldName, $strDirLetter)
{
    //---------------------------------------------------------------------
    //
    //---------------------------------------------------------------------
    if ($strDirLetter == '*') {
        $strWhereName = ' ';
    } elseif ($strDirLetter == '#') {
        $strWhereName = ' AND ((LEFT(' . $strFieldName . ',1) < "A") OR (LEFT(' . $strFieldName . ',1) > "Z")) ';
    } else {
        $strWhereName = ' AND (LEFT(' . $strFieldName . ',1)=' . strPrepStr($strDirLetter) . ') ';
    }
    return $strWhereName;
}
 function loadUFSchemaViaAttachTypeUserTabName($enumAttachType, $strUserTabName, &$lTableID, $bFreakIfNotFound = false)
 {
     //---------------------------------------------------------------------
     //
     //---------------------------------------------------------------------
     $this->sqlWhereExtra = ' AND pft_enumAttachType   = ' . strPrepStr($enumAttachType) . '
          AND pft_strUserTableName = ' . strPrepStr($strUserTabName) . ' ';
     $this->loadUFSchema();
     if ($bFreakIfNotFound && $this->lNumTables == 0) {
         screamForHelp($strUserTabName . ': user table not found<br>error on line  <b> -- ' . __LINE__ . ' --</b>,<br>file ' . __FILE__ . ',<br>function ' . __FUNCTION__);
     }
     // technique to get first key value
     // http://stackoverflow.com/questions/4095796/php-how-to-get-associative-array-key-from-numeric-index
     reset($this->schema);
     $lTableID = key($this->schema);
 }
Пример #10
0
 function addEditS2()
 {
     //---------------------------------------------------------------------
     //
     //---------------------------------------------------------------------
     if (!bTestForURLHack('editPeopleBizVol')) {
         return;
     }
     $displayData = array();
     $this->load->helper('js/simple_search');
     $this->load->model('util/msearch_single_generic', 'clsSearch');
     $this->load->model('people/mpeople', 'clsPeople');
     $this->clsSearch->strSearchTerm = $strSearch = trim($_POST['txtSearch']);
     //-----------------------------
     // search display setup
     //-----------------------------
     $this->clsSearch->enumSearchType = CENUM_CONTEXT_PEOPLE;
     $this->clsSearch->strSearchLabel = 'People';
     $this->clsSearch->bShowKeyID = true;
     $this->clsSearch->strIDLabel = 'peopleID: ';
     $this->clsSearch->bShowLink = false;
     $this->clsSearch->bShowSelect = true;
     $this->clsSearch->bShowEnumSearchType = false;
     $this->clsSearch->strDisplayTitle = '<br>Please select the person to add as a volunteer</b><br>';
     // landing page for selection
     $this->clsSearch->strPathSelection = 'volunteers/vol_add_edit/addNewS3/';
     $this->clsSearch->strTitleSelection = 'Select person';
     // landing page for "back"
     $this->clsSearch->strPathSearchAgain = 'volunteers/vol_add_edit/addEditS1';
     $this->clsSearch->strTitleSearchAgain = 'Search again...';
     $lLeftCnt = strlen($strSearch);
     $this->clsSearch->strWhereExtra = " AND LEFT(pe_strLName, {$lLeftCnt})=" . strPrepStr($strSearch) . ' ';
     // run search
     $displayData['strSearchLabel'] = 'Searching for ' . $this->clsSearch->enumSearchType . ' that begin with <b><i>"' . htmlspecialchars($strSearch) . '"</b></i><br>';
     $this->clsSearch->searchNewVolunteer();
     $displayData['strHTMLSearchResults'] = $this->clsSearch->strHTML_SearchResults();
     //-----------------------------
     // breadcrumbs & page setup
     //-----------------------------
     $displayData['title'] = CS_PROGNAME . ' | Add new volunteer';
     $displayData['pageTitle'] = anchor('main/menu/vols', 'Volunteers', 'class="breadcrumb"') . ' | Add New Volunteers';
     $displayData['mainTemplate'] = 'vols/search_sel_person_view';
     $displayData['nav'] = $this->mnav_brain_jar->navData();
     $this->load->vars($displayData);
     $this->load->view('template');
 }
 function searchHH($strSearch)
 {
     //---------------------------------------------------------------------
     //
     //---------------------------------------------------------------------
     $displayData = array();
     if (!bTestForURLHack('dataEntryPeopleBizVol')) {
         return;
     }
     $this->load->model('util/msearch_single_generic', 'clsSearch');
     $this->load->model('people/mpeople', 'clsPeople');
     //-----------------------------
     // search display setup
     //-----------------------------
     $this->clsSearch->enumSearchType = CENUM_CONTEXT_HOUSEHOLD;
     $this->clsSearch->strSearchLabel = 'Household';
     $this->clsSearch->bShowKeyID = true;
     $this->clsSearch->bShowSelect = true;
     $this->clsSearch->bShowEnumSearchType = false;
     $this->clsSearch->strDisplayTitle = '<br>Please select the household for the new person</b><br>';
     // landing page for selection
     $this->clsSearch->strPathSelection = 'people/people_add_new/addNewS3/';
     $this->clsSearch->strTitleSelection = 'Select household';
     // landing page for "back"
     $this->clsSearch->strPathSearchAgain = 'people/people_add_new/selCon';
     $this->clsSearch->strTitleSearchAgain = 'Search again...';
     $lLeftCnt = strlen($strSearch);
     $this->clsSearch->strSearchTerm = $strSearch;
     $this->clsSearch->strWhereExtra = " AND LEFT(pe_strLName, {$lLeftCnt})=" . strPrepStr($strSearch) . " ";
     $this->clsSearch->strIDLabel = 'household ID: ';
     $this->clsSearch->bShowLink = false;
     // run search
     $displayData['strSearchLabel'] = 'Searching for ' . $this->clsSearch->enumSearchType . ' that begin with <b><i>"' . htmlspecialchars($strSearch) . '"</b></i><br>';
     //      $this->clsSearch->searchPeople();
     $this->clsSearch->searchHousehold();
     $displayData['strHTMLSearchResults'] = $this->clsSearch->strHTML_SearchResults();
     //-----------------------------
     // breadcrumbs & page setup
     //-----------------------------
     $displayData['title'] = CS_PROGNAME . ' | Select Household';
     $displayData['pageTitle'] = anchor('main/menu/people', 'People', 'class="breadcrumb"') . ' | ' . anchor('people/people_add_new/selCon', 'Add New', 'class="breadcrumb"') . ' | Select Household';
     $displayData['mainTemplate'] = 'people/search_sel_household_view';
     $displayData['nav'] = $this->mnav_brain_jar->navData();
     $this->load->vars($displayData);
     $this->load->view('template');
 }
Пример #12
0
 function addRecycleEntry()
 {
     //-----------------------------------------------------------------------
     //
     //-----------------------------------------------------------------------
     global $glUserID;
     $varGroupID = is_null($this->lGroupID) ? 0 : $this->lGroupID;
     $sqlStr = "INSERT INTO recycle_bin\n         SET\n            rb_lGroupID        = {$varGroupID},\n            rb_enumRecycleType = " . strPrepStr($this->enumRecycleType) . ',
         rb_strDescription  = ' . strPrepStr(substr($this->strNotes, 0, 255)) . ',
         rb_strTable        = ' . strPrepStr($this->strTable) . ',
         rb_strKeyIDFN      = ' . strPrepStr($this->strKeyIDFN) . ',
         rb_strRetireFN     = ' . strPrepStr($this->strRetireFN) . ",\n            rb_lForeignID      = {$this->lForeignID},\n            rb_lOriginID       = {$glUserID},\n            rb_lLastUpdateID   = {$glUserID},\n            rb_dteOrigin       = NOW(),\n            rb_dteLastUpdate   = NOW();";
     $query = $this->db->query($sqlStr);
     if (is_null($this->lGroupID)) {
         $this->lGroupID = $lKeyID = mysql_insert_id();
         $sqlStr = "UPDATE recycle_bin SET rb_lGroupID={$lKeyID} WHERE rb_lKeyID={$lKeyID};";
         $query = $this->db->query($sqlStr);
     }
 }
Пример #13
0
 public function bVerifyUniqueText($strTestText, $strTxtFN, $lKeyExclude, $strKeyFN, $bExcludeRetired, $strRetiredFN, $bQualSubGroup1, $lKeySubGroup1, $strSubGroupFN_1, $bQualSubGroup2, $lKeySubGroup2, $strSubGroupFN_2, $strTableName)
 {
     //---------------------------------------------------------------------
     // return true if the text entry is not already in the database.
     // Inputs:
     //    $strTestText - text to test against
     //    $strTxtFN    - field name of the text field
     //    $lKeyExclude - exclusion key value (if testing for uniqueness but want to exclude
     //                   the current entry (for updates))
     //    $strKeyFN    - the field name of the key
     //    $bExcludeRetired - if true, exclude retired table entries from the test
     //    $strRetiredFN - field name of retired entry flag (assumed to be boolean)
     //    $strTableName - the database table name
     //
     //    $bQualSubGroup1/2, $lKeySubGroup1/2, $strSubGroupFN_1/2
     //                  - if true, qualify the search to records that have matching
     //                    key values
     //---------------------------------------------------------------------
     $strQual1 = $strQual2 = '';
     if ($bQualSubGroup1) {
         if (is_numeric($lKeySubGroup1)) {
             $strQual1 = "AND ({$strSubGroupFN_1} = {$lKeySubGroup1}) ";
         } else {
             $strQual1 = "AND ({$strSubGroupFN_1} = " . strPrepStr($lKeySubGroup1) . ') ';
         }
     }
     if ($bQualSubGroup2) {
         if (is_numeric($lKeySubGroup2)) {
             $strQual2 = "AND ({$strSubGroupFN_2} = {$lKeySubGroup2}) ";
         } else {
             $strQual2 = "AND ({$strSubGroupFN_2} = " . strPrepStr($lKeySubGroup2) . ') ';
         }
     }
     $sqlStr = "SELECT count({$strKeyFN}) as lNumMatch\n           FROM {$strTableName}\n           WHERE ucase({$strTxtFN})=" . strPrepStr(strtoupper($strTestText)) . "\n              AND {$strKeyFN}<>{$lKeyExclude}\n              {$strQual1}\n              {$strQual2} " . ($bExcludeRetired ? "AND ({$strRetiredFN}=0) " : '') . ';';
     $query = $this->db->query($sqlStr);
     if ($query->num_rows() == 0) {
         screamForHelp('Unexpected SQL error - forms/util/util_VerifyUnique.php/bVerifyUniqueText');
     } else {
         $row = $query->row();
         return $row->lNumMatch == 0;
     }
 }
Пример #14
0
 function lAddLogEntry($bSuccess, $strUserName)
 {
     //---------------------------------------------------------------------
     //
     //---------------------------------------------------------------------
     if ($bSuccess) {
         if (is_null($this->el_lUserID)) {
             screamForHelp('UNITIALIZED CLASS</b><br>error on <b>line:</b> ' . __LINE__ . '<br><b>file:</b> ' . __FILE__ . '<br><b>function:</b> ' . __FUNCTION__);
         }
     }
     $sqlStr = 'INSERT INTO admin_usage_log
       SET
            el_lUserID         = ' . strDBValueConvert_INT($this->el_lUserID) . ',
            el_str_Remote_Addr = ' . strPrepStr(@$_SERVER['REMOTE_ADDR']) . ',
            el_strUserName     = '******',
            el_bLoginSuccessful= ' . ($bSuccess ? '1' : '0') . ',
            el_str_Remote_Host = ' . strPrepStr(@$_SERVER['REMOTE_HOST']) . ',
            el_str_Remote_Port = ' . strPrepStr(@$_SERVER['REMOTE_PORT']) . ';';
     $query = $this->db->query($sqlStr);
     return $this->db->insert_id();
 }
function sqlCommonCustomFormAddEdit(&$fContext, &$rRec, $enumContext)
{
    //---------------------------------------------------------------------
    //
    //---------------------------------------------------------------------
    global $glUserID;
    // internal fields
    $sqlStr = $fContext->strFNPrefix . 'strFormName      = ' . strPrepStr($rRec->strFormName) . ', ' . "\n" . $fContext->strFNPrefix . 'strDescription   = ' . strPrepStr($rRec->strDescription) . ', ' . "\n";
    if ($fContext->bVolReg) {
        $sqlStr .= $fContext->strFNPrefix . 'strContactEmail  = ' . strPrepStr($rRec->strContactEmail) . ', ' . "\n";
        $sqlStr .= '
            vreg_strCSSFN         = ' . strPrepStr($rRec->strCSSFN) . ',
            vreg_lLogoImageID     = ' . (is_null($rRec->lLogoImageID) ? 'null' : $rRec->lLogoImageID) . ',
            vreg_lVolGroupID      = ' . (is_null($rRec->lVolGroupID) ? 'null' : $rRec->lVolGroupID) . ',
            vreg_bCaptchaRequired = ' . ($rRec->bCaptchaRequired ? '1' : '0') . ', ' . "\n";
        // form registration permissions
        $sqlStr .= '
            vreg_bPermEditContact     = ' . ($rRec->bPermEditContact ? '1' : '0') . ',
            vreg_bPermPassReset       = ' . ($rRec->bPermPassReset ? '1' : '0') . ',
            vreg_bPermViewGiftHistory = ' . ($rRec->bPermViewGiftHistory ? '1' : '0') . ',
            vreg_bPermEditJobSkills   = ' . ($rRec->bPermEditJobSkills ? '1' : '0') . ',
            vreg_bPermViewHrsHistory  = ' . ($rRec->bPermViewHrsHistory ? '1' : '0') . ',
            vreg_bPermAddVolHours     = ' . ($rRec->bPermAddVolHours ? '1' : '0') . ',
            vreg_bVolShiftSignup      = ' . ($rRec->bVolShiftSignup ? '1' : '0') . ',
            vreg_strBannerOrg         = ' . strPrepStr($rRec->strBannerOrg) . ",\n";
        // Standard Fields - show
        $sqlStr .= $fContext->strFNPrefix . 'bShowFName = ' . ($rRec->bShowFName ? '1' : '0') . ",\n" . $fContext->strFNPrefix . 'bShowLName = ' . ($rRec->bShowLName ? '1' : '0') . ",\n" . $fContext->strFNPrefix . 'bShowAddr  = ' . ($rRec->bShowAddr ? '1' : '0') . ",\n" . $fContext->strFNPrefix . 'bShowEmail = ' . ($rRec->bShowEmail ? '1' : '0') . ",\n" . $fContext->strFNPrefix . 'bShowPhone = ' . ($rRec->bShowPhone ? '1' : '0') . ",\n" . $fContext->strFNPrefix . 'bShowCell  = ' . ($rRec->bShowCell ? '1' : '0') . ",\n" . $fContext->strFNPrefix . 'bShowBDay  = ' . ($rRec->bShowBDay ? '1' : '0') . ",\n";
        // Standard Fields - required
        $sqlStr .= $fContext->strFNPrefix . 'bFNameRequired = ' . ($rRec->bFNameRequired ? '1' : '0') . ",\n" . $fContext->strFNPrefix . 'bLNameRequired = ' . ($rRec->bLNameRequired ? '1' : '0') . ",\n" . $fContext->strFNPrefix . 'bAddrRequired  = ' . ($rRec->bAddrRequired ? '1' : '0') . ",\n" . $fContext->strFNPrefix . 'bEmailRequired = ' . ($rRec->bEmailRequired ? '1' : '0') . ",\n" . $fContext->strFNPrefix . 'bPhoneRequired = ' . ($rRec->bPhoneRequired ? '1' : '0') . ",\n" . $fContext->strFNPrefix . 'bCellRequired  = ' . ($rRec->bCellRequired ? '1' : '0') . ",\n" . $fContext->strFNPrefix . 'bBDateRequired = ' . ($rRec->bBDateRequired ? '1' : '0') . ",\n";
        // Disclaimer
        $sqlStr .= $fContext->strFNPrefix . 'bShowDisclaimer    = ' . ($rRec->bShowDisclaimer ? '1' : '0') . ",\n" . $fContext->strFNPrefix . 'bDisclaimerAckRqrd = ' . ($rRec->bDisclaimerAckRqrd ? '1' : '0') . ",\n" . $fContext->strFNPrefix . 'strDisclaimerAck   = ' . strPrepStr($rRec->strDisclaimerAck) . ",\n" . $fContext->strFNPrefix . 'strDisclaimer      = ' . strPrepStr($rRec->strDisclaimer) . ",\n";
    } else {
        $sqlStr .= $fContext->strFNPrefix . 'enumContextType       = ' . strPrepStr($enumContext) . ",\n" . $fContext->strFNPrefix . 'strVerificationModule = ' . strPrepStr($rRec->strVerificationModule) . ",\n" . $fContext->strFNPrefix . 'strVModEntryPoint     = ' . strPrepStr($rRec->strVModEntryPoint) . ",\n";
    }
    // top banner
    $sqlStr .= $fContext->strFNPrefix . 'strBannerTitle    = ' . strPrepStr($rRec->strBannerTitle) . ",\n" . $fContext->strFNPrefix . 'strSubmissionText = ' . strPrepStr($rRec->strSubmissionText) . ",\n" . $fContext->strFNPrefix . 'strIntro          = ' . strPrepStr($rRec->strIntro) . ",\n";
    // timestamp
    $sqlStr .= $fContext->strFNPrefix . 'lLastUpdateID = ' . $glUserID . ",\n" . $fContext->strFNPrefix . "dteLastUpdate=NOW() \n";
    return $sqlStr;
}
 private function searchSelected(&$displayData, $lPID, $strTitle, $strSearch)
 {
     //---------------------------------------------------------------------
     //
     //---------------------------------------------------------------------
     $this->load->model('util/msearch_single_generic', 'clsSearch');
     //-----------------------------
     // search display setup
     //-----------------------------
     $this->clsSearch->enumSearchType = CENUM_CONTEXT_PEOPLE;
     $this->clsSearch->strSearchLabel = 'People';
     $this->clsSearch->bShowKeyID = true;
     $this->clsSearch->bShowSelect = true;
     $this->clsSearch->strIDLabel = 'peopleID: ';
     $this->clsSearch->bShowLink = false;
     $this->clsSearch->bShowEnumSearchType = false;
     $this->clsSearch->strDisplayTitle = '<br>Please select the person for this new relationship</b><br>';
     // landing page for selection
     $this->clsSearch->strPathSelection = 'people/relationships/setRelType/' . $lPID . '/';
     $this->clsSearch->strTitleSelection = 'Select person';
     // landing page for "back"
     $this->clsSearch->strPathSearchAgain = 'people/relationships/addEditS1/' . $lPID;
     $this->clsSearch->strTitleSearchAgain = 'Search again...';
     $lLeftCnt = strlen($strSearch);
     $this->clsSearch->strSearchTerm = $strSearch;
     $this->clsSearch->strWhereExtra = " AND (pe_lKeyID != {$lPID})\n                                 AND LEFT(pe_strLName, {$lLeftCnt})=" . strPrepStr($strSearch) . " ";
     // run search
     $displayData['strSearchLabel'] = 'Searching for ' . $this->clsSearch->enumSearchType . ' that begin with <b><i>"' . htmlspecialchars($strSearch) . '"</b></i><br>';
     $this->clsSearch->searchPeople();
     $displayData['strHTMLSearchResults'] = $this->clsSearch->strHTML_SearchResults();
     //-----------------------------
     // breadcrumbs & page setup
     //-----------------------------
     $displayData['title'] = CS_PROGNAME . ' | Relationships';
     $displayData['nav'] = $this->mnav_brain_jar->navData();
     $displayData['mainTemplate'] = 'people/search_sel_person_view';
     $this->load->vars($displayData);
     $this->load->view('template');
 }
Пример #17
0
    private function strSQLCommon()
    {
        //---------------------------------------------------------------------
        //
        //---------------------------------------------------------------------
        global $glUserID;
        $cprog =& $this->cprogs[0];
        return '
            cp_strProgramName   = ' . strPrepStr($cprog->strProgramName) . ',
            cp_strVocEnroll     = ' . strPrepStr($cprog->strEnrollmentLabel) . ',
            cp_strVocAttendance = ' . strPrepStr($cprog->strAttendanceLabel) . ',
            cp_strDescription   = ' . strPrepStr($cprog->strDescription) . ',
            cp_dteStart         = ' . strPrepStr($cprog->dteMysqlStart) . ',
            cp_dteEnd           = ' . strPrepStr($cprog->dteMysqlEnd) . ',

            cp_strE_VerificationModule = ' . strPrepStr($cprog->strE_VerificationModule) . ',
            cp_strE_VModEntryPoint     = ' . strPrepStr($cprog->strE_VModEntryPoint) . ',
            cp_strA_VerificationModule = ' . strPrepStr($cprog->strA_VerificationModule) . ',
            cp_strA_VModEntryPoint     = ' . strPrepStr($cprog->strA_VModEntryPoint) . ',

            cp_bHidden          = ' . ($cprog->bHidden ? '1' : '0') . ',

            cp_bMentorMentee    = ' . ($cprog->bMentorMentee ? '1' : '0') . ",\n\n            cp_dteLastUpdate    = NOW(),\n            cp_lLastUpdateID    = {$glUserID} ";
    }
 function addNewS2($lBizID)
 {
     //---------------------------------------------------------------------
     //
     //---------------------------------------------------------------------
     $this->load->helper('dl_util/verify_id');
     verifyID($this, $lBizID, 'business ID');
     $displayData = array();
     $displayData['lBizID'] = $lBizID = (int) $lBizID;
     if (!bTestForURLHack('dataEntryPeopleBizVol')) {
         return;
     }
     $this->load->helper('js/simple_search');
     //------------------------------------------------
     // libraries and utilities
     //------------------------------------------------
     $this->load->model('util/msearch_single_generic', 'clsSearch');
     $this->load->model('people/mpeople', 'clsPeople');
     $params = array('enumStyle' => 'terse');
     $this->load->library('generic_rpt', $params);
     $this->load->library('util/dl_date_time', '', 'clsDateTime');
     $this->load->model('admin/madmin_aco', 'clsACO');
     $this->load->model('biz/mbiz', 'clsBiz');
     //      $this->load->helper ('dl_util/email_web');
     $this->clsBiz->loadBizRecsViaBID($lBizID);
     $displayData['contextSummary'] = $this->clsBiz->strBizHTMLSummary();
     $this->clsSearch->strSearchTerm = $strSearch = trim($_POST['txtSearch']);
     //-----------------------------
     // search display setup
     //-----------------------------
     $this->clsSearch->enumSearchType = CENUM_CONTEXT_PEOPLE;
     $this->clsSearch->strSearchLabel = 'People';
     $this->clsSearch->bShowKeyID = true;
     $this->clsSearch->bShowSelect = true;
     $this->clsSearch->bShowEnumSearchType = false;
     $this->clsSearch->strDisplayTitle = '<br>Please select contact for this business/organization</b><br>';
     // landing page for selection
     $this->clsSearch->strPathSelection = 'biz/biz_contact_add_edit/contactAddEdit/' . $lBizID . '/0/';
     $this->clsSearch->strTitleSelection = 'Select person';
     // landing page for "back"
     $this->clsSearch->strPathSearchAgain = 'biz/biz_contact_add_edit/addNewS1/' . $lBizID;
     $this->clsSearch->strTitleSearchAgain = 'Search again...';
     $this->clsBiz->lBID = $lBizID;
     $strContacts = $this->clsBiz->strBizContactPeopleIDList();
     $lLeftCnt = strlen($strSearch);
     $this->clsSearch->strWhereExtra = " AND LEFT(pe_strLName, {$lLeftCnt})=" . strPrepStr($strSearch) . ' ';
     if ($strContacts != '') {
         $this->clsSearch->strWhereExtra .= " AND NOT (pe_lKeyID IN ({$strContacts})) ";
     }
     $this->clsSearch->strIDLabel = 'peopleID: ';
     $this->clsSearch->bShowLink = false;
     // run search
     $displayData['strSearchLabel'] = 'Searching for ' . $this->clsSearch->enumSearchType . ' that begin with <b><i>"' . htmlspecialchars($strSearch) . '"</b></i><br>';
     $this->clsSearch->searchPeople();
     $displayData['strHTMLSearchResults'] = $this->clsSearch->strHTML_SearchResults();
     //-----------------------------
     // breadcrumbs & page setup
     //-----------------------------
     $displayData['title'] = CS_PROGNAME . ' | Business';
     $displayData['pageTitle'] = anchor('main/menu/biz', 'Businesses/Organizations', 'class="breadcrumb"') . ' | ' . anchor('biz/biz_record/view/' . $lBizID, 'Business Record', 'class="breadcrumb"') . ' | Add Business Contact';
     $displayData['mainTemplate'] = 'biz/contact_select_view';
     $displayData['nav'] = $this->mnav_brain_jar->navData();
     $this->load->vars($displayData);
     $this->load->view('template');
 }
Пример #19
0
 function sqlCommonAuctions()
 {
     //---------------------------------------------------------------------
     //
     //---------------------------------------------------------------------
     global $glUserID;
     $auction =& $this->auctions[0];
     if (is_null($auction->lDefaultBidSheet)) {
         $strDefBS = 'null';
     } else {
         $strDefBS = (int) $auction->lDefaultBidSheet . '';
     }
     return '
      auc_strAuctionName   = ' . strPrepStr($auction->strAuctionName) . ',
      auc_strDescription   = ' . strPrepStr($auction->strDescription) . ',
      auc_dteAuctionDate   = ' . strPrepStr($auction->mdteAuction) . ',
      auc_lACOID           = ' . (int) $auction->lACOID . ',
      auc_strEmail         = ' . strPrepStr($auction->strEmail) . ',
      auc_lCampaignID      = ' . (int) $auction->lCampaignID . ',
      auc_strLocation      = ' . strPrepStr($auction->strLocation) . ',
      auc_strContact       = ' . strPrepStr($auction->strContact) . ',
      auc_strPhone         = ' . strPrepStr($auction->strPhone) . ",\n         auc_lDefaultBidSheet = {$strDefBS},\n         auc_lLastUpdateID    = {$glUserID},\n         auc_dteLastUpdate    = NOW() ";
 }
Пример #20
0
 function addVolAssociation($va)
 {
     //---------------------------------------------------------------------
     //
     //---------------------------------------------------------------------
     global $glUserID;
     $sqlStr = "INSERT INTO vol_client_association\n         SET\n            vca_lVolID        = {$va->lVolID},\n            vca_lClientID     = {$va->lClientID},\n            vca_lOriginID     = {$glUserID},\n            vca_lLastUpdateID = {$glUserID},\n            vca_Notes         = " . strPrepStr($va->strNotes) . ',
         vca_bRetired      = 0,
         vca_dteOrigin     = NOW(),
         vca_dteLastUpdate = NOW();';
     $this->db->query($sqlStr);
 }
Пример #21
0
    private function strBizSQLCommon()
    {
        //-----------------------------------------------------------------------
        //
        //-----------------------------------------------------------------------
        global $glUserID;
        $biz =& $this->bizRecs[0];
        if (is_null($biz->lAttributedTo)) {
            $strAttrib = 'null';
        } else {
            $strAttrib = (int) $biz->lAttributedTo;
        }
        return '
          pe_strLName        = ' . strPrepStr($biz->strBizName) . ',
          pe_strAddr1        = ' . strPrepStr($biz->strAddr1) . ',
          pe_strAddr2        = ' . strPrepStr($biz->strAddr2) . ',
          pe_strCity         = ' . strPrepStr($biz->strCity) . ',
          pe_strState        = ' . strPrepStr($biz->strState) . ',
          pe_strCountry      = ' . strPrepStr($biz->strCountry) . ',
          pe_strZip          = ' . strPrepStr($biz->strZip) . ',
          pe_strPhone        = ' . strPrepStr($biz->strPhone) . ',
          pe_strCell         = ' . strPrepStr($biz->strCell) . ',
          pe_strFax          = ' . strPrepStr($biz->strFax) . ',
          pe_strWebSite      = ' . strPrepStr($biz->strWebSite) . ',
          pe_strNotes        = ' . strPrepStr($biz->strNotes) . ',
          pe_strSalutation   = ' . strPrepStr('') . ',

          pe_strEmail        = ' . strPrepStr($biz->strEmail) . ",\n          pe_lACO            = {$biz->lACO},\n          pe_lAttributedTo   = {$strAttrib},\n          pe_bBiz            = 1,\n          pe_lBizIndustryID  = {$biz->lIndustryID},\n\n          pe_lLastUpdateID   = {$glUserID} ";
    }
Пример #22
0
 function firstLastNameSearch($strSearch)
 {
     //---------------------------------------------------------------------
     //
     //---------------------------------------------------------------------
     if (!bTestForURLHack('showSponsors')) {
         return;
     }
     $this->load->model('util/msearch_single_generic', 'clsSearch');
     $this->load->model('sponsorship/msponsorship', 'clsSpon');
     $this->load->helper('reports/report_util');
     $params = array('enumStyle' => 'terse');
     $this->load->library('Generic_rpt', $params);
     $this->load->library('util/dl_date_time', '', 'clsDateTime');
     $this->clsSearch->strSearchTerm = $strSearch;
     //-----------------------------
     // search display setup
     //-----------------------------
     $this->clsSearch->enumSearchType = CENUM_CONTEXT_SPONSORSHIP;
     $this->clsSearch->strSearchLabel = 'Sponsor';
     $this->clsSearch->bShowKeyID = true;
     $this->clsSearch->bShowSelect = true;
     $this->clsSearch->bShowEnumSearchType = false;
     $this->clsSearch->strDisplayTitle = '<br>Please select the sponsor</b><br>';
     // landing page for selection
     $this->clsSearch->strPathSelection = 'sponsors/view_spon_rec/viewViaSponID/';
     $this->clsSearch->strTitleSelection = 'Select sponsor:';
     // landing page for "back"
     $this->clsSearch->strPathSearchAgain = 'sponsors/spon_search/opts';
     $this->clsSearch->strTitleSearchAgain = 'Search again...';
     $lLeftCnt = strlen($strSearch);
     $this->clsSearch->strWhereExtra = " AND (   (LEFT(pe_strFName, {$lLeftCnt})=" . strPrepStr($strSearch) . ")\n                                               OR (LEFT(pe_strLName, {$lLeftCnt})=" . strPrepStr($strSearch) . ')) ';
     $this->clsSearch->strIDLabel = 'sponsorID: ';
     $this->clsSearch->bShowLink = false;
     // run search
     $displayData['strSearchLabel'] = 'Searching for sponsors whose first or last name begins with <b><i>"' . htmlspecialchars($strSearch) . '"</b></i><br>';
     $this->clsSearch->searchSponsors($this);
     $displayData['strHTMLSearchResults'] = $this->clsSearch->strHTML_SearchResults();
     //-----------------------------
     // breadcrumbs & page setup
     //-----------------------------
     $displayData['title'] = CS_PROGNAME . ' | Sponsor Search';
     $displayData['pageTitle'] = anchor('main/menu/sponsorship', 'Sponsorship', 'class="breadcrumb"') . ' | ' . anchor('sponsors/spon_search/opts', 'Search Options', 'class="breadcrumb"') . ' | Results';
     $displayData['mainTemplate'] = 'reports/search_select_view';
     $displayData['nav'] = $this->mnav_brain_jar->navData();
     $this->load->vars($displayData);
     $this->load->view('template');
 }
Пример #23
0
 function lUserIDViaUserName($strUserName)
 {
     //---------------------------------------------------------------------
     //
     //---------------------------------------------------------------------
     $sqlStr = 'SELECT us_lKeyID
      FROM admin_users
      WHERE us_strUserName='******';';
     $query = $this->db->query($sqlStr);
     $numRows = $query->num_rows();
     if ($numRows == 0) {
         return null;
     } elseif ($numRows > 1) {
         screamForHelp($strUserName . ': duplicate user accounts detected!<br>error on line  <b> -- ' . __LINE__ . ' --</b>,<br>file ' . __FILE__ . ',<br>function ' . __FUNCTION__);
     } else {
         $row = $query->row();
         return (int) $row->us_lKeyID;
     }
 }
Пример #24
0
 public function xferImageDocViaEntryContextFID($enumEntryType, $enumContextType, $lNewFID, $lOldFID)
 {
     //---------------------------------------------------------------------
     // transfer images/documents from the old FID to the new FID
     //   * move to new directory (if required)
     //   * update database record to reflect change
     //---------------------------------------------------------------------
     $this->loadDocImageInfoViaEntryContextFID($enumEntryType, $enumContextType, $lOldFID);
     if ($this->lNumImageDocs == 0) {
         return;
     }
     $strNewPath = $this->strCatalogPath($enumContextType, $enumEntryType, $lNewFID);
     $strOldPath = $this->strCatalogPath($enumContextType, $enumEntryType, $lOldFID);
     foreach ($this->imageDocs as $imgDoc) {
         $lKeyID = $imgDoc->lKeyID;
         // move file if it directory changes
         if ($strNewPath != $strOldPath) {
             rename($strOldPath . '/' . $imgDoc->strSystemFN, $strNewPath . '/' . $imgDoc->strSystemFN);
             if (!is_null($imgDoc->strSystemThumbFN)) {
                 rename($strOldPath . '/' . $imgDoc->strSystemThumbFN, $strNewPath . '/' . $imgDoc->strSystemThumbFN);
             }
         }
         $sqlStr = "UPDATE docs_images\n            SET di_lForeignID={$lNewFID},\n               di_strPath=" . strPrepStr($strNewPath) . "\n            WHERE di_lKeyID = {$lKeyID};";
         $query = $this->db->query($sqlStr);
     }
 }
Пример #25
0
function strDBValueConvert_String($strValue)
{
    //---------------------------------------------------------------------
    //
    //---------------------------------------------------------------------
    if (is_null($strValue)) {
        $strValue = 'null';
    } else {
        $strValue = strPrepStr($strValue);
    }
    return $strValue;
}
function strLoadOptional_MY_mySQL($strDDL_Month, $strDDL_Year)
{
    //------------------------------------------------------------------
    //
    //------------------------------------------------------------------
    $lYear = (int) @$_REQUEST[$strDDL_Year];
    $lMonth = (int) @$_REQUEST[$strDDL_Month];
    if ($lYear <= 0 || $lMonth <= 0) {
        return 'NULL';
    }
    if (!bVerifyValidMonthDayYear($lMonth, 1, $lYear)) {
        return 'NULL';
    }
    return strPrepStr(str_pad($lYear, 4, '0', STR_PAD_LEFT) . '-' . str_pad($lMonth, 2, '0', STR_PAD_LEFT) . '-01');
}
Пример #27
0
    private function strSQLCommon(&$locRec)
    {
        //---------------------------------------------------------------------
        //
        //---------------------------------------------------------------------
        global $glUserID;
        //      $cRec = $this->locRec;
        return '
            ch_strChapterName   = ' . strPrepStr($locRec->strLocationName) . ',
            ch_strBannerTagLine = ' . strPrepStr($locRec->strBannerTagLine) . ',
            ch_strAddress1      = ' . strPrepStr($locRec->strAddress1) . ',
            ch_strAddress2      = ' . strPrepStr($locRec->strAddress2) . ',
            ch_strCity          = ' . strPrepStr($locRec->strCity) . ',
            ch_strState         = ' . strPrepStr($locRec->strState) . ',
            ch_strCountry       = ' . strPrepStr($locRec->strCountry) . ',
            ch_strZip           = ' . strPrepStr($locRec->strZip) . ',

            ch_strFax           = ' . strPrepStr($locRec->strFax) . ',
            ch_strPhone         = ' . strPrepStr($locRec->strPhone) . ',
            ch_strEmail         = ' . strPrepStr($locRec->strEmail) . ',
            ch_strWebSite       = ' . strPrepStr($locRec->strWebSite) . ',

            ch_strNotes         = ' . strPrepStr($locRec->strNotes) . ",\n\n            ch_lLastUpdateID    = {$glUserID} ";
    }
Пример #28
0
 public function lClientLocIDViaName($strName)
 {
     //---------------------------------------------------------------------
     //
     //---------------------------------------------------------------------
     $sqlStr = 'SELECT cl_lKeyID
      FROM client_location
      WHERE NOT cl_bRetired
         AND cl_strLocation=' . strPrepStr($strName) . ';';
     $query = $this->db->query($sqlStr);
     $numRows = $query->num_rows();
     if ($numRows == 0) {
         return null;
     } else {
         $row = $query->row();
         return (int) $row->cl_lKeyID;
     }
 }
 function updateTagEntry($strDDLEntry, $lDIT_ID)
 {
     //---------------------------------------------------------------------
     //
     //---------------------------------------------------------------------
     $sqlStr = 'UPDATE doc_img_tag_ddl
      SET
         dit_strDDLEntry = ' . strPrepStr($strDDLEntry) . "\n         WHERE dit_lKeyID={$lDIT_ID};";
     $query = $this->db->query($sqlStr);
 }
Пример #30
0
 private function strGrantsCommonSQL($grant)
 {
     //---------------------------------------------------------------------
     //
     //---------------------------------------------------------------------
     global $glUserID;
     return 'gr_strGrantName   = ' . strPrepStr($grant->strGrantName) . ',
      gr_strNotes       = ' . strPrepStr($grant->strNotes) . ',
      gr_lAttributedTo  = ' . (is_null($grant->lAttributedTo) ? 'NULL' : $grant->lAttributedTo) . ",\n         gr_lACO           = {$grant->lACO},\n         gr_lLastUpdateID  = {$glUserID}  ";
 }