/**
* Execute the console command.
*
* @return mixed
*/
public function fire()
{
$market = $this->argument('market');
$fileName = storage_path() . '/app/' . time() . '.xls';
file_put_contents($fileName, $this->getHtmlContent($this->argument('url')));
$reader = PHPExcel_IOFactory::createReader('Excel5');
$excel = $reader->load($fileName);
$sheet = $excel->getSheet();
$i = 2;
while ($sheet->getCell("A{$i}") != "") {
$code = $sheet->getCell("B{$i}");
$name = $sheet->getCell("C{$i}");
$issue = Issue::where('code', $code)->first();
if (!$issue) {
$issue = new Issue();
}
$issue->code = $code;
$issue->name = $name;
$issue->market = $market;
if ($issue->getOriginal() != $issue->getAttributes()) {
$issue->save();
}
$i++;
}
unlink($fileName);
}
/**
* Display the specified resource.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
public function file($id)
{
$issue = Issue::where('id', '=', $id)->pluck('title');
//dd($issue);
$files = File::whereissue_id($id)->get();
return view('public_journal.file', compact('files', 'issue'));
}
public function index(GetIssueOfAreaRequest $request)
{
$areaID = $request->input('areaID');
$role = $request->input('role');
$area = Area::findOrFail($areaID);
$issues = Issue::where('areaID', $areaID)->available()->get();
return view('_partials.issues.lists', compact('issues', 'area', 'role'))->render();
}
public function addvote(Request $request)
{
$current_issue = Issue::where("id", "=", $request->issue_id)->get()->first();
$votes = $current_issue->total_votes;
$votes++;
$current_issue->total_votes = $votes;
$current_issue->save();
return $current_issue->total_votes;
}
/**
* Get the list of issues in a sprint by issue status
* @param string $issueStatusMachineName
* @param int $sprintId
*/
public static function getIssuesInSprintByIssueStatus($issueStatusMachineName, $sprintId)
{
$statusId = IssueStatus::getIdByMachineName($issueStatusMachineName);
if ($statusId) {
return Issue::where('sprint_id', '=', $sprintId)->where('status_id', '=', $statusId)->get();
} else {
return false;
}
}
private function crawlYahoo($baseUrl, $kind)
{
$today = date('Y-m-d');
$yesterday = date('Y-m-d', strtotime((date('N') == 1 ? '-3' : '-1') . ' day'));
//max page
$html = $this->getHtmlContent($baseUrl . '1');
preg_match('#<ul class="ymuiPagingBottom.*?</ul>#ms', $html, $matches);
preg_match_all('#<a.*?>([0-9]+)</a>#ms', $matches[0], $matches);
$maxPage = $matches[1][count($matches[1]) - 1];
$order = 0;
for ($i = 1; $i <= $maxPage; $i++) {
$html = $this->getHtmlContent($baseUrl . $i);
preg_match_all('#<tr class="rankingTabledata yjM">.*?</tr>#ms', $html, $matches);
foreach ($matches[0] as $row) {
$order++;
preg_match('#<a.*?>(.*?)</a>#ms', $row, $matchesTemp);
$issue = Issue::where('code', $matchesTemp[1])->first();
if (!$issue) {
continue;
}
$stockPriceInfo = StockPriceInfo::where('issue_id', $issue->id)->where('acquire_at', $yesterday)->first();
preg_match('#<td class="txtright">(.*?)</td>#ms', $row, $matchesTemp);
if ($kind == '75') {
$stockPriceInfo->average_75days = str_replace(',', '', $matchesTemp[1]);
} elseif ($kind == '25') {
$stockPriceInfo->average_25days = str_replace(',', '', $matchesTemp[1]);
}
$stockPriceInfo->save();
if ($kind == '75') {
preg_match('#<td class="txtright bold">(.*?)</td>#ms', $row, $matchesTemp);
$ranking75LowDiremption = new Ranking75LowDiremption();
$ranking75LowDiremption->acquire_at = $today;
$ranking75LowDiremption->order = $order;
$ranking75LowDiremption->issue_id = $issue->id;
$ranking75LowDiremption->price = str_replace(',', '', $matchesTemp[1]);
$ranking75LowDiremption->save();
}
}
}
}
public function changeissuestatus(Request $request)
{
$current_issue = Issue::where("id", "=", $request->issue_id)->get()->first();
$current_issue->is_public = $request->status;
$current_issue->save();
return $current_issue->is_public;
}
/**
* Return a view to display issue search results for a given query
*/
public function search(IssueSearchRequest $request)
{
$query = trim(strip_tags($request->get('query')));
$issues = Issue::where('title', 'LIKE', "%{$query}%")->get();
$issues->each(function ($issue) {
$issue->id = (int) $issue->id;
$issue->projectName = Project::find($issue->project_id)->name;
$issue->statusLabel = IssueStatus::find($issue->status_id)->label;
$issue->typeLabel = IssueType::find($issue->type_id)->label;
unset($issue->project_id);
unset($issue->status_id);
unset($issue->type_id);
});
return view('issues.searchresults')->with(['issues' => $issues, 'query' => $query]);
}
public function generate($id)
{
ini_set("max_execution_time", 0);
$project = Project::find($id);
$accomplishments = Accomplishment::where('project_id', $id)->get();
$actions = Action::where('project_id', $id)->get();
$expenses = Expense::where('project_id', $id)->get();
$issues = Issue::where('project_id', $id)->get();
$milestones = Milestone::where('project_id', $id)->get();
$risks = Risk::where('project_id', $id)->get();
$lastUser = $project->users->last();
return view('projects.generate', compact('project', 'actions', 'accomplishments', 'expenses', 'issues', 'milestones', 'risks', 'lastUser'));
}
