I.T. Co. Has Performed an Integrated Project at the Frito Lay Plant


I.T. Co. Has Performed an Integrated Project at the Frito Lay Plant
I.T. Co. has implemented at the Frito Lay Manufacturing Ltd. (Kashir, Moscow oblast’) a unique solution that integrates cafeteria management and access control system into the corporate SAP R/3.

Frito Lay Manufacturing Ltd. is a division of PepsiCo, Inc. and also the world and Russia leader in salted snacks production and sales. The requirements, namely: a higher security level, food allowance, and working hours control, arise from the company’s goals. To achieve these goals, in early 2008 the company management chose I.T. Co. to provide a complex integrated solution that would comprise a control and access management system (CAMS), an cafeteria management automation system, and SAP R/3, which the customer already had experience of using.

The work began in late August last year, with implementing the CAMS. The solution ensures sanctioned entering the plant territory and makes it possible to control access to the special premises in various buildings. According to the customer's requirements, the CAMS features functionality that provides automatic hourly reports to the administrator on staff members and visitors' locations on the plant territory. This allows to strictly monitor the actual hours worked, which, in its turn, results in lower expenses and more transparency when calculating the salaries. The system stores data on personnel and visitors' locations on the plant territory, and, if required, permits to quickly find the person in question, also in case of emergency.

The automatic cafeteria management ensures high speed of service, accounting and control as well as cash receipts. Besides, automatic allowance accounting makes it much easier to calculate the taxes.

Proximity smart cards are used as a unified identifier for entering the plant territory, the buildings, and the cafeteria.

As part of the project, I.T.Co. has contributed to modernizing the plant's IT infrastructure according to the up-to-date requirements. Computing machinery has been supplied to the plant to ensure the required productivity.

Alexander Kostikov, communication director of PepsiCo Russia: “The new integrated solution has resulted in faster and more accurate allowance accounting, much better security, lower costs of calculating and paying the salaries, and better general and production discipline.”

Module: advertising
Class: CAdvBanner
File: /var/www/bitrix/modules/advertising/classes/mysql/advertising.php
Function: GetPageWeights_RS
Line: 943
MySQL Query Error: SELECT DISTINCT B.TYPE_SID, B.ID BANNER_ID, B.WEIGHT BANNER_WEIGHT, B.SHOWS_FOR_VISITOR, B.FIX_CLICK, B.FIX_SHOW, B.KEYWORDS BANNER_KEYWORDS, DATE_FORMAT(B.DATE_SHOW_FIRST, '%d.%m.%Y %H:%i:%s') DATE_SHOW_FIRST, DATE_FORMAT(B.DATE_SHOW_FROM, '%d.%m.%Y %H:%i:%s') DATE_SHOW_FROM, DATE_FORMAT(B.DATE_SHOW_TO, '%d.%m.%Y %H:%i:%s') DATE_SHOW_TO, B.FLYUNIFORM FLYUNIFORM, B.MAX_SHOW_COUNT MAX_SHOW_COUNT, B.SHOW_COUNT SHOW_COUNT, C.ID CONTRACT_ID, C.WEIGHT CONTRACT_WEIGHT, C.KEYWORDS CONTRACT_KEYWORDS FROM b_adv_type T INNER JOIN b_adv_banner B ON ( B.ACTIVE='Y' and B.TYPE_SID = T.SID and B.STATUS_SID = 'PUBLISHED' and (B.FOR_NEW_GUEST is null or B.FOR_NEW_GUEST='Y') and (ifnull(B.MAX_SHOW_COUNT,0)>ifnull(B.SHOW_COUNT,0) or ifnull(B.MAX_SHOW_COUNT,0)=0) and (ifnull(B.MAX_CLICK_COUNT,0)>ifnull(B.CLICK_COUNT,0) or ifnull(B.MAX_CLICK_COUNT,0)=0) and (ifnull(B.MAX_VISITOR_COUNT,0)>ifnull(B.VISITOR_COUNT,0) or ifnull(B.MAX_VISITOR_COUNT,0)=0) and (B.DATE_SHOW_FROM<=now() or B.DATE_SHOW_FROM is null or length(B.DATE_SHOW_FROM)<=0) and (B.DATE_SHOW_TO>=now() or B.DATE_SHOW_TO is null or length(B.DATE_SHOW_TO)<=0)) INNER JOIN b_adv_banner_2_site BS ON ( BS.BANNER_ID = B.ID and BS.SITE_ID = 'en') INNER JOIN b_adv_contract C ON ( C.ID = B.CONTRACT_ID and C.ACTIVE='Y' and (ifnull(C.MAX_SHOW_COUNT,0)>ifnull(C.SHOW_COUNT,0) or ifnull(C.MAX_SHOW_COUNT,0)=0) and (ifnull(C.MAX_CLICK_COUNT,0)>ifnull(C.CLICK_COUNT,0) or ifnull(C.MAX_CLICK_COUNT,0)=0) and (ifnull(C.MAX_VISITOR_COUNT,0)>ifnull(C.VISITOR_COUNT,0) or ifnull(C.MAX_VISITOR_COUNT,0)=0) and (C.DATE_SHOW_FROM<=now() or C.DATE_SHOW_FROM is null or length(C.DATE_SHOW_FROM)<=0) and (C.DATE_SHOW_TO>=now() or C.DATE_SHOW_TO is null or length(C.DATE_SHOW_TO)<=0)) INNER JOIN b_adv_contract_2_site CS ON ( CS.CONTRACT_ID = B.CONTRACT_ID and CS.SITE_ID = 'en') INNER JOIN b_adv_contract_2_type CT ON ( CT.CONTRACT_ID = C.ID and (CT.TYPE_SID = 'ALL' or CT.TYPE_SID = T.SID)) INNER JOIN b_adv_banner_2_weekday BW ON ( BW.BANNER_ID = B.ID and BW.C_WEEKDAY='FRIDAY' and BW.C_HOUR = '7') INNER JOIN b_adv_contract_2_weekday CW ON ( CW.CONTRACT_ID = C.ID and CW.C_WEEKDAY='FRIDAY' and CW.C_HOUR = '7') LEFT JOIN b_adv_banner_2_group UG1 ON ( (UG1.BANNER_ID = B.ID and UG1.GROUP_ID in (2) and UG1.GROUP_ID<>2) ) LEFT JOIN b_adv_banner_2_page BP1 ON ( BP1.BANNER_ID = B.ID and BP1.SHOW_ON_PAGE='Y') LEFT JOIN b_adv_banner_2_page BP2 ON ( BP2.BANNER_ID = B.ID and BP2.SHOW_ON_PAGE='N' and '/en/media-center/news/3768/index.php' like concat(BP2.PAGE, '%')) LEFT JOIN b_adv_contract_2_page CP1 ON ( CP1.CONTRACT_ID = C.ID and CP1.SHOW_ON_PAGE='Y') LEFT JOIN b_adv_contract_2_page CP2 ON ( CP2.CONTRACT_ID = C.ID and CP2.SHOW_ON_PAGE='N' and '/en/media-center/news/3768/index.php' like concat(CP2.PAGE, '%')) LEFT JOIN b_adv_banner_2_stat_adv BA ON BA.BANNER_ID = B.ID LEFT JOIN b_adv_banner_2_country BC ON BC.BANNER_ID = B.ID AND ( ( (B.STAT_TYPE is null OR length(B.STAT_TYPE)=0 OR B.STAT_TYPE='COUNTRY') AND BC.COUNTRY_ID='' ) OR ( B.STAT_TYPE='REGION' AND BC.COUNTRY_ID='' AND BC.REGION='' ) OR ( B.STAT_TYPE='CITY' AND BC.CITY_ID='0' ) ) WHERE T.ACTIVE = 'Y' and ( B.STAT_COUNT is null or B.STAT_COUNT = 0 or BC.BANNER_ID is not null ) and BP2.ID is null and CP2.ID is null and (BP1.ID is null or '/en/media-center/news/3768/index.php' like concat(BP1.PAGE, '%')) and (CP1.ID is null or '/en/media-center/news/3768/index.php' like concat(CP1.PAGE, '%')) and (BA.STAT_ADV_ID is null or BA.STAT_ADV_ID='0') and (BC.COUNTRY_ID is null or BC.COUNTRY_ID='') and ( (B.SHOW_USER_GROUP = 'Y' and UG1.GROUP_ID is not null) or (B.SHOW_USER_GROUP <> 'Y' and UG1.GROUP_ID is null) ) ORDER BY B.TYPE_SID desc, C.ID desc [Got error 28 from storage engine]

DB query error.
Please try later.