/*
     * Update старых анкет
     */
    public function actionUpdateWorksheet () {
        $box = new InternalBox('fkr');

        // все анкеты
        $oldWorksheet = array();
        foreach (self::$allowedToExport as $template) {
            if ($template != 'buildCity' && $template != 'documentation') {
                $oldWorksheet = array_merge($oldWorksheet, self::getNewDocs($template));
            }
        }

        // выборка работ по связи через график
        $scheduleInspectionExtId = array();
        foreach ($oldWorksheet as $worksheet) {
            $scheduleInspectionExtId[] = $worksheet['data']['info']['scheduleInspectionExtId'];
        }
        $scheduleInspectionExtId = array_unique($scheduleInspectionExtId);

        $workList = array();
        foreach ($scheduleInspectionExtId as $extId) {
            $workList[$extId] = $box->findAllDocuments(array(
                'template' => 'work',
                'data.scheduleInspectionExtId' => $extId
            ));
        }


        $successfully = 0;
        $haveWorkId = 0;
        $alarm = array();

        // ищем связи, обновляем документ
        foreach ($oldWorksheet as $worksheet) {
            if (empty($worksheet['data']['info']['workId'])) {
                $flag = false;
                foreach ($workList[$worksheet['data']['info']['scheduleInspectionExtId']] as $work) {
                    if ($work['data']['workType'] == $worksheet['template']) {
                        //echo "check\n";
                        $flag = true;
                        $worksheet['data']['info']['workId'] = $work['extId'];
                        $box->saveDocument($worksheet);
                        $successfully++;
                        break;
                    }
                }
                if (!$flag) {
                    $alarm[] = $worksheet;
                }
            } else {
                $haveWorkId++;
            }
        }

        $check =  count($oldWorksheet)  - $haveWorkId; // убираем из подсчета анкеты уже имевшие IDшник
        echo "result = " . $successfully .  ' / ' . $check . PHP_EOL;

        /*foreach ($alarm as $work) {
            echo $work['id'] . PHP_EOL;
        }*/


        exit();
    }