public function admin() {
if ($this->is_back()) {
$this->parent->reset();
}
Base_ActionBarCommon::add('back', __('Back'), $this->create_back_href());
$google_login = Variable::get('utils_attachments_google_user', false);
$google_pass = Variable::get('utils_attachments_google_pass', false);
$form = $this->init_module('Libs_QuickForm');
$theme = $this->init_module('Base_Theme');
$form->addElement('header', 'header', __('Google Username and Password'));
$form->addElement('text', 'google_user', __('Username'));
$form->addElement('password', 'google_pass', __('Password'));
$form->setDefaults(array('google_user'=>$google_login));
$form->setDefaults(array('google_pass'=>$google_pass));
if ($form->validate()) {
$vals = $form->exportValues();
$ok = true;
if ($vals['google_user']) {
$g_auth = Utils_AttachmentCommon::get_google_auth($vals['google_user'], $vals['google_pass']);
if (!$g_auth) $ok = false;
}
if ($ok) {
Variable::set('utils_attachments_google_user', $vals['google_user']);
Variable::set('utils_attachments_google_pass', $vals['google_pass']);
Base_StatusBarCommon::message(__('Settings saved'));
} else {
Base_StatusBarCommon::message(__('Unable to authenticate'), 'error');
}
location(array());
return;
}
$form->assign_theme('form', $theme);
Base_ActionBarCommon::add('back', __('Back'), $this->create_back_href());
Base_ActionBarCommon::add('save', __('Save'), $form->get_submit_form_href());
Base_ThemeCommon::load_css('Utils_RecordBrowser','View_entry');
$theme->display('admin');
}
public static function discard_google_docs($note_id) {
$edit_url = DB::GetOne('SELECT doc_id FROM utils_attachment_googledocs WHERE note_id = %d', array($note_id));
DB::Execute('DELETE FROM utils_attachment_googledocs WHERE note_id = %d', array($note_id));
$g_auth = Utils_AttachmentCommon::get_google_auth();
$curl = curl_init();
curl_setopt($curl, CURLOPT_HTTPAUTH, CURLAUTH_ANY);
curl_setopt($curl, CURLOPT_SSL_VERIFYPEER, false);
curl_setopt($curl, CURLOPT_RETURNTRANSFER, 1);
$headers = array(
"Authorization: GoogleLogin auth=" . $g_auth,
"If-Match: *",
"GData-Version: 3.0",
);
curl_setopt($curl, CURLOPT_URL, $edit_url);
curl_setopt($curl, CURLOPT_CUSTOMREQUEST, 'DELETE');
curl_setopt($curl, CURLOPT_HTTPHEADER, $headers);
curl_setopt($curl, CURLOPT_POST, false);
$response = curl_exec($curl);
Base_StatusBarCommon::message(__('Changes discarded'));
}
$t = time();
$remote_address = $_SERVER['REMOTE_ADDR'];
$remote_host = gethostbyaddr($_SERVER['REMOTE_ADDR']);
DB::Execute('INSERT INTO utils_attachment_download(attach_file_id,created_by,created_on,download_on,description,ip_address,host_name) VALUES (%d,%d,%T,%T,%s,%s,%s)',array($id,Acl::get_user(),$t,$t,$disposition,$remote_address,$remote_host));
$f_filename = DATA_DIR.'/Utils_Attachment/'.$filename;
if(!file_exists($f_filename))
die('File doesn\'t exists');
$buffer = file_get_contents($f_filename);
if($crypted) {
$password = $_SESSION['client']['cp'.$rec['id']];
$buffer = Utils_AttachmentCommon::decrypt($buffer,$password);
if($buffer===false) die('Invalid attachment or password');
}
$buffer_size = strlen($buffer);
$g_auth = Utils_AttachmentCommon::get_google_auth();
if ($g_auth) {
DB::StartTrans();
$view_row = DB::GetRow('SELECT id, view_link FROM utils_attachment_googledocs WHERE note_id=%d', array($id));
if (empty($view_row)) {
$view_doc = null;
DB::Execute('INSERT INTO utils_attachment_googledocs (view_link, note_id, doc_id) VALUES (%s, %d, %s)', array('', $id, ''));
$uag_id = DB::Insert_ID('utils_attachment_googledocs','id');
} else {
$view_doc = $view_row[1]?$view_row[1]:'';
}
DB::CompleteTrans();
$wait = 15;
$time = microtime(true);
if ($view_doc==='' && $wait > 0) {
