Funda/CreateHouseWPRealworks.php at master · jordivn/Funda · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
<?php

/**
 * @file
 *
 * @brief  Script for adding properties to WP from funda.
 *
 * @details
 *
 * @author 		Jordi van Nistelrooij @ Webs en Systems
 * @email 		info@websensystems.nl
 * @website		https://websensystems.nl
 * @version 	1.0.0
 * @date 		2021-01-11
 * @copyright 	Non of these scripts maybe copied or modified without permission of the authors
 *
 * @note
 * @todo
 * @bug
 */


if(isset($_REQUEST["FundaURL"])){
require_once("wp-config.php");

$arrayFunda = json_decode(file_get_contents("https://wes-server.nl/cdn/funda/fundaStripper.php?FundaURL=". $_REQUEST["FundaURL"]),true);
echo "<pre>";
print_r($arrayFunda);
echo "</pre>";


if(isset($_REQUEST["Status"])){
    $arrayFunda["Eigenschappen"]["Status"] = $_REQUEST["Status"];
}

file_put_contents("wp-content/uploads/Import/" . strtolower($arrayFunda["Woonplaats"] . "-" . $arrayFunda["Straat"] . "-" . $arrayFunda["Huisnummer"]) . "." . $arrayFunda["AfbeeldingType"] ,file_get_contents($arrayFunda["AfbeeldingLink"]));
$linkToImage = "https://www.leenaersmakelaardij.nl/wp-content/uploads/Import/" . strtolower($arrayFunda["Woonplaats"] . "-" . $arrayFunda["Straat"] . "-" . $arrayFunda["Huisnummer"]) . "." . $arrayFunda["AfbeeldingType"];
if ( ! function_exists( 'wp_crop_image' ) ) {
    include( ABSPATH . 'wp-admin/includes/image.php' );
}


$objMysqli = new mysqli(DB_HOST,DB_USER,DB_PASSWORD,DB_NAME);
$stringQuery = "INSERT INTO `".$table_prefix."posts` (
                     `post_author`,
                     `post_title`,
                     `post_name`,
                     `guid`,
                     `post_type`,
                     `post_content`,
                     `post_excerpt`,
                     `to_ping`,`pinged`,`post_content_filtered`) VALUES(
                     1,
                     '".$arrayFunda["Woonplaats"] . " - " . $arrayFunda["Straat"] . " " . $arrayFunda["Huisnummer"] ."',
                     '". strtolower($arrayFunda["Woonplaats"] . "-" . $arrayFunda["Straat"] . "-" . $arrayFunda["Huisnummer"]) ."',
                     'https://leenaersmakelaardij.nl/woning/". str_replace(" ","-",strtolower($arrayFunda["Woonplaats"] . "-" . $arrayFunda["Straat"] . "-" . $arrayFunda["Huisnummer"])) ."/',
                     'realworks_wonen',
                     '".$objMysqli->real_escape_string($arrayFunda["Omschrijving"])."',
                     '',
                     '',
                     '','')";
$objMysqli->query($stringQuery);
$id = $objMysqli->insert_id;

$stringQuery = "INSERT INTO `".$table_prefix."posts` (
    `post_author`,
    `post_title`,
    `post_name`,
    `guid`,
    `post_type`,
    `post_content`,
    `post_excerpt`,
    `to_ping`,`pinged`,`post_content_filtered`,`post_mime_type`,`post_parent`,`post_status`) VALUES(
    1,
    'Foto ". strtolower($arrayFunda["Woonplaats"] . "-" . $arrayFunda["Straat"] . "-" . $arrayFunda["Huisnummer"]) ."',
    'foto-". strtolower($arrayFunda["Woonplaats"] . "-" . $arrayFunda["Straat"] . "-" . $arrayFunda["Huisnummer"]) ."',
    '".$linkToImage."',
    'attachment',
    '',
    '',
    '',
    '','','" . mime_content_type("wp-content/uploads/Import/" . strtolower($arrayFunda["Woonplaats"] . "-" . $arrayFunda["Straat"] . "-" . $arrayFunda["Huisnummer"]) . "." . $arrayFunda["AfbeeldingType"]) . "',
    ".$id.",'inherit')";

$objMysqli->query($stringQuery);
$idFoto = $objMysqli->insert_id;

$stringQuery = "INSERT INTO `".$table_prefix."postmeta` (
    `post_id`,
    `meta_key`,
    `meta_value`) VALUES(
        ".$idFoto.",
        '_wp_attached_file',
        'Import/" . strtolower($arrayFunda["Woonplaats"] . "-" . $arrayFunda["Straat"] . "-" . $arrayFunda["Huisnummer"]) . "." . $arrayFunda["AfbeeldingType"]."')";
$objMysqli->query($stringQuery);

wp_generate_attachment_metadata( $idFoto, "wp-content/uploads/Import/" . strtolower($arrayFunda["Woonplaats"] . "-" . $arrayFunda["Straat"] . "-" . $arrayFunda["Huisnummer"]) . "." . $arrayFunda["AfbeeldingType"] );

$stringQuery = $stringQuery = "INSERT INTO `".$table_prefix."postmeta` (
    `post_id`,
    `meta_key`,
    `meta_value`) VALUES(
        ".$id.",
        '_thumbnail_id',
        ".$idFoto.")";
$objMysqli->query($stringQuery);


//echo $stringQuery;


$stringQuery = "INSERT INTO `".$table_prefix."realworks_wonen` (
                                `wordpress_id`,
                                `adres`,
                                `plaats`,
                                `koopprijsVoorvoegsel`,
                                `koopprijs`,
                                `koopconditie`,
                                `datumInvoer`,
                                `status`,
                                `prijsTonen`) VALUES(
                                 ".$id.",
                                 '" . $arrayFunda["Straat"] . " " . $arrayFunda["Huisnummer"] ."',
                                 '". $arrayFunda["Woonplaats"]."',
                                 'vraagprijs',
                                 ".str_replace(".","",$arrayFunda["Prijs"]).",
                                 '".$arrayFunda["PrijsConditie"]."',
                                 NOW(),
                                 '".$arrayFunda["Eigenschappen"]["Status"]."',
                                 1)";
$objMysqli->query($stringQuery);
$stringQuery = "INSERT INTO `".$table_prefix."realworks_wonen_adresNederlands` (
                                 `parent_id`,
                                 `straatnaam`,
                                 `huisnummer`,
                                 `postcode`,
                                 `plaats`,
                                 `land`) VALUES(
                                ".$id.",
                                '" . $arrayFunda["Straat"] . "',
                                " . $arrayFunda["Huisnummer"] . ",
                                '" . $arrayFunda["Postcode"] . "',
                                '" . $arrayFunda["Woonplaats"] . "',
                                'NL')";
$objMysqli->query($stringQuery);
//echo $stringQuery;

echo "Imported";
}else{
    ?>
    <br/>
    <form >
            <input name=FundaURL placeholder=FundaURL>'
            <select name=Status>
                <option value=NULL>
                <option value=Verkocht>Verkocht
                <option value=Aangekocht>Aangekocht
            </select>
            <input type=submit>
        </form>
        <?PHP

    }
?>