コード例 #1
0
ファイル: PageController.php プロジェクト: vcorobceanu/WebAPL
 public function getImport()
 {
     $xsdstring = $_SERVER['DOCUMENT_ROOT'] . "/import.xml";
     $excel = new XML2003Parser($xsdstring);
     $table = $excel->getTableData();
     function mb_ucfirst($str, $enc = 'utf-8')
     {
         return mb_strtoupper(mb_substr($str, 0, 1, $enc), $enc) . mb_substr($str, 1, mb_strlen($str, $enc), $enc);
     }
     foreach ($table["table_contents"] as $row) {
         if (isset($row["row_contents"][2]) && isset($row["row_contents"][0])) {
             $id = $row["row_contents"][0]['value'];
             $value = trim(mb_ucfirst(mb_strtolower($row["row_contents"][2]['value'])));
             $postlang = PostLang::find($id);
             if ($postlang) {
                 $postlang->title = $value;
                 $postlang->uri = PostLang::uniqURI($id, $value);
                 $postlang->save();
             } else {
                 echo "undefined {$id} <br>";
             }
             //echo  "$id  $value<br><br><br>";
         }
     }
     return [];
 }
コード例 #2
0
ファイル: VarController.php プロジェクト: vcorobceanu/WebAPL
 public function getImport()
 {
     return [];
     $xsdstring = $_SERVER['DOCUMENT_ROOT'] . "/vars.xml";
     $excel = new XML2003Parser($xsdstring);
     $table = $excel->getTableData();
     $ids = [];
     foreach ($table["table_contents"] as $row) {
         if (isset($row["row_contents"][2]) && isset($row["row_contents"][0])) {
             $id = $row["row_contents"][0]['value'];
             if ($id && in_array($id, [84]) === FALSE) {
                 $value = htmlspecialchars_decode($row["row_contents"][2]['value']);
                 $varlang = VarLangModel::find($id);
                 if ($varlang) {
                     $varlang->value = $value;
                     if ($varlang->value !== $value && strlen(trim($varlang->value)) > 0) {
                         echo "DIFF [{$varlang->lang_id}] [{$varlang->id}] [[{$varlang->value}]] [[{$value}]]<br>\n";
                     }
                     if ($varlang->value !== $value && strlen(trim($varlang->value)) == 0) {
                         echo "CLEAR [{$varlang->lang_id}] [{$varlang->id}] [[{$varlang->value}]] [[{$value}]]<br>\n";
                     }
                     $varlang->save();
                 } else {
                     echo "interzis [{$varlang->lang_id}] {$id} {$varlang} <br>\n";
                 }
             } else {
                 echo "clear<br>\n";
             }
         }
     }
     return [];
 }