function getBirthReportSQL($planets, $asc_data)
{
$query = array();
$query[] = 'SELECT CONCAT(content_type, planet_id, object_id) AS id, content_type, planet_id, object_id, content FROM birth_report WHERE ';
// First include ASC
$query[] = '(content_type = 2 AND object_id = ' . $asc_data['sign_number'] . ' AND planet_id = 11)';
foreach ($planets as $planet => $data) {
if ($planet == 'Ketu') {
continue;
}
$planetId = getPlanetIdByName($planet);
$h1 = $data['house'];
$h2 = $data['sign_number'];
$query[] = ' OR ';
$query[] = "(content_type = 1 AND object_id = {$h1} AND planet_id = {$planetId})";
$query[] = ' OR ';
$query[] = "(content_type = 2 AND object_id = {$h2} AND planet_id = {$planetId})";
}
return join('', $query);
}
require_once 'solar_chart.php5';
require_once 'planet.php5';
require_once TEMPLATEPATH . '/include/classes/transit.php5';
require_once TEMPLATEPATH . '/include/classes/astroreport.php5';
//list($month, $numday, $year, $fullmonth, $dow, $hours, $am_pm) = split('[/.-]', date("m.d.Y.F.w.g.a"));
$aa = new AstroReport(26.5, 'N', 75.5, 'E', $day, $month, $year, $hour, $minutes, $amORpm, 5.5);
//$aa = new AstroReport(28.36, 'N', 77.12, 'E', 5, 1, 1987, 1, 50, 'am', 5.5); //khushi
//$aa = new AstroReport(26.5, 'N', 75.5, 'E', 21, 11, 1983, 9, 33, 'pm', 5.5); //Nidhi
//$aa = new AstroReport(28.36, 'N', 77.12, 'E', 28, 8, 1985, 7, 00, 'pm', 5.5); //ahuja
//$aa = new AstroReport(23.16, 'N', 77.24, 'E', 30, 10, 1985, 9, 30, 'am', 5.5); //gupta
//$aa = new AstroReport(28.36, 'N', 77.12, 'E', 6, 2, 1987, 6, 15, 'pm', 5.5); //ishani ahuja
$houses = $aa->getHouses();
$planets = $aa->getPlanets();
var_dump($houses);
foreach ($planets as $planet => $data) {
$planetId = getPlanetIdByName($planet);
$h = $data['house'];
$getContentHouses = mysql_query("SELECT content FROM birth_report WHERE content_type = 1 AND object_id = {$h} AND planet_id = {$planetId}", $link);
$row = mysql_fetch_row($getContentHouses);
echo '<strong>' . $planet . ' is in ' . $h . ' House.</strong>';
echo "<p>{$row['0']}</p>";
//echo "<p>SELECT content FROM birth_report WHERE content_type = 1 AND object_id = $h AND planet_id = $planetId</p>";
$h = $data['sign_number'];
$getContentZodiacSigns = mysql_query("SELECT content FROM birth_report WHERE content_type = 2 AND object_id = {$h} AND planet_id = {$planetId}", $link);
$row = mysql_fetch_row($getContentZodiacSigns);
echo '<strong>' . $planet . ' is in ' . $data['sign'] . '</strong>';
echo "<p>{$row['0']}</p>";
//echo "<p>SELECT content FROM birth_report WHERE content_type = 2 AND object_id = $h AND planet_id = $planetId</p><hr />";
echo '<hr />';
}
function getPlanetIdByName($name)
