comparison: www/import/from_brouwhulp.php
www/import/from_brouwhulp.php
- changeset 119
- ae5e8d740173
- parent 118
- 07daa505d309
- child 121
- 875aeb365e1c
equal
deleted
inserted
replaced
| 118:07daa505d309 | 119:ae5e8d740173 |
|---|---|
| 972 $svg = 77; | 972 $svg = 77; |
| 973 $colorw = 0; | 973 $colorw = 0; |
| 974 $stage = "Plan"; // Default value. | 974 $stage = "Plan"; // Default value. |
| 975 $uuid = str_replace("\n", "", file_get_contents('/proc/sys/kernel/random/uuid')); | 975 $uuid = str_replace("\n", "", file_get_contents('/proc/sys/kernel/random/uuid')); |
| 976 | 976 |
| 977 $psql = "INSERT INTO prod_main SET uuid='" . $uuid; // So we can link the records. | 977 $psql = "INSERT INTO prod_main SET puuid='" . $uuid; // So we can link the records. |
| 978 $rsql = "INSERT INTO prod_recipes SET uuid='" . $uuid; | 978 $rsql = "INSERT INTO prod_recipes SET uuid='" . $uuid; |
| 979 | 979 |
| 980 $psql .= "', name='" . mysqli_real_escape_string($db, $recipe->NAME); | 980 $psql .= "', pname='" . mysqli_real_escape_string($db, $recipe->NAME); |
| 981 $rsql .= "', name='" . mysqli_real_escape_string($db, $recipe->NAME); | 981 $rsql .= "', name='" . mysqli_real_escape_string($db, $recipe->NAME); |
| 982 | 982 |
| 983 if ($recipe->NOTES) { | 983 if ($recipe->NOTES) { |
| 984 $rsql .= "', notes='" . mysqli_real_escape_string($db, $recipe->NOTES); // Duplicate the notes | 984 $rsql .= "', notes='" . mysqli_real_escape_string($db, $recipe->NOTES); // Duplicate the notes |
| 985 $psql .= "', notes='" . mysqli_real_escape_string($db, $recipe->NOTES); | 985 $psql .= "', pnotes='" . mysqli_real_escape_string($db, $recipe->NOTES); |
| 986 } else { | 986 } else { |
| 987 $rsql .= "', notes='"; | 987 $rsql .= "', notes='"; |
| 988 $psql .= "', notes='"; | 988 $psql .= "', pnotes='"; |
| 989 } | 989 } |
| 990 if ($recipe->TYPE) | 990 if ($recipe->TYPE) |
| 991 $rsql .= "', type='" . mysqli_real_escape_string($db, $recipe->TYPE); | 991 $rsql .= "', type='" . mysqli_real_escape_string($db, $recipe->TYPE); |
| 992 else | 992 else |
| 993 $rsql .= "', type='"; | 993 $rsql .= "', type='"; |
| 1319 $psql .= "', taste_aftertaste='" . mysqli_real_escape_string($db, $recipe->TASTE_AFTERTASTE); | 1319 $psql .= "', taste_aftertaste='" . mysqli_real_escape_string($db, $recipe->TASTE_AFTERTASTE); |
| 1320 } | 1320 } |
| 1321 | 1321 |
| 1322 ($recipe->INVENTORY_REDUCED == 'TRUE') ? $psql .= "', inventory_reduced='1" : $psql .= "', inventory_reduced='0"; | 1322 ($recipe->INVENTORY_REDUCED == 'TRUE') ? $psql .= "', inventory_reduced='1" : $psql .= "', inventory_reduced='0"; |
| 1323 if (($recipe->LOCKED == 'TRUE') && ($stage == 'Ready')) { | 1323 if (($recipe->LOCKED == 'TRUE') && ($stage == 'Ready')) { |
| 1324 $psql .= "', locked='1"; | 1324 $psql .= "', plocked='1"; |
| 1325 $rsql .= "', locked='1"; | 1325 $rsql .= "', locked='1"; |
| 1326 $stage = "Closed"; | 1326 $stage = "Closed"; |
| 1327 } else { | 1327 } else { |
| 1328 $psql .= "', locked='0"; | 1328 $psql .= "', plocked='0"; |
| 1329 $rsql .= "', locked='0"; | 1329 $rsql .= "', locked='0"; |
| 1330 } | 1330 } |
| 1331 | 1331 |
| 1332 $psql .= "', stage='" . $stage; | 1332 $psql .= "', stage='" . $stage; |
| 1333 // echo ' '.$brewdate.' '.$recipe->NR_RECIPE.' '.$stage . PHP_EOL; | 1333 // echo ' '.$brewdate.' '.$recipe->NR_RECIPE.' '.$stage . PHP_EOL; |
