' . PHP_EOL; $site_map_tmp .= '' . PHP_EOL; $site_map_tmp .= '' . PHP_EOL; $site_map_tmp .= 'https://www.globelus.pl/' . PHP_EOL; $site_map_tmp .= '' . date( 'Y-m-d' ) . '' . PHP_EOL; $site_map_tmp .= 'daily' . PHP_EOL; $site_map_tmp .= '1' . PHP_EOL; $site_map_tmp .= '' . PHP_EOL; $results = $mdb -> select( 'globelus_adverts', [ 'id', 'title', 'last_refresh', 'date_add' ], [ 'AND' => [ 'visible' => 1, 'disabled_by_admin' => 0, 'OR' => [ 'active_to' => null, 'active_to[>=]' => date( 'Y-m-d' ) ] ] ] ); foreach ( $results as $row ) { $site_map_tmp .= '' . PHP_EOL; $site_map_tmp .= 'https://www.globelus.pl/oferta/' . $row['id'] . '/' . \S::seo( $row['title'], true ) . '' . PHP_EOL; $site_map_tmp .= '' . ( $row['last_refresh'] ? date( 'Y-m-d', strtotime( $row['last_refresh'] ) ) : date( 'Y-m-d', strtotime( $row['date_add'] ) ) ) . '' . PHP_EOL; $site_map_tmp .= 'daily' . PHP_EOL; $site_map_tmp .= '1' . PHP_EOL; $site_map_tmp .= '' . PHP_EOL; } $site_map_tmp .= '' . PHP_EOL; $fp = fopen( '../sitemap-oferty-pracy.xml', 'w' ); fwrite( $fp, $site_map_tmp ); fclose( $fp ); $site_map_tmp = '' . PHP_EOL; $site_map_tmp .= '' . PHP_EOL; $site_map_tmp .= '' . PHP_EOL; $site_map_tmp .= 'https://www.globelus.pl/' . PHP_EOL; $site_map_tmp .= '' . date( 'Y-m-d' ) . '' . PHP_EOL; $site_map_tmp .= 'daily' . PHP_EOL; $site_map_tmp .= '1' . PHP_EOL; $site_map_tmp .= '' . PHP_EOL; $results = $mdb -> select( 'globelus_countries', [ 'id', 'name' ] ); foreach ( $results as $row ) { $site_map_tmp .= '' . PHP_EOL; $site_map_tmp .= 'https://www.globelus.pl/oferty-pracy/' . \S::seo( $row['name'], true ) . '' . PHP_EOL; $site_map_tmp .= '' . date( 'Y-m-d' ) . '' . PHP_EOL; $site_map_tmp .= 'daily' . PHP_EOL; $site_map_tmp .= '1' . PHP_EOL; $site_map_tmp .= '' . PHP_EOL; $site_map_tmp .= '' . PHP_EOL; $site_map_tmp .= 'https://www.globelus.pl/oferty-pracy/' . \S::seo( $row['name'], true ) . '/bez-jezyka' . PHP_EOL; $site_map_tmp .= '' . date( 'Y-m-d' ) . '' . PHP_EOL; $site_map_tmp .= 'daily' . PHP_EOL; $site_map_tmp .= '1' . PHP_EOL; $site_map_tmp .= '' . PHP_EOL; $site_map_tmp .= '' . PHP_EOL; $site_map_tmp .= 'https://www.globelus.pl/oferty-pracy/' . \S::seo( $row['name'], true ) . '/bez-doswiadczenia' . PHP_EOL; $site_map_tmp .= '' . date( 'Y-m-d' ) . '' . PHP_EOL; $site_map_tmp .= 'daily' . PHP_EOL; $site_map_tmp .= '1' . PHP_EOL; $site_map_tmp .= '' . PHP_EOL; $site_map_tmp .= '' . PHP_EOL; $site_map_tmp .= 'https://www.globelus.pl/oferty-pracy/' . \S::seo( $row['name'], true ) . '/dla-par' . PHP_EOL; $site_map_tmp .= '' . date( 'Y-m-d' ) . '' . PHP_EOL; $site_map_tmp .= 'daily' . PHP_EOL; $site_map_tmp .= '1' . PHP_EOL; $site_map_tmp .= '' . PHP_EOL; $site_map_tmp .= '' . PHP_EOL; $site_map_tmp .= 'https://www.globelus.pl/oferty-pracy/' . \S::seo( $row['name'], true ) . '/od-zaraz' . PHP_EOL; $site_map_tmp .= '' . date( 'Y-m-d' ) . '' . PHP_EOL; $site_map_tmp .= 'daily' . PHP_EOL; $site_map_tmp .= '1' . PHP_EOL; $site_map_tmp .= '' . PHP_EOL; } $site_map_tmp .= '' . PHP_EOL; $fp = fopen( '../sitemap-panstwa.xml', 'w' ); fwrite( $fp, $site_map_tmp ); fclose( $fp ); // if ( is_array( $available_domains ) and count( $available_domains ) ) // { // /* to do */ // } // else // { // $sitemap_tmp = $sitemap[ $url ]; // try { // $results = $mdb -> query( 'SELECT ' // . 'name_seo ' // . 'FROM ' // . 'globelus_adverts_categories AS gac' ) -> fetchAll( \PDO::FETCH_ASSOC ); // if ( is_array( $results ) and count( $results ) ) foreach ( $results as $row ) // { // $urls .= '' . PHP_EOL; // $urls .= '' . $domain_prefix . '://' . $www . $url . '/oferty-pracy/' . $row['name_seo'] . '' . PHP_EOL; // $urls .= 'weekly' . PHP_EOL; // $urls .= '1' . PHP_EOL; // $urls .= '' . PHP_EOL; // } // } // catch ( \Throwable $t ) { // \S::pre( $mdb -> error() ); // } // try { // $results = $mdb -> query( 'SELECT ' // . 'name_seo ' // . 'FROM ' // . 'globelus_countries AS gc' ) -> fetchAll( \PDO::FETCH_ASSOC ); // if ( is_array( $results ) and count( $results ) ) foreach ( $results as $row ) // { // $urls .= '' . PHP_EOL; // $urls .= '' . $domain_prefix . '://' . $www . $url . '/oferty-pracy/' . $row['name_seo'] . '' . PHP_EOL; // $urls .= 'weekly' . PHP_EOL; // $urls .= '1' . PHP_EOL; // $urls .= '' . PHP_EOL; // } // } // catch ( \Throwable $t ) { // \S::pre( $mdb -> error() ); // } // try { // $results = $mdb -> query( 'SELECT ' // . 'id, title ' // . 'FROM ' // . 'globelus_adverts AS ga ' // . 'WHERE ' // . 'visible = 1 ' // . 'AND ' // . '( active_to IS NULL OR active_to <= \'' . date( 'Y-m-d' ) . '\' )' ) -> fetchAll( \PDO::FETCH_ASSOC ); // if ( is_array( $results ) and count( $results ) ) foreach ( $results as $row ) // { // $urls .= '' . PHP_EOL; // $urls .= '' . $domain_prefix . '://' . $www . $url . '/oferta/' . $row['id'] . '/' . \S::seo( $row['title'], true ) . '' . PHP_EOL; // $urls .= 'weekly' . PHP_EOL; // $urls .= '1' . PHP_EOL; // $urls .= '' . PHP_EOL; // } // } // catch ( \Throwable $t ) { // \S::pre( $mdb -> error() ); // } // $sitemap_tmp = str_replace( '', $urls . '', $sitemap_tmp ); // $sitemap[ $url ] = $sitemap_tmp; // } return $sitemap; } }