PHP check_horse Examples

Example #1

<?php

session_start();
if (!isset($_SESSION['authuser']) || !isset($_GET['target_id']) || !isset($_GET['product_id'])) {
    exit;
}
require_once "./include/config.inc";
require_once "./horse_inc.php";
$target_id = $_GET['target_id'];
$product_id = $_GET['product_id'];
$rt = array('query_status' => 0, 'query_msg' => '');
$rt = check_horse($product_id);
if ($rt['query_status'] == 1) {
    echo json_encode($rt);
    exit;
}
$rt = sync_horse($target_id, $product_id);
$horse = get_horse($target_id, $product_id);
if (isset($_GET['action']) && $_GET['action'] == 'start_horse') {
    $sql = sprintf("UPDATE horse, workflow_object \n\t\t\t\t\t\tSET horse.start_time = now(), workflow_object.status = %d, workflow_object.start_time = now() \n\t\t\t\t\t\tWHERE workflow_object.id = %d AND horse.workflow_object_id = workflow_object.id", STARTED, $horse['workflow_object_id']);
    $st = mysql_query($sql);
    $rt['query_status'] = $st ? 0 : 1;
    $rt['start_sql'] = $sql;
    $rt['query_msg'] = $st ? 'Horse started' : 'Error starting horse:' . mysql_error();
    if ($rt['query_status'] == 0) {
        $rt['horse'] = '<img src="./images/play-disabled.png" />&nbsp;
							<img src="./images/stop.png" onClick="stop_horse($(this).parent());" />&nbsp;
							<img src="./images/eject.png" onClick="cancel_horse($(this).parent());" />&nbsp;';
    }
    echo json_encode($rt);
    exit;

Example #2

if (!isset($_GET['workflow_id'])) {
    exit;
}
require_once "include/config.inc";
require_once "horse_inc.php";
$workflow_id = $_GET['workflow_id'];
function get_out($status, $msg, $sql, $error)
{
    $rt = array('status' => $status, 'query_msg' => $msg, 'sql' => $sql, 'error' => $error);
    echo json_encode($rt);
    exit;
}
// get all products that are using this workflow
$sql = "SELECT * FROM product WHERE workflow_id = " . $workflow_id;
$st = mysql_query($sql);
while ($product = mysql_fetch_assoc($st)) {
    $check_rt = check_horse($product['id']);
    if ($check_rt['query_status'] == 1) {
        echo json_encode($check_rt);
        exit;
    }
    $p_sql = sprintf("SELECT * FROM horse WHERE product_id = %d", $product['id']);
    $p_st = mysql_query($p_sql);
    while ($pt = mysql_fetch_assoc($p_st)) {
        $sync = sync_horse($pt['target_id'], $pt['product_id']);
        if ($sync['query_status'] == 1) {
            get_out(1, "Error sync workflow for product [" . $product['name'] . "] ", '', $sync['query_msg']);
        }
    }
}
get_out(0, "All products using this workflow have been synced", '', '');