Пример #1
0
?>

					<?php 
if (!$is_ajax) {
    ?>
						<?php 
    if ($related_tables) {
        ?>
						<?php 
        $i = 0;
        ?>
							<tr>
								<td style="text-transform:uppercase; font-weight:bold; font-size:10px;">Note: Once you submit, you will be able to add <?php 
        foreach ($related_tables as $rt) {
            $i++;
            echo humanizer($rt->table_name) . ($i == sizeof($related_tables) ? '&nbsp;' : ',&nbsp;');
        }
        ?>
</td>
							</tr>
						<?php 
    }
    ?>
					<?php 
}
?>
				</table>
		</td>
	</tr>
</table>
Пример #2
0
				<?php 
if (isset($s_status)) {
    ?>
					<div class="<?php 
    echo $s_status;
    ?>
"><?php 
    echo urldecode($s_message);
    ?>
</div>
				<?php 
}
?>
			
				<p>Refunds for <?php 
echo singular(humanizer($table_name));
?>
 # <?php 
echo remove_semicol($dataid);
?>
</p>
				<table style="width:100%" class="borderless">
					<tr><td style="width:150px;">Grand Total:</td><td>$<?php 
echo my_number_format($grand_total);
?>
</td></tr>
					<tr><td>Refunds to date:</td><td>$<?php 
echo my_number_format($refunded);
?>
</td></tr>
					<tr><td>Shipping Refund:</td><td>$<input size="3" class="max_num" max="<?php 
Пример #3
0
        echo form_open(base_url() . '_search', 'method="get" class="_searchform"');
        ?>
			<span class="big_input"><input type="text" value="search..." name="search" class="_search"/></span>
			<span class="big_select">
				<select name="table" class="searchtable">
					<?php 
        $dataset = $this->db->query("SELECT table_name FROM cms_table_rules where is_hidden=0")->result();
        ?>
					<?php 
        foreach ($dataset as $data) {
            ?>
						<option value="<?php 
            echo $data->table_name;
            ?>
">in <?php 
            echo humanizer(plural($data->table_name));
            ?>
</option>
					<?php 
        }
        ?>
				</select>
			</span>
			<input type="submit" value="Go &rsaquo;"/>
			<?php 
        echo form_close();
        ?>
		<?php 
    }
    ?>
	</div>
Пример #4
0
	<input type="hidden" name="__keyword_primary_table" value="<?php 
echo $primary_table;
?>
"/>
	<input type="hidden" name="__keyword_primary_table_id" value="<?php 
echo $primary_table_id;
?>
"/>
	<?php 
// now display normal form
?>
	<?php 
foreach ($fields as $field) {
    ?>
		<?php 
    echo humanizer($field->COLUMN_NAME);
    ?>
:<br/>
		<?php 
    if ($field->DATA_TYPE == 'int' || $field->DATA_TYPE == 'varchar' || $field->DATA_TYPE == 'tinyint' || $field->DATA_TYPE == 'bigint' || $field->DATA_TYPE == 'timestamp' || $field->DATA_TYPE == 'datetime') {
        ?>
			<input type="text" class="proxy_contents" name="<?php 
        echo $field->COLUMN_NAME;
        ?>
" value="<?php 
        echo $field->COLUMN_DEFAULT;
        ?>
"/><br/>
		<?php 
    } elseif ($field->DATA_TYPE == 'longtext' || $field->DATA_TYPE == 'mediumtext' || $field->DATA_TYPE == 'text') {
        ?>
Пример #5
0
function searchFields($data)
{
    $data = (array) $data;
    $field_structure = array('name' => $data['column_name'], 'id' => $data['column_name']);
    if ($data['data_type'] == 'varchar' || $data['data_type'] == 'text') {
        $ret = "<td>" . humanizer(singular($data['table_name']) . ' ' . $data['column_name']) . ':</td><td>' . form_input($field_structure, isset($_POST[$data['column_name']]) ? $_POST[$data['column_name']] : '') . "</td>";
    }
    if ($data['data_type'] == 'timestamp' || $data['data_type'] == 'datetime') {
        $tfield_structure1['size'] = 12;
        $tfield_structure1['name'] = "__from_" . $data['column_name'];
        $tfield_structure2['size'] = 12;
        $tfield_structure2['name'] = "__to_" . $data['column_name'];
        $ret = "<td>" . humanizer($data['column_name']) . " Between:</td><td>" . form_input($tfield_structure1, isset($_POST["__from_" . $data['column_name']]) ? $_POST["__from_" . $data['column_name']] : '', 'class="date1"') . " and " . form_input($tfield_structure2, isset($_POST["__to_" . $data['column_name']]) ? $_POST["__to_" . $data['column_name']] : date('m/d/Y', time()), 'class="date2"') . '</td>';
    }
    if ($data['data_type'] == 'int' || $data['data_type'] == 'decimal') {
        $tfield_structure1['size'] = 3;
        $tfield_structure1['name'] = "__min_" . $data['column_name'];
        $tfield_structure2['size'] = 3;
        $tfield_structure2['name'] = "__max_" . $data['column_name'];
        $ret = "<td>" . humanizer($data['column_name']) . " Between:</td><td>" . form_input($tfield_structure1, isset($_POST["__min_" . $data['column_name']]) ? $_POST["__min_" . $data['column_name']] : '', '') . " and " . form_input($tfield_structure2, isset($_POST["__max_" . $data['column_name']]) ? $_POST["__max_" . $data['column_name']] : '') . '</td>';
    }
    if (isset($ret)) {
        return $ret;
    }
}
Пример #6
0
    ?>
						<tr><td>&nbsp;</td><td><?php 
    echo form_submit('', 'Search');
    ?>
</td></tr>
					</table>
				</form>
			<?php 
}
?>

			<?php 
if (!$data) {
    ?>
				<p>There are no <?php 
    echo humanizer($table_name);
    ?>
 available.</p>
			<?php 
} else {
    ?>
			
			<p class="flash_bar" style="display: none; float: right; width:40%; margin-top: -40px;">Sorted order has been updated successfully!</p>

				<?php 
    $i = 0;
    $close_tbody = 0;
    ?>
				<?php 
    echo form_open(base_url() . 'masstrash/' . $table_name, 'class="sortable_form"');
    ?>
Пример #7
0
									<?php 
        foreach ($bubble_data as $bubbles) {
            ?>
										<span class="bubble_divided"><?php 
            echo $bubbles->{$sec_identifier};
            ?>
&nbsp;&nbsp;<img src="/media/images/small_x.png"/></span>
									<?php 
        }
        ?>
								</div>
								<span contenteditable="true" class="quick_adder <?php 
        echo $sec_identifier;
        ?>
" style="">&nbsp;&nbsp;</span><span class="help_text"><a href="#">Add <?php 
        echo strtolower(singular(humanizer($sec_table)));
        ?>
</a></span>
							</td>
						</tr>
						<?php 
    }
    ?>
					</tbody>
						<?php 
}
?>

					<tbody class="extra_parameters">
					<?php 
if ($related_tables) {
Пример #8
0
        $i++;
        ?>
				<?php 
    }
    ?>
			<?php 
}
?>
		</td>
	</tr>
</table>

<ul style="display: none;">
	<?php 
foreach ($tables as $table) {
    ?>
	<li><a href="<?php 
    echo base_url();
    ?>
content/<?php 
    echo $table->table_name;
    ?>
"><?php 
    echo humanizer(plural($table->table_name));
    ?>
</a></li>
	<?php 
}
?>
</ul>
Пример #9
0
"><?php 
    echo $labels[$s];
    ?>
</h1>
				<table width="100%;">
					<?php 
    foreach ($detailed_report as $th) {
        ?>
						<?php 
        $th = (array) $th;
        ?>
						<tr><?php 
        foreach ($th as $header => $name) {
            ?>
<th><?php 
            echo $head = $header == 'id' ? trim($labels[$s]) : humanizer($header);
            ?>
</th><?php 
        }
        ?>
</tr>
						<?php 
        break;
        ?>
					<?php 
    }
    ?>
					<?php 
    foreach ($detailed_report as $th) {
        ?>
						<tr>
Пример #10
0
					<?php 
}
?>
					
					<?php 
if ($key == 'PRI') {
    ?>
					<?php 
    $linking = $this->ContentModel->getIdentifier($pritable);
    ?>
						<td style="border:0; border-bottom: 1px solid #DDD; padding-bottom: 15px;">
						<?php 
    if ($items) {
        ?>
							<div style="float: right; width:49%;">Click on <?php 
        echo singular(humanizer($pritable));
        ?>
 below to add to "<?php 
        echo $objectname;
        ?>
"</div><br clear="all"/>
							
								<select class="multipleselect" multiple="multiple" name="<?php 
        echo $pritable;
        ?>
[]" id="<?php 
        echo $pritable;
        ?>
">
								<?php 
        foreach ($items as $item) {
Пример #11
0
    echo $s_status;
    ?>
"><?php 
    echo urldecode($s_message);
    ?>
</div>
			<?php 
}
?>
			
			<form method="post">			
			<?php 
if (!$data->is_captured) {
    ?>
				<p><strong><?php 
    echo humanizer(singular($table_name));
    ?>
 Information:</strong></p>
				<?php 
    if ($data->is_voided) {
        ?>
<p class="red">Note: This transaction has been voided.</p><?php 
    }
    ?>
				<p>Tracking Number:&nbsp; <input type="text" name="tracking_number"/></p>
				<p><input type="checkbox" name="notify_email" checked="checked"/>Also notify customer via email.</p>
				<p><input name="_action" type="submit" onclick="blockade()" value="Add Tracking Number"/>&nbsp;&nbsp;<input name="_action" type="submit" value="Cancel"/></p>
			<?php 
} else {
    ?>
				<p><strong>Note: </strong>This transaction has already been captured.</p>
Пример #12
0
                    ?>
								<?php 
                    if ($pdata_id == $prelated_id) {
                        ?>
									<strong><?php 
                        echo humanizer($pdata_id);
                        ?>
:</strong>&nbsp;<?php 
                        echo humanizer($pdata_content);
                        ?>
<br/>
								<?php 
                    } else {
                        ?>
									<strong><?php 
                        echo humanizer($pdata_id);
                        ?>
:</strong><br/>
									<?php 
                        $fielddef = $this->ContentModel->getFieldType($ptablename, $pdata_id);
                        ?>
									<?php 
                        if ($fielddef->data_type == 'int' || $fielddef->data_type == 'varchar' || $fielddef->data_type == 'tinyint' || $fielddef->data_type == 'bigint' || $fielddef->data_type == 'timestamp' || $fielddef->data_type == 'datetime') {
                            ?>
										<input type="text" class="proxy_contents" name="<?php 
                            echo $pdata_id;
                            ?>
" value="<?php 
                            echo $pdata_content;
                            ?>
"/><br/>
Пример #13
0
 function massuntrash($table)
 {
     checklogin();
     if (!can_update($table)) {
         redirect(base_url() . 'content/' . $table . '/:error:' . urlencode('Sorry. You do not have permissions to update things from ' . humanizer($table)));
         exit;
     }
     if (!$_POST || !$_POST['ids']) {
         redirect(base_url() . 'content/' . $table);
         exit;
     }
     $table = mysql_real_escape_string($table);
     $id = mysql_real_escape_string($id);
     $parent_tables = $this->db->query("SELECT COLUMN_NAME, REFERENCED_COLUMN_NAME, REFERENCED_TABLE_NAME FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_NAME='{$table}' AND REFERENCED_TABLE_NAME IS NOT NULL")->result();
     foreach ($_POST['ids'] as $id) {
         /*** remove this object from trash ***/
         $this->db->query("UPDATE {$table} SET __is_trash=0 WHERE id='{$id}' LIMIT 1");
         //	$this->memcached_library->flush();
         /*** remove object parent from trash ***/
         if ($parent_tables) {
             foreach ($parent_tables as $parent_table) {
                 $c = $parent_table->COLUMN_NAME;
                 $parent_id = $this->db->query("SELECT {$c} FROM {$table} WHERE id='{$id}' LIMIT 1")->row()->{$c};
                 //TODO: bug: check if parent doesn't have trash
                 $this->db->query("UPDATE {$parent_table->REFERENCED_TABLE_NAME} SET __is_trash=0 WHERE {$parent_table->REFERENCED_COLUMN_NAME}='{$parent_id}'");
                 //$this->memcached_library->flush();
             }
         }
     }
     redirect(base_url() . 'content/' . $table . '/:success:' . urlencode('Items have been removed from trash.'));
 }
Пример #14
0
' from <?php 
    echo $proper_table_name;
    ?>
, the following will be modified and/or deleted:</p>
	<ul>
		<?php 
    //two loops had to be done for related tables and actual tables
    ?>
		<?php 
    foreach ($related_tables as $related_table) {
        ?>
			<?php 
        if ($table != $related_table->table_name) {
            ?>
				<?php 
            $proper_related_table_name = humanizer(plural($related_table->table_name));
            ?>
				<?php 
            $tdata = $this->db->query("SELECT TABLE_NAME, IS_NULLABLE, COLUMN_KEY, COLUMN_NAME FROM information_schema.COLUMNS WHERE TABLE_SCHEMA='" . DATABASE . "' AND TABLE_NAME='" . $related_table->table_name . "' AND COLUMN_NAME='{$table_linking_name}'")->row();
            ?>
				
				<?php 
            if ($tdata) {
                ?>
				
					<?php 
                if ($tdata->COLUMN_KEY == 'MUL') {
                    ?>
						<li style="font-size:1.2em;">
							<?php 
                    if ($tdata->IS_NULLABLE == 'NO') {
Пример #15
0
 function refund($table_name = FALSE, $id = FALSE)
 {
     if ($table_name == FALSE || $id == FALSE) {
         redirect(base_url());
     }
     $table_details = 'order_details';
     if ($_POST && $_POST['_action'] == 'Cancel') {
         redirect(base_url() . 'content/' . $table_name);
     }
     if ($_POST && $_POST['_action'] == 'Process Refunds') {
         $order_details_refund = array();
         $grand_refund = 0;
         $r_subtotal = 0;
         if (key_exists('items', $_POST)) {
             foreach ($_POST['items'] as $oid => $products) {
                 //get the amount that is supposed to be refunded in this trans and the corresponding order_detail_id
                 $order_details_refund[$products] = $_POST[$products];
                 $grand_refund += $_POST[$products];
             }
         }
         $r_subtotal = $grand_refund;
         if (key_exists('shipping_amount', $_POST)) {
             $grand_refund += $_POST['shipping_amount'];
             $r_shipping_amount = $_POST['shipping_amount'];
         }
         if (key_exists('tax_amount', $_POST)) {
             $grand_refund += $_POST['tax_amount'];
             $r_tax = $_POST['tax_amount'];
         }
         //get the user information
         $data['user'] = $this->db->query("SELECT * FROM {$table_name} o LEFT JOIN users u on u.id=o.user_id LEFT JOIN user_address ua ON ua.user_id=u.id WHERE o.id='{$id}'")->row();
         $process = $this->payment->refund($grand_refund, $data['user']->customer_profile_id, $data['user']->customer_payment_profile_id, $data['user']->transaction_id);
         foreach ($_POST['refund'] as $refundables) {
             $ab = explode('_', $refundables);
             $a = $ab[0];
             $b = $ab[1];
             $this->db->query("UPDATE order_details SET is_returned='{$a}' WHERE id='{$b}'");
         }
         if ($process === TRUE) {
             if (key_exists('notify', $_POST)) {
                 send_email($data['user']->email, SITENAME . " :: Transaction Refunds", 'Refunds of $' . $grand_refund . ' has been refunded to the card with which you used to make this payment. Yay you.', '');
             }
             //update details
             foreach ($order_details_refund as $r_id => $r_amount) {
                 $this->db->query("UPDATE order_details SET refunded_amount=refunded_amount+{$r_amount} WHERE id='{$r_id}'");
             }
             $this->db->query("UPDATE orders SET refunded_shipping_amount=refunded_shipping_amount+{$r_shipping_amount} WHERE id='{$id}'");
             $this->db->query("UPDATE orders SET refunded_tax=refunded_tax+{$r_tax} WHERE id='{$id}'");
             $this->db->query("UPDATE orders SET refunded_sub_total=refunded_sub_total+{$r_subtotal} WHERE id='{$id}'");
             $this->db->query("UPDATE orders SET is_voidable=0");
             redirect(base_url() . 'process/refund/' . $table_name . '/' . remove_semicol($id) . ':success:' . urlencode("This item has been refunded successfully!"));
         } elseif ($grand_refund < 1) {
             if (key_exists('notify', $_POST)) {
                 send_email($data['user']->email, SITENAME . " :: Transaction Returns", 'We reveived the items you returned and have updated our records!', 'We reveived the items you returned and have updated our records!');
             }
             redirect(base_url() . 'process/refund/' . $table_name . '/' . remove_semicol($id) . ':note:' . urlencode("No refunds were made. Returns have been updated successfully."));
         } else {
             redirect(base_url() . 'process/refund/' . $table_name . '/' . remove_semicol($id) . ':error:' . urlencode("{$process} Please process them manually with the payment processor."));
         }
     }
     //**addition for cms styles: keep this comment incase of clashes **//
     $table_name = mysql_real_escape_string($table_name);
     $data['group'] = $this->db->query("SELECT * FROM " . DATABASE_MENU_GROUPS . " WHERE id=(SELECT group_id FROM " . DATABASE_TABLE_RULES . " WHERE table_name='{$table_name}' LIMIT 1)")->row();
     //backwards
     $data['groups'] = $this->db->query("SELECT * FROM " . DATABASE_MENU_GROUPS)->result();
     $data['tables'] = $this->db->query("SELECT m.table_name FROM " . DATABASE_TABLE_RULES . " m JOIN " . DATABASE_MENU_GROUPS . " n ON n.id=m.group_id WHERE m.is_hidden=0 AND n.id=(SELECT group_id FROM " . DATABASE_TABLE_RULES . " WHERE table_name='{$table_name}' order by `order` LIMIT 1)  order by `order`")->result();
     //** end addition for cms styles: keep this comment incase of clashes **//
     $meta['page_title'] = 'Refund';
     $meta['breadcrumbs']['content/' . $table_name] = plural(humanizer($table_name));
     $meta['breadcrumbs']['none'] = 'Refund';
     $data['table_name'] = $table_name;
     $data['dataid'] = $id;
     $data['object'] = $this->db->query("SELECT * FROM {$table_name} o LEFT JOIN users u on u.id=o.user_id WHERE o.id='{$id}'")->row();
     $data['object_details'] = $this->db->query("SELECT od.id as order_details_id, od.amount, od.refunded_amount, od.is_returned, od.is_refundable, p.name FROM order_details od JOIN upc u on u.id=od.upc_id JOIN products p ON p.id=u.product_id WHERE od.order_id='{$id}'")->result();
     $data['grand_total'] = $data['object']->sub_total + $data['object']->tax + $data['object']->shipping_amount;
     $data['refunded'] = $data['object']->refunded_sub_total + $data['object']->refunded_tax + $data['object']->refunded_shipping_amount;
     $data['max_shipping_refund'] = $data['object']->shipping_amount - $data['object']->refunded_shipping_amount;
     $data['max_tax_refund'] = $data['object']->tax - $data['object']->refunded_tax;
     $data['refunded_shipping_amount'] = $data['object']->refunded_shipping_amount;
     if (stripos(uri_string(), ':')) {
         $mess = explode(':', uri_string());
         if (count($mess) > 2) {
             $data['s_message'] = $mess[2];
             $data['s_status'] = $mess[1];
         }
     }
     $this->load->view('includes/header', $meta);
     $this->load->view("process/refundview", $data);
     $this->load->view('includes/footer');
 }
Пример #16
0
 function getProperTableNameSingular($table_name)
 {
     return humanizer(singular($table_name));
 }