Ejemplos de success_rank_insert en PHP

Ejemplo n.º 1

Archivo: price.php Proyecto: piece601/fund_execute

function update_fund($db = null, $fundeName = null)
{
    if ($db == null || $fundeName == null) {
        echo "請放入 db 以及 fundName \n";
        return;
    }
    $stmt = $db->prepare("SELECT * FROM price WHERE fundeName = ? ORDER BY priceId DESC limit 1");
    $stmt->execute([$fundeName]);
    // 本地最新資料
    $localNewest = $stmt->fetch();
    $query = spide($fundeName, $localNewest['date'], date("Y-m-d"));
    $dates = $query['dates'];
    $values = $query['values'];
    foreach ($dates as $key => $date) {
        // YYYYMMDD 轉成 YYYY-MM-DD
        $date = DateTime::createFromFormat('Ymd', $date)->format('Y-m-d');
        if ($localNewest['date'] < $date) {
            $stmt = $db->prepare("INSERT INTO price (fundeName, fundName, price, date) VALUES (?, ?, ?, ?)");
            $stmt->execute([$localNewest['fundeName'], $localNewest['fundName'], $values[$key], $date]);
            success_rank_insert($db, $localNewest['fundeName'], $date, '3');
            echo 'finish. ' . $localNewest['fundName'] . ' ' . $localNewest['fundeName'] . ' ' . $date . "\n";
        }
    }
    // echo "Update finish. \n";
}

Ejemplo n.º 2

Archivo: success_lib.php Proyecto: piece601/fund_execute

function success_batch($db, $fundeName = null, $years = null)
{
    if ($fundeName == null || $years == null) {
        echo '請輸入 db 以及 fundeName 以及 years' . "\n";
        return false;
    }
    // 抓出最老的資料
    $stmt = $db->prepare("SELECT * FROM price WHERE fundeName = ? ORDER BY priceId ASC LIMIT 1");
    $stmt->execute([$fundeName]);
    $data = $stmt->fetch();
    // 抓出要計算到最老資料的後幾年日期，避免未滿要求年數
    $limitYear = date('Y-m-d', strtotime(str_replace('-', '/', $data['date']) . '+' . $years . ' years'));
    // 抓出所有淨值
    $stmt = $db->prepare("SELECT * FROM price WHERE fundeName = ? ORDER BY priceId DESC");
    $stmt->execute([$fundeName]);
    $data = $stmt->fetchAll();
    foreach ($data as $key => $value) {
        // 達到最低計算日期就 break 換下一黨基金
        if ($value['date'] < $limitYear) {
            break;
        }
        // 檢查成功率表裡面是否已經有，有就 continue
        $stmt = $db->prepare("SELECT * FROM success WHERE fundeName = ? AND years = ? AND fundDate = ?");
        $stmt->execute([$fundeName, $years, $value['date']]);
        if (!empty($stmt->fetch())) {
            continue;
        }
        if (!success_rank_insert($db, $fundeName, $value['date'], $years)) {
            echo "此基金爆炸了 \n";
            break;
        }
        // 抓出這一段區間的所有淨值排序
        // $stmt = $db->prepare("SELECT * FROM price WHERE fundeName = ? AND date <= ? AND date > ? ORDER BY price DESC");
        // $stmt->execute([
        // 	$fundeName,
        // 	$value['date'],
        // 	date('Y-m-d',strtotime(str_replace('-', '/', $value['date']) . '-'.$years.' years'))
        // ]);
        // // 區間值
        // $intervalData = $stmt->fetchAll();
        // // 總數量
        // $total = count($intervalData);
        // $rank = 0;
        // foreach ($intervalData as $counter => $a) {
        // 	if ( $value['price'] == $a['price'] ) {
        // 		$rank = $counter + 1;
        // 		break;
        // 	}
        // }
        // $stmt = $db->prepare("INSERT INTO success (years, fundeName, fundName, fundDate, price, success_percent) VALUES (?, ?, ?, ?, ?, ?)");
        // $stmt->execute([
        // 	$years,
        // 	$value['fundeName'],
        // 	$value['fundName'],
        // 	$value['date'],
        // 	$value['price'],
        // 	(float) $rank / $total * 100
        // ]);
        // var_dump($value['date']);
        // $stmt = $db->prepare("SELECT * FROM price WHERE fundeName = ?");
        echo 'finish. ' . $value['fundName'] . ' ' . $value['fundeName'] . ' ' . $value['date'] . "\n";
    }
    echo $value['fundName'] . " All finish.\n";
}